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

PowerApps Form Lookup Fields not Refreshing on Form Edit Until Source Lookup Is Updated

Hello

 

I'm having a small problem with a form I recently built which has several uneditable lookup fields which are dependent on a dropdown, i.e. the 'Default' field is: LookUp('Dosimetry Locations','Location Code'=LocCodeDropDown.Selected.Result,Area). (It's built this way to function as a cascading lookup/dropdown, so using the standard Sharepoint 'Lookup' column isn't an option.)

 

It works great normally. I make the selection in LocCodeDropDown, and all the fields populate, and save properly.

 

The issue is with editing - when I open a form entry to edit, the LocCodeDropDown maintains the previously selected value, but the LookUp fields are blank unless I re-select the dropdown choice. Not a big deal, but sometimes I need to edit many at once, and missing this step can mess things up.

 

(Note: They actually do update properly prior to saving, so it almost isn't an issue, except that there are conditional fields which don't seem to see these updates in time to update itself, so then they save themselves incorrectly, which winds up with minor incidents filing themselves as major ones.)

 

Anyway - Is there a way to have all the LookUp functions in the form refresh themselves upon having the form open for editing? Seems like this would be the best way to solve, but I don't know what function to use and in which element.

 

I have tried adding Refresh() fields including all linked data sources to the OnView and OnEdit fields for the SharePointIntegration property, as per some other threads, but that didn't help.

 

Thanks in advance.

3 REPLIES 3
bgrover
New Member

did you ever find a solution? I have a similar issue where on an edit form two lookup fields occasionally will come up blank. This just happens once in a while.

Unfortunately not. I'm assuming there is some sort of refresh I can apply, but I don't know enough about the available tools to figure it out.

bgrover
New Member

Thanks. I may try to store the lookup values in variables and then apply the variable to the field. I will also try a secondary form reset to see if that helps. I’ll let you know if I solve it.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,121)