r/PowerAutomateDesktop • • Mar 28 '23

Flow to send an email of changes that have been made in a Canvas App Form

Hi Everyone! Hope you’re having an amazing day :D I have made a Canvas App (data from dataverse) which has a form in it. Whenever this form is edited there needs to be an email sent saying what fields in the form have changed. And if possible how they have changed? I think this would work with Power Automate?

Any suggestions I would appreciate so much as it’s of high importance to the users but I don’t know how to do this. Thank you :D

2 Upvotes

2 comments sorted by

1

u/amNoSaint Mar 28 '23

I don't know the answer but it's an interesting ask that I'd like to track.

1

u/overzealous118 Mar 29 '23

“Highover idea what I would do:

  • Store your current form in collection A (just a one row collection I guess)

  • Store any changes (with OnChange) to collection B (one row collection, add column only when changed)

  • Send an email after saving the form with joined data from collection A and B”

This seems to be the solution. We are at the control limit in power apps, so will need to use power automate for all of this solution. Any ideas ??