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).
Thoughts/Help?
Hi @MRFowler,
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?
Best regards,
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)
Anyone have any further thoughts on this?
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
198 | |
172 | |
60 | |
32 | |
32 |
User | Count |
---|---|
334 | |
271 | |
103 | |
71 | |
56 |