Power Apps: App on start collection (Over coming the 2000 records limitation from any db in power app)

 

1. first Create collection on onStart of App and click on  runonstart option from 3 dots.

# sharepoint list have column batchid for filtering purpose

=====================================================

Concurrent(ClearCollect(KT1,Filter(TKM_V_Lookup_ExcelData,BatchId=10)),

ClearCollect(KT2,Filter(TKM_V_Lookup_ExcelData,BatchId=15)),

ClearCollect(KT3,Filter(TKM_V_Lookup_ExcelData,BatchId=20)));

ClearCollect(KITData,KT1,KT2,KT3);

=====================================================

2. Bind dropdown on items: KITData collection  (showing KIT Number)

     Distinct(KITData,KIT_NUMBER).Result

3. if you have cascading ddl then, on Items:   (showing Contract Number)

Filter(KITData,KIT_NUMBER=ComboBox1.Selected.Result)

4. Bind other text fields on default:

-------------------------------------------------------

If( SharePointForm1.Mode = FormMode.New || SharePointForm1.Mode = FormMode.Edit,

    ( If( (!IsBlank(ComboBox2.SelectedItems)),  Concat( ComboBox2.SelectedItems,

            'CONTRACT_ NUMBER'   ),  Parent.Default ) ),    Parent.Default)

-------------------------------------------------