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: Completed

Hi all,

 

Happy to update that this feature is now rolled out to and available for use. The documentation is updated as well:

For more info about how to use this action, see this tutorial: Introducing 'when an item or file modified' trigger and 'Get changes' action

 

Thank you all for the feedback and please let us know if you have any questions.

 

Thanks,

Chakkaradeep

Comments
pstrindlundcat
Advocate I

@Chakkaradeep . Your solution does not solve the original problem. It just gives us another "less bad" workaround. We can now use "When an item is modified" instead of "When an item is created or modified".

The problem is that we have to keep triggering workflows when we don't want to, and then use a condition to decide if we need to do anything or just kill the flow right away. This is causing additional flow runs with the new solution as well. To quote @julieann :

"It would be nice to have a trigger if a certain column in a SharePoint list is modified"

Chakkaradeep
Power Automate

@pstrindlundcat This is not a workaround, instead gives you a clear supported way to infer, when an item is modified, what columns got modified, and then do your business orchestration accordingly. Do try the new capabilities and let us know if it does not let you do the scenario as described in the idea. 

 

There are many scenarios that want granularity in just inferring items updates but not about what was changed. As a product team, we have devised this feature to help those customers as well. 

Anonymous
Not applicable

Would it be possible at some point to have a collection of changed columns bubbled up to the trigger level? If that was available then developers could use a trigger expression. Perhaps that additional calculation only takes place for the specialized trigger. Just an idea. For a high volume lists I can still foresee issues navigating through the flow history.

pstrindlundcat
Advocate I

@Chakkaradeep . Does this solution give us the thing that @julieann is asking for?

It would be nice to have a trigger if a certain column in a SharePoint list is modified. 

Chakkaradeep
Power Automate

@pstrindlundcat you get a trigger and an action. Using both you can infer if a certain column in the SharePoint list is modified. If you are asking for a separate trigger, we do not have plans to build that separate trigger as what we have right now indeed solves the problem and provides users with the ability to infer if a certain column in the SharePoint list is modified. 

Chakkaradeep
Power Automate

@Anonymous trigger conditions are not good to infer what changed between flow checks/runs and user modifications. It is not reliable. That is why we have built a separate action that you can use to check if columns were modified. The action is flexible and accepts dates and even versions to check for since and until. 

mo_jo_jo
Advocate I

@Chakkaradeep 

 

Veering slightly off the hot topic ... 

Can you please comment on whether there are any plans to easily expose whether an attachment associated with a list item has been modified?

As far as I have been able to test, that is not included within the outputs we can see with the new action. And the existing "Has Attachments" in a lot of item updates often seems to erroneously read "False".

Thanks.

Chakkaradeep
Power Automate

@mo_jo_jo the Attachments are not included in the column updates, unfortunately. This is documented as well in the documentation of the action. 

mo_jo_jo
Advocate I

@Chakkaradeep 

It is a shame that attachments got left out of the party.  Thanks for the response.

 

fugixi
Resolver II

Nice to see this implemented, even though I wanted a solution exactly as proposed by @pstrindlundcat , since we actually do not even want our flows to trigger at all, unless a certain column has changed.

 

However , when trying out this new action, it does not seem to work.

 

{
  "status": 400,
  "message": "sinceInput not specified\r\nclientRequestId: 951342c4-f2a1-4958-aa55-aea92778b1a5\r\nserviceRequestId: 951342c4-f2a1-4958-aa55-aea92778b1a5"
}

 

It seems the Trigger Window properties simply are empty.

Anyone else experiencing the same?

 

@Chakkaradeep Any thoughts on this?