Need Help Creating a Power Automate Flow to Summarize Task Statuses from SharePoint Lists

(1) Share

Report

Posted on by Mayosh

Hello Guys!
I am trying to create a Power Automate flow that retrieves tasks from 4 different SharePoint lists and summarizes their statuses (Completed, In Progress, Assigned, Issue) for both the previous and upcoming week. I need help with the correct setup, particularly filtering tasks by dates and counting tasks based on their statuses.

Flow Requirements:

   •   The flow should run every Friday and:
   •   Retrieve tasks from current week (Staring from monday till friday)
   •   Retrieve tasks for the upcoming week (starting from next monday till friday)
   •   The tasks should be retrieved from 4 different SharePoint lists.
   •   Filter tasks by their statuses:
   •   Each list has tasks with different statuses: Completed, In Progress, Assigned, and Issue.
   •   I want to count how many tasks in each list are under each of these statuses (e.g., 10 Completed, 2 Issue, etc.).
   •   Summarize the results:
   •   After filtering and counting tasks by their statuses, the flow should create a summary table showing the status counts for each list, similar to this:

And then send it via e-mail. Can anyone help?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,969 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

You really need to try to do some of the work yourself, Helping isn't just doing.

Please provide the schemas of the Lists you want the data from. Explain how they are linked together etc.

Was this reply helpful? Yes No
Mayosh 33 on at

Like (1)

Report
Copy link

Link copied!

Hey, I already started creating it by myself. I can’t provide you with ss of the flow but basically it goes like this (for now I am creating it for only one list, just to understand everything)

Trigger - for now I’m using manual trigger just to test it, but later I’ll switch it to the recurrence

Get Items - Sharepoint

List name - List 1

(I want to use filter query to filter out items from current week and for next week - I tried to use different options here, but maybe I don’t understand something)

Now I used Filter array for every status separately and compose for each filter array action.

For example:

Filter array - completed

Value - Get items - sharepoint

Status Value - Starts with - Completed

Compose - expression - length(body(‚Filter_array_Completed’))

and it goes like this for every status. Thing is that ion result I get all the items from that list cause I don’t have filter query as said previously.

Was this reply helpful? Yes No