How can I Stop powerautomate Flow after an update is made to a column in Sharepoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Luis Arellano 247 on at

Like (0)

Report
Copy link

Link copied!
Can you share more information about your flow?

I think we cannot use the filter for this condition so you could use and if expression, but if your flow is manually run or scheduled and retrieves a biggest set each time, you'll have to add a flag and use that in the main "get items" filter (assuming you are using that)

contains(items('NameOfYourApplyToEach')?['yourColumnName'], 'textToMarkItemToNotRun')

So, the "If yes" part of this condition will be to update the item or do nothing and check the next item.

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (1)

Report
Copy link

Link copied!

Without seeing your code, this is only a guess, but shouldn't you test the Comments to see if they're empty, and if not, use the Terminate action?

If this helped, please mark it as a Solution.
Anne

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi Anne,

This sounds like what I need - However, I was unable to find an operation pertaining to checks and when trying to use the terminate operation with a condition applying to each I get the error "The operation 'terminate' cannot be used inside a for each."

How can I add your logic to my existing flow or does it make sense to configure a new one for check and terminate?

Was this reply helpful? Yes No
annetoal 1,934 Moderator on at

Like (0)

Report
Copy link

Link copied!
Assuming you have to allow for the possibility of more than one item being in your results, you're going to have to deal with the Apply to each and as you point out, Terminate doesn't work inside.
You can also filter inside ODATA with
Comments ne null
but that doesn't solve the inability to use Terminate because it's just going to output an array also.
At this point perhaps it would be better to rethink your logic so that you don't need to force Power Automate to stop mid-flow.

Was this reply helpful? Yes No