How to get Row Count in Workflow Studio?

MBarrott · ‎06-14-2024

I'm wanting to create a daily scheduled flow which will review active demand records and check to see if there is at least one active stakeholder assigned to the demand record.

Right now I have a look up action which conditionally pulls all the relevant records, however I'm unsure on the best solution to loop through each found record and see if the total number of active stakeholder records is <1.

I built a For Each flow logic but I can only see if the Stakeholder is Active or False, no way to get a total for Active Stakeholders.

Any help would be appreciated.

Zach Koch · ‎06-14-2024

I went ahead and mocked up the flow. The overall flow would look something like this, only using incident as an example.

Here is what your flow variable would look like

Here is setting the flow variable to 0

and you can update the count with something like this

here is where you can use that Flow variable to compare against

If you have any more questions, please let me know.

If this information helped resolve your issue, please remember to mark response correct and thumbs up to help future community members on this information, thanks!

View solution in original post

Zach Koch · ‎06-19-2024

Great! Glad you were able to resolve your question.

If this information helped resolve your issue, please remember to mark response correct and thumbs up to help future community members on this information, thanks!