Set(VarRecord, This Item) to Replace BrowseGallery1

(0) Share

Report

Posted on by Sajarac

3,271

Hi community.

I was checking a video from Shane Young

And he mentioned that is better to start replacing the onselect = Navigate.........

by:

Set(varRecord, ThisItem);Navigate......

then in the target form items = VarRecord

Basically replacing Gallery1.selected.

He said that this method is better and secure.

Now my question is?

I did that and my target form is a form. After press to EDIT the form and save the changes the updates didn't come up. I have to go back select the item again and after that I can see the changes.

How can I fix this? I have tried Refresh etc but nothing works.

Thanks in advance,

Regards,

Categories:

Building Power Apps

I have the same question (0)

All responses (17)

Answers (1)

Community Power Pla... on at

Like (1)

Report

@sajarac
In the OnSuccess property of your form add this code

Set(VarRecord, yourFormName.LastSubmit)

Change 'yourFormName' to the name of your form.

Was this reply helpful? Yes No
Sajarac 3,271 on at

Like (0)

Report

Hi there, any other possible solution? my form is acting weird after I have implemented this option ?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@sajarac
In the Item property of the edit form: Lookup(datasource, ID=VarRecord.ID) and make sure the datasource in the Form is the same one as referenced in the Item property.

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

Like (0)

Report

@sajarac
Define '...acting weird ...'. I use this throughout my apps without any issues

Was this reply helpful? Yes No
Sajarac 3,271 on at

Like (0)

Report

Thank you.
@Drrickryp @Anonymous
I did the Lookup addendum, it seems like is working a little bit better just one thing is not working fine. In the form I have 3 Dropdowns they work in a cascade way. I noticed that those 3 are keeping the last information saved. But if I put the form in edit mode and cancel or save the it show the right value.

Any idea?

Thank you

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

Like (0)

Report

@sajarac
Sounds like the issue will be to do with the Default properties of those dropdowns.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@sajarac

In the OnSuccess property of the form, put ResetForm(Form1). When the form is submitted successfuly, all of the controls on it will be reset to their default properties. As a alternative, you can reset each control individually using Reset(Dropdown1); Reset(Combobox1); Reset(Combobox2).

Was this reply helpful? Yes No
Sajarac 3,271 on at

Like (0)

Report

I did a Refresh in between changes and it shows the right information.

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report
Hi @sajarac ,

Have you solved your problem?

Based on the issue that you mentioned, I think this issue is related to the varRecord variable. If you update the selected record using your Edit form, you should also update the varRecord variable to the updated record simultaneously, otherwise, this varRecord variable would still store previous record.

So please consider set the OnSuccess property of the Edit form to following:

Set(varRecord, EditForm1.LastSubmit) // update the varRecord variable to the updated record

Set the Item property of the EditForm1 to following:

varRecord

Actually, it is not necessary to store the whole selected record into a variable, instead, you could consider save the PrimaryKey column value of the selected record into a variable. Please also consider try the following workaround:

Set the OnSelect property of the Gallery to following:

Set(varPrimaryKey, ThisItem.PrimaryKeyColumn)

Set the Item property of the Edit form to following:

LookUp('Your Data Source', PrimaryKeyColumn = varPrimaryKey)

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

Best regards,

Was this reply helpful? Yes No
Kathomsen 35 on at

Like (0)

Report

I am using the Set(varRecord) for navigation also. It was working yesterday, but now my Patch statement to update my form (see OnSuccess below) is no longer working. Not sure what happened, nor how to resolve it.

Was this reply helpful? Yes No