Tuesday, June 8, 2021

Power App error: the app you trying to open was saved with newer version of powerapps and cannot be opened..

1. Create a new app with new  version, after publish to SharePoint, customized it again take the URL from, while editing like below:

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

https://us.create.powerapps.com/studio/?action=sp-edit-formdata&app-id=e77ea2fa-0bdd-477b-9b08-815a772c20ad&correlation-id=50e36e54-80f3-43fb-a680-2c7239d0926e&redirect-reason=WebAuth.NewInstanceRedirect&environment-name=Default-709c2643-b1a9-4415-ad0f-521cfa6ba3f5&environment-update-cadence=Frequent

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


2. Now open your App from from form settings option:

Modify form in PowerApps:

Copy the URL while editing,  and the version like blow in URL highlighted

https://us.create.powerapps.com/v3.21054.31.188965150/studio/?action=sp-edit-formdata&app-id=2609a1de-5a2b-4087-b256-0cafc9b1e6d0&correlation-id=72ff7fe3-f7df-46ff-8825-f3766ca22a62&redirect-reason=WebAuth.NewInstanceRedirect&environment-name=Default-709c2643-b1a9-4415-ad0f-521cfa6ba3f5&environment-update-cadence=Frequent

and now open you app. it will work.






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)

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