Refreshing form based on variable after submit

(0) Share

Report

Posted on by dbarnesab

Hi guys,

I have a form that pulls from a variable that is populated from my SharePoint data source when selected from a gallery (OnSelect = Set(globalCurrentRecord,ThisItem)).

Whilst the data source updates automatically when the form is submitted, the variable then needs updating using Set(globalCurrentRecord, TicketsGal.Selected).

My problem is, when I chain this function on the back of the button I am using to save the form, it doesn't appear to update. If I add this function to a button on it's own however, it works correctly and updates.

Example:

Data source and gallery values updating correctly:

Variable not updating after Set is trigged after the SubmitForm:

Set not working.mp4

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

YordiVN 12 on at

Like (0)

Report
Copy link

Link copied!
Hi dbarnesab,

the gallery is probably not refreshed yet when the Set function has been called.

Here are a couple of possible sollutions to your problem:

In the set do a lookup on your datasource to get the latest update:
Set(GlovalCurrentRecord, LookUp(DataSource, Id = TicketsGal.Selected.Id));

Refresh the datasource before the set:
Refresh(DataSource); Set(GlobalCurrentRecord, TicketsGal.Selected);

Reset you gallery and adjust the default selected item:

Reset Gallery before set
Reset(TicketsGal); Set(GlobalCurrentRecord, TicketsGal.Selected);

Gallery default item
If(IsBlank(GlobalCurrentRecord), Blank(), LookUp(DataSource, Id = GlobalCurrentRecord.Id))

Was this reply helpful? Yes No
enriqueglopez 516 Moderator on at

Like (0)

Report
Copy link

Link copied!
You have to refresh the item after is updated in SharePoint. Substitute your Set(globalCurrentRecord, TicketsGal.Selected) with this:

Set(globalCurrentRecord, LookUp(YourList, ID = globalCurrentRecord.ID))

This will search the item using the ID and refresh the properties of your variable at the end.

Was this reply helpful? Yes No
dbarnesab 46 on at

Like (0)

Report
Copy link

Link copied!

Thanks you for the quick response. I've just tried this method with unfortunately no success. I agree it is clearly something to do with timings. It is as if the Set function is being ran before the data is updated.

I have also tested forcing in a Refresh of the data set first (although this will be done on save anyway) with no change.

Kind regards,

Dan

Was this reply helpful? Yes No
enriqueglopez 516 Moderator on at

Like (2)

Report
Copy link

Link copied!

dbarnesab try to add that Set() in the OnSuccess property of the Form that you are submitting.

That will guarantee that the code is executed after the form is (successfully) submitted.

Was this reply helpful? Yes No
timl 36,774 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi dbarnesab

The method that enriqueglopez describes (calling Set in the OnSuccess of the form) is the correct approach.

To add to this, you would reference the LastSubmit property of the form to return the record that was just added.

The OnSuccess formula would look like this:

Set(globalCurrentRecord, Self.LastSubmit)

1 people found this reply helpful.

Was this reply helpful? Yes No
CU08010028-0 2 on at

Like (0)

Report
Copy link

Link copied!

Timl, thanks so much for that last one!

Was this reply helpful? Yes No
WarrenBelz 154,787 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @dbarnesab,

There is a much simpler and more reliable method of ensuring the data in your Form refreshes - set the Item of the Form to directly look up the data source
LookUp( 'Pre-Sales Booking In', ID = globalCurrentRecord.ID )

Any action on the Form will automatically re-query the data source. It is also a good idea (as @timl has suggested) to reset the Variable OnSuccess of the Form to pick up any field changes (although the ID will not change, so the form will still refresh).

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No