Share via

use automate to count items by column group in sharepoint

eric-3590 191 Reputation points
2022-01-18T02:43:05.79+00:00

Hello all,
I have a SharePoint List like below.
165883-image.png

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.
165915-image.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
43,579 questions
Accepted answer
  1. AnuragSingh-MSFT 21,526 Reputation points Moderator
    2022-01-20T09:07:10.28+00:00

    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 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.