How to trigger Flow when a particular field is changed in a SharePoint List

(0) Share

Report

Posted on by JL-21120807-0

Hi all

I seek your valuable assistance.

I have a SharePoint list and one of the items is "Assigned To", a drop down list with a list of Managers to choose from.

Whenever there is a change in this item, I would like to trigger a flow to (1) create a task in Planner and (2)the job is assigned to this selected Manager, and (3) a mail is sent to him.

Any changes in the other SharePoint List items should not trigger the flow.

I highly appreciate assistance from you. Thanks.

Jaweed

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

Nived_Nambiar 18,136 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @JL-21120807-0

You can do combination of get changes for sharepoint file/item action + planner actions.

See below

1. Use trigger to start the flow when item is modified in sharepoint list

2. Use get changes for item/file action to check what are the changes occured in sharepoint list.

Expression:

concat(sub(int(split(triggerOutputs()?['body/{VersionNumber}'],'.')?[0]),1),'.0')

3. Use condition to check whether assigned column value has changed /not

If the condition is true: in yes branch create planner task and assigned to specific user like below

Next finally- send an email to assigned to person to notify that task has been created.

Hope it helps !

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
Verified answer

abc 123 789 Moderator on at

Like (1)

Report
Copy link

Link copied!

Any change to the item would trigger the Flow. So, inside of the Flow, you'd need to ascertain if that column was changed and then react accordingly. The Action that allows for this is called "Get changes for an item or a file (properties only)".

When this action is executed, it will tell you if a column HAS changed, but not from what, to what. (You'd have to dig into the Version History to get what it was, but maybe that doesn't matter.)

Now, keep in mind that Microsoft changed the versioning behavior where the version number updates every time the user changes ANY column in the item. This is really dumb and annoying and makes using this new Action very hard. (Thanks interns!). Be patient with your coding and debugging.

Anyway, give it a shot and feel free to ask more questions about it.

Was this reply helpful? Yes No
abc 123 789 Moderator on at

Like (0)

Report
Copy link

Link copied!

Nived's answer does not take into the consideration the modification by Microsoft to update the version number every time a column is changed. So, do not expect that what he posted to work perfectly. He obviously has this in his library of answers and just copied and pasted.

Hopefully he will read this and update his answer to accommodate the new methodology.

Was this reply helpful? Yes No