Extract updated fields from form

(0) Share

Report

Posted on by Jedediah

183

Hello 🙂

I'm building an app with several forms linked to a SharePoint list for our onboarding.

I would like to notify some users when changes are made to the list items.

Let's say our HR department updates the "Manager" field of the new collaborator, I would like to notify (by mail) the IT department that HR have updated the list item and highlight the updated fields, so the IT department knows which field have changed since last time they have been notified (they are notified for every update).

I already managed to send the email with the content of each fields but I'm looking for a way to only highlight the items that have been updated.

Is there a way to achieve this ?

Thank you 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Jedediah ,

It is really a matter of setting a Variable OnChange of each control and then testing for this Variable to be true in the email content.

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Jedediah 183 on at

Like (0)

Report
Copy link

Link copied!

Hello @WarrenBelz !
Thanks for this fast answer !

This is the only solution I found but since you mention it, should I conclude there is no alternative ?

Edit :
I may have found a solution by using the control directly :
- Default of the parent item of the control to get the original value.
- Value of the text input to get the updated value.
Just need to trigger the mail before submitting the form and it should be good ?

Edit 2 :
My solution only works for text and date (via Text() function) fields. The "ThisItem.Default" doesn't work for dropdown fields unfortunately...

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

Like (0)

Report
Copy link

Link copied!

@Jedediah ,

Yes, there are many ways of doing it, but I personally would go with the Variables.

Was this reply helpful? Yes No
Jedediah 183 on at

Like (0)

Report
Copy link

Link copied!

Thank you again Warren 🙂
I finally managed to do it with Power Automate.

Was this reply helpful? Yes No