Flow that counts items in a Sharepoint List then sends an alert in Teams

(0) Share

Report

Posted on by CSilva

Hello, I am relatively new to Power Automate.

I am trying to create a new Flow that will run every hour and check my Sharepoint List for transactions with a status of "Submitted", then send a message in a group chat with the number of transactions with that status if it is more than 0.

I know it is possible, and probably really simple, but I am having difficulty getting things off the ground by myself. Any help is appreciated.

Categories:

Business Process Flows

All responses (1)

Answers (0)

grantjenkins 11,059 Super User 2025 Season 1 on at

Like (0)

Report
Re: Flow that counts items in a Sharepoint List then sends an alert in Teams

See example below that should get what you're looking for.

See full flow below. I'll go into each of the actions.

Reoccurrence runs every 10 minutes.

Get items uses the following Filter Query to only return items where the Status is equal to Submitted.
Status eq 'Submitted'

Condition will check the length of the items returned. So, how many items have a Status of Submitted. The expression used is:
length(outputs('Get_items')?['body/value'])

If the Condition is true (at least one item returned) it will go into the Yes branch. In the Yes branch I have Post message in a chat or channel and use the following expression to get the number of items returned (same expression we used in the Condition).
length(outputs('Get_items')?['body/value'])

----------------------------------------------------------------------
If I've answered your question, please mark the post as Solved.
If you like my response, please consider giving it a Thumbs Up.