Update column after submit form

(0) Share

Report

Posted on by atray13

147

Hi,

I am trying to get my app to work so that upon submission of a form, it updates the edited record with a flag to idenfity which records have been changed and which have not.

So I would have a column 'Edited Flag', which is automatically 0 (or just blank if that's not possible), and when a said record has been edited and the form submitted, this then get's changed to 1, to signify that this record has been changed.

I have been trying to use something like updatecontext, and set functions but can't find the correct formula. What would the formula need to look like?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Rahber 1,935 on at

Like (2)

Report
Copy link

Link copied!

How about on your form, you add an invisible label whose value will be always 1.

And when you submit the form it will take the value 1 and update the source just like its updating the other fields in the form.

So when you are adding a new Entry in Form the default value of label should be 0 and when editing it it should be 1.

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like (3)

Report
Copy link

Link copied!
@atray13

Put this code in the OnSuccess property of the Edit Form

Patch(your_datasource_name, LookUp(your_datasource_name, ID=Form1.LastSubmit.ID), {'Edit Flag': 1})

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
atray13 147 on at

Like (0)

Report
Copy link

Link copied!

Worked thank you

Was this reply helpful? Yes No
webbedfeetmaest 81 on at

Like (0)

Report
Copy link

Link copied!

Thanks for this. Worked a charm.

Was this reply helpful? Yes No
andrejmfreitas 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you! It worked as a charm.

Was this reply helpful? Yes No