redirected after saving edit form

[tuonoman]

Hi

To validate an Edit form I use an icon button with a "SubmitForm(EDIT_PRODUCT_FORM)" function.
After clicking on the button I am sent back to another product.

How can I be redirected after saving the modified values?

thanks for your help

[RandyHayes]

@tuonoman 

Yes, you definitely don't want to change the DataSource on that form.  Leave it was it was.  The Item should be glbSelectedItem.  If you put that in that form, do you get an error or other problem?

Tell me where we are now.  

Did you put this formula in the OnSuccess action of the EditForm?

Set(glbSelectedItem, Self.LastSubmit)

[tuonoman]

@RandyHayes 

No Unfortunately the information in the "product detail" form does not go up correctly.
I have an error that says "Invalid formula, book value with "DATA SOURCE" is expected."

I specify that the "datasource" and my table excel "product".

The only information that comes up, comes from the LOOKUP function.

On the edit form, I always have the same problem, after registration I go back to the first product in the list.

Sorry!

[RandyHayes · Accepted solution]

@tuonoman 

Is the Datasource of all the forms PRODUCT?

Also, I was just looking at your Items property of the Gallery again and noticed there are two other added columns beside LineNumber.   We need to drop those as well for the form.

So for your Item property on the form, set to:

Set(glbSelectedItem; First(DropColumns(Table(ThisItem); "LineNumber"; "TAG_NAME"; "PROVIDER_NAME")));;  Navigate('DETAIL PRODUIT'; None)

[tuonoman]

@RandyHayes 

There is something better,
The information goes back correctly on the detail sheet and on the product edition sheet. But during the validation of the modifications brought to the product, I still go back to the product id1

I made some captures

[RandyHayes]

@tuonoman 

I see you have the SubmitForm and setting the glbSelectedItem...that's all good, but how are you getting back to the DETAIL PRODUCT screen and what is the Item property on DetailForm1?  I assume this is the screen you are saying has then reverted back to 1.

[tuonoman]

@RandyHayes 

The Item property on DetailForm1 is “glbSelectedItem”.
Yes when I register a product, I am redirected to an ID1 product screen.
like the previous video

Thanks for your help

[RandyHayes]

@tuonoman 

If your glbSelectedItem variable is being set in the OnSuccess of the EditForm, and your Detail form is based on that variable in the Item, then you should be seeing the proper record in the detail form.  Are you stating that this is not the case now?

[tuonoman]

Hi @RandyHayes 

I wanted to apologize, I had some family problems.

I'm back on my power apps project, the "Set(glbSelectedItem," function has corrected my problems well and allows me to understand certain things.

Thank you very much for your precious help

[RandyHayes]

@tuonoman 

Excellent!  I am glad it is working now and I hope all is well on the family problems too.

[tuonoman]

Yes thank you, children you better.
We nothing. Unbelievable!
Dirty Covid