Application is connected to multiple SharePoint lists for data source. Periodically, we must update the data in these lists as new or updated information is published by the state. After updating list, application is no longer showing data from Lookup fields in the updated lists for existing records. The lists were updated by deleting existing records and inserting updated records from SharePoint via QuickEdit copy/paste.
We don't want existing records to redo lookups, rather only new records. Old records should retain existing data values.
It seems as though the application is storing a record pointer for the lookup fields instead of the looked up data itself.
Not sure if this is problem re-connecting to updated SharePoint data sources (Lists were not deleted, just data within the lists, so field definitions should remain intact).
Would you please share more details here for the mentioned "Lookup fields"?
Is it the Choice/Lookup/Person or group type,
or you are talking about the Lookup () function in PowerApps?
For the lookup field, it is recommended to take use of Combo Box to deal with the related data, if here you are talking about the lookup function, would you please share the formula details here?
Fields in datasource (SharePoint list) are Choice fields
PowerApps application is doing a Lookup() function using a ComboBox as the control with the following type of formula for DefaultSelectedItems:
If(AddEditForm.Mode = FormMode.New, LookUp(Choices(MedicaidDataRecords.ProviderSelection), Value = ProviderName), Parent.Default)
Check out these cool Power Apps & vote on your favorite!
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021