Hey guys, some help on this would be greatly appreciated as i'm new to the Power Platform space and super stuck!
I'm working on a flow with the goal to email an admin when an item has changed in a staff info sharepoint list, with information on:
- what Item has changed.
- The previous value of that item (would be nice but just the new value would suffice)
- The new value of the changed item.
Currently, the flow is triggered on modification of an item in the SP list, and uses the 'get changes for an item or file (properties only)' action to check whether any of the items have changed. If true, it emails an admin to notify that an item has been changed then shows all items.
The issue is that this doesn't show the actual value of which specific item was updated. For example, say an Address is updated, the email should contain: 'The item: A was changed to X' (from the previous Y would be nice with some sort of most recent version history grabbed? but not as important as getting this new value and the specific item that changed in).
I have tried using a switch statement to check if each item was the one changed, and if it was, hard code the name of the changed item, but it nests it in a 'for each' loop, spamming emails...
If anyone has any advice that would be greatly appreciated! Thanks so much.