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

[MRFowler]

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?

[v-micsh-msft]

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,

[MRFowler]

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)

[MRFowler]

Anyone have any further thoughts on this?