cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Trouble reconnecting to SharePoint list data source for Lookup fields after updating data source

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?

3 REPLIES 3
Community Support
Community Support

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,

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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?

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (7,572)