Hi all,
So, i feel like i would have a pretty generic use case but can't figure it out.
Whenever a user edits an item in a sharepoint list I would like to have an automated email sent out containing some basic information of the item in the list as well as a table containing all changed columns with their respected previous and new value.
What do I have so far?
- Trigger: when an item or a file is modified
- Get changes for an item or a file with the ID from the trigger and the trigger window start & end token
- Send an HTTP request to Sharepoint to get the previous values for the particular item
I would now want the columns that have been changed from my selected view, so only with value True from the Has Column Changed dynamic content. After that I want to loop through that output (Object in this case) and create my table (just by using a string variable that i will leverage in my email body would be the easiest i guess) and fill my 3 column table containing the Column Name, Previous Value and New Value.
I have an object called itemChanges but this contains all columns, both True and False.
Any help would be greatly appreciated.
Thanks!
Regards,
Hans
