cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Support
Community Support

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

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.
Highlighted
Frequent Visitor

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

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)

 

Highlighted
Frequent Visitor

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

Anyone have any further thoughts on this?

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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