
Hi automate folks,
Good day I have scenario where in I want to trigger a flow only when a column in my SharePoint list called end date is modified if any other column is updated it should not trigger the flow ,unlike in Dataverse when item is modified you can chose the columns on which affect here in SharePoint trigger I don't see any though we have trigger condition but end date column can have any value i just want when column is modified as when the column is modified my flow runs does the computation by taking start date and end date does some calculation and update on the same row a different a column a time value ,however when I'm doing its going in kind of infinite trigger can anybody suggest an approach here ?
can we use Limit Columns by View?by limiting to that column?
SharePoint
Dataverse
I don't know how to limit the trigger to just running when one field is updated, but there is a way to handle this. You need to have versioning turned on for this to work, but you would get the changes for the item and check if the field has been updated.
In the Get changes for an item or a file action, set Since to Trigger Window Start Token and Until to Trigger Window End Token. This will check for changes made just for that trigger of the flow.
Then add the Has Column Changed value of the field you want to check to the condition and check that it is true. Then on the yes side of the condition do whatever you need. The No side will end the flow.