cancel
Showing results for 
Search instead for 
Did you mean: 

Create a trigger for SharePoint list columns

It would be nice to have a trigger if a certain column in a SharePoint list is modified. For example, if the column "Status" is modified, or if the column "Assigned To" is populated. So we don't have to use the trigger "When an item is created or modified", where you have to create a lot of workaround conditions just to make sure that the column that was updated is what you need. 

Status: Under Review

Hi all,

 

We understand the pain points expressed here, and we are currently investigating options in building granular flow triggers for item updates and column changes in SharePoint.

 

We respectfully ask for your continued patience on this topic for the remainder of this calendar year. We are committed to a viable solution for our customers worldwide, and will continue to post updates here as we solidify our plans (which will most likely be early next year). Again, thank you for your patience, and your feedback on Microsoft Flow integrations with SharePoint.

 

Thanks,

Chakkaradeep (Chaks)

Comments
Level: Powered On

@Audrie-MSFT 

 

Audrie, this does help tremendously for at least my situations. 

 

You could set up flows for each state of the the status processes

 

If (Status = Pending) Do stuff

If (Status = Approved ) Do stuff

If (Status = Rejected ) Do stuff

 

Only one would fire each time, eliminating the duplicate runs and making it much easier to access the history. You could still get a lot of garbage runs where edits are made during a particular state though so it might not be perfect for every situation. 

 

In that case, you might want to filter on a dynamic value, which you can do as well by doing using a duplicate column that's only updated by the workflow.

 

If (Status Field != OldStatus Field) Set OldStatus to Status, Do Stuff

 

This would then only trigger if the status column is changed. 

Flow Staff

@Stander thank you! 🙂

Adding @Chakkaradeep as an FYI too

Level: Powered On

Hi all - John Liu posted a great work around utilizing SharePoint's versioning feature.

 

I found his guide and illustrations extremely helpful - a big thank you to John, wherever he may be!

 

John Liu's - microsoft-flow-sharepoint-trigger-on-specific-fields-changed-via-sp-http-request

 

This involves the following actions

1) Send an HTTP Request to Sharepoint

  • to obtain the item version results on item change

2) Select Data Operation

  • to map results of item change to use in conditional comparison

3) Condition

  • to determine if column changed from last version

4) Create HTML Table

  • to help identify when the specified column is changed and what change was made
Level: Power Up

You realize that there is a template, "Send a push notification when a column is changed in a SharePoint list" already in Flow? I called support about this, but the person I was working with insists that it will not work on a column, only a whole item. I personally believe he is mistaken and that he has not taken the time to analyze the template - it's a pretty complex one that's beyond my capabilities, but I would think an "expert" would have a better understanding.


Level: Powered On

@PhilGold - Thank you for sharing that.  It would be amazing if microsoft could roll all this logic up into a single control.