Answered

Filtered gallery.selected bug and consequences

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

So I am working from a filtered gallery

Filter('Prequal Approvals-DEV', 'Resp. Manager'.Email=User().Email || 'Resp. Executive'.Email=User().Email)

and have worked around the issue where the form loads the first record after a patch or submit (see thread1, thread2) by passing the Gallery.Selected into a variable and using that downstream in the forms, patching, etc.

Set(varGallerySelected, MyApprovalsGallery.Selected)
-
-
-
Form Item: varGallerySelected

However...

Now when I patch or submit a form, the changes are saved but the screen and form do not update to show the new saved value.

So far I have tried, without any success:

Adding a Refresh(datasource) to the form's OnSuccess property
Adding a manual refresh button to Refresh(datasource)
Adding a Refresh(datasource) to the screen's OnVisible property

The only thing that works is to go back to the gallery, reselect the same item, and then the downstream screens (multiple edit screens) will show the new saved values. My guess is this is somehow refreshing the variable and associated data but I'm not sure.

So is there a workaround for this workaround bug/consequence? A better way to do all of this? I am open to ideas and suggestions.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about your issue?

Do you mean that the Edit form does not show up the updated record value after your submit your form data?

Based on the issue that you mentioned, I think this issue is related to the varGallerySelected variable that you mentioned. After you submit your form data successfully, you should also need to update the varGallerySelected variable with the updated record value.

I have made a test on my side, please consider take a try with the following workaround:

Set the OnSuccess property of the Edit form to following:

Set(varGallerySelected, EditForm1.LastSubmit)

or

Set(varGallerySelected, LookUp('Your SP List', ID = EditForm1.LastSubmit.ID))

Set the Item property of the Edit form to following:

varGallerySelected

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft you are correct, the form does not update after submitting.

Resetting my variable via OnSuccess to the Form.LastSubmit did the trick though, thank you!

Was this reply helpful? Yes No