web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Flow that counts items...

Power Automate

Unanswered

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

(0) Share

Report

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:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

grantjenkins 11,063 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No

Join the conversation