Unanswered

Help on Summarizing Count of data

(0) Share

Report

Posted on by echodapogi

516

Hello everyone. I have a scenario that i cannot seems to figure out on how to summarized in one single flow. Hoping someone on this group can help me.

I have a SharePoint list named "Products". I wanted to summarized the data on this product list. below is the sample structure.

ID	Product	Status	Error	Date
1	Nokia	Ready	No	2/1/2022
2	Nokia	Ready	No	2/1/2022
3	Nokia	Error	Yes	2/1/2022
4	Samsung	Completed	No	2/1/2022
5	Samsung	Error	Yes	2/1/2022
6	Sony	Ready	No	2/1/2022

Below is the result that i wanted. I need a summary report to be send to email based on today date.

Summary	Count
Errors	2
Ready	3
Completed	1
Total Processed Today	6

Issue. How can i compose a Get Item filter code with these complex condition. seems not possible but i am hoping somebody here can help. Thanks in Advance

Echo

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@echodapogi what you are trying to do is called GroupBy, I found a similar thread here. Please check this out:

https://powerusers.microsoft.com/t5/Building-Flows/Group-BY-in-Flow-to-send-email-of-aggregated-data/td-p/397420

https://powerusers.microsoft.com/t5/Building-Flows/SharePoint-List-group-by-count-and-average/td-p/534549

--------------------------------------------------------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
echodapogi 516 on at

Like (0)

Report
Copy link

Link copied!

i will try to follow the above link and see if that resolve my needs. thank you

Was this reply helpful? Yes No