use automate to count items by column group in sharepoint

eric-3590 186 Reputation points

Hello all,
I have a SharePoint List like below.

I want to use automate to send report weekly. The report like below picture. The report is about how many issue every department had everyday. My idea is to use groupby and rowcount function. But dont know how to design it in automate.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,809 questions
{count} votes

Accepted answer
  1. AnuragSingh-MSFT 19,686 Reputation points

    Hi @eric-3590 ,

    Welcome to Microsoft Q&A! Thanks for posting the question.

    Based on my understanding, you are using Power Automate to build workflow (Please correct me if I misunderstood it).
    You may refer to the discussion in the link below to achieve this goal.
    Count Distinct Values for a group of list items

    In case you have any pending queries, please feel free to use Power Automate community for your questions.

    If your query was related to one of Azure services, can you please clarify that so that I may help you.

    Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

    0 comments No comments

0 additional answers

Sort by: Most helpful