Announcements
2
All,
I am trying to post a message to a Slack channel each time SharePoint item gets updated. Message should say something like "Task 'Paint the wall' has been updated. Deadline changed to 5/10/2018, assigned person changed to Bob". Other 10 fields which didn't change should not be mentioned in the message. How can I tell which fields changed?
Thanks!
Hi @Aud,
Do you want to detect which columns have been changed when an item is updated in your SharePoint list?
I agree with @ScottShearer's thought almost, if you want to detect which columns have been changed when an item is updated in your SharePoint list within your flow, I afraid that there is no way to achieve your needs in Microsoft Flow currently.
The "When an item is created or modified" trigger of SharePoint connector could only detect if there are some item updates within your SharePoint list, it could not detect which columns of an item have been changed.
If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Best regards,
Kris
You cannot determine what column of data changed in a SharePoint list from Flow - you only know that a list item has been changed. This is the same behavior that exists when writing a SharePoint Designer workflow.
While this isn't what you want, I will offer it as a workaround. You can set an alert on your SharePoint list. The alert email shows a subset of the columns in the list but always shows what column was edited and the new value.
You can create a Flow that is looking for alert emails - you can filter on the subject which contains the list name.
When the Flow runs, you can create post a message to a Slack channel which will include the body of the email which includes an indication of the column that has been changed.
While this isn't exactly what you want, it may meet most of your requirements.
Here is a sample alert email:
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
