web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get a count of how man...
Power Automate
Answered

Get a count of how many items i have and if more than 10 send an email.

(0) ShareShare
ReportReport
Posted on by 101

Hi all

 

I wonder if you could help, I have a SharePoint list that has the responses from a form. In the list there is a column for the company that is being spoken about. 

I have 4 companies. 

What i need to know is how many items each company are mentioned in. 

From that i need to then get the flow to email said company if they are mentioned in more than 10 items. 

i have done some research and seen that there needs to be an array, but i have never used them so any help would be much appreciated. 

 

Kind Regards

 

Justin

Categories:
  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on at

    @JEVANSAP  Use get items action with filter query for company name after that use length() to get no of items related to company. once you have number then you can email.

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • JEVANSAP Profile Picture
    101 on at

    I have a column called Company name and i have 4 different companies that would be in the column, would this still be the process as i would need to check each one, would i need 4 get items? or could i do all 4 in one?

  • Verified answer
    Rhiassuring Profile Picture
    8,692 Moderator on at

    Hi there, 

     

    You're right about the array - that parts easy though, it's a manual one time thingy. You can do "Initialize Variable", type of "Array", and just type in [ "Company1", "Company2", "Company3", "Company4" ] -- and that part is done.

     

    Next, you'll use an Apply to Each action, and point it at your array.

     

    You can use the "Get Items" action, and in that action on Filter Query, you can enter CompanyName eq 'Current Item' (Type ' ' and then between those apostrophes, click and select Dynamic Content, scroll all the way to the bottom, and select Current Item)

     

    That will bring back only those items where that company is in that column.

     

    Next, you can use a Compose and use the expression length() - point it at the Body output from Get Items.

     

    Then, you can use a condition to see if that number is more than 10 - and send an email if it is.

     

    Rhiassuring_0-1674063083766.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 289

#2
11manish Profile Picture

11manish 288 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 125

Last 30 days Overall leaderboard