Answered

How to conditionally count rows in SQL. If > 0 then continue the flow; else stop

(0) Share

Report

Posted on by Community Power Pla...

I have set up a table in SQL where I store approvals, including a column where I save an approval status (Pending, Approved, Rejected).

As part of a reminder process, I would like to send a message out conditioned on there being more than one item Pending in the Approval status column.

How do I count the number of rows in the table where Approval Status = Pending and then use the result in a Condition (if > 0 then continue the flow; else stop)?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hey @Anonymous

You can use odata filter queries to filter out the records and more details can be found here: https://toddbaginski.com/blog/use-dynamic-odata-filter-values-in-a-microsoft-flow-sharepoint-getitems-action/

Then you can use the length function in flow expression editor to check the length of the list returned from the above action and implement the logic further.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

That's it!. Thanks so much!

Was this reply helpful? Yes No