SharePoint List Lookup Value Only Updating When Saving in PowerApps

(0) Share

Report

Posted on by andy1982

Hi,

I have a SharePoint list that has a look up and a related lookup from another SharePoint list.

In the PowerApps form when I change the lookup I expected the related lookup to automatically update, it only updates after the form is saved, making the form look lime it has the wrong value (until saved). Noticed that if you enter data into SharePoint list direct that this behaviours is the same (value appears when saved).

Is there a workaround for the value to the visible in PowerApps before the user saves the form?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @andy1982 ,

Yes this is possible.

Can you please share a screenshot of your form that shows which datacard is changed and which should be then updating accordingly?

Also, please share how both columns are related.
andy1982 36 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer

Thanks for quick reply, added a PDF with info requested, hopefully it makes sense.

The columns are related as each session has a product assigned in a SharePoint list.

Appreciate expert views!

PowerApps Sharepo...
Verified answer

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @andy1982 ,

Thanks for clarifying. As a workaround I would suggest to change the Default(SelectedItems) property of the control that shows the Product to refer the Sessions data source (or whatever the name of the parent column for the 'Session Name' column is) directly with a LookUp function, based on the selected value in the Session Name combo box.

Like that it will display the correct value immediately whilst the data source will be updated only after the form has been submitted.
andy1982 36 on at

Like
a
(1)

Report
Copy link

Link copied!

@BCBuizer Sorry for late response, thank you for answer. This resolved issue as you said and allows me to use value in form to perform some logic.

Massive help!