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

Community site session details

Session Id : dcxEOU1eXKUqSLUW4n0k7B
Power Automate - Building Flows
Unanswered

Count items from List 1 and update List 2

Like (1) ShareShare
ReportReport
Posted on 12 Jul 2024 23:28:18 by

Hi all - 

I am trying to build a flow that counts filtered items from LIST 1 based on the value of 2 fields from LIST 2, and can't seem to be able to wrap my head around it, though I'm pretty familiar with power automate. 

 

List 1 looks like this :

AMR1009_0-1720826538071.png

 

List B (What I am trying to accomplish):

AMR1009_1-1720826577884.png

 

1. Count by location & group and plug in total in 'total names' field.

2. Count by location + group + completed projects. 

 -- These counts should happen across rather than down, which is where I'm getting stuck on how to get this accomplished. 

  • AMR1009 Profile Picture
    on 15 Jul 2024 at 15:12:22
    Re: Count items from List 1 and update List 2

    Hi Mike - LOL I apologize for the confusion. List B should be List 2. 

     

    1. The first list has all the records where I need the counts from and List 2 is where I'd like to store the counts. 
    2. Total names is referring to how many names per location/group are on List 1. This number is used to compare for example, how many people from the Yellow group in Georgia have completed each project. 
      • Georgia Yellow - Total head count=2 --> 2/2 have completed project 2 = 100% completion rate for that specific project. 

    AMR1009_0-1721055913361.png

    AMR1009_1-1721055924144.png

    I hope this makes sense. 😅 But please let me know if you need more info. I really appreciate you looking into this.

     

  • Michael E. Gernaey Profile Picture
    45,286 Super User 2025 Season 2 on 13 Jul 2024 at 03:54:44
    Re: Count items from List 1 and update List 2

    Hi @AMR1009 

     

    I am having difficulty understanding exactly what you need.

     

    You Have List 1, and then you say List 2, but below you show List B and say that's what you want, is that accurate, since I don't see List 2?

     

    I cannot really write it up if I don't see List 2, otherwise it's a lot of back and forth and ain't nobody got time for that 🙂

     

    Let's review what you are looking for:

    1. Count by location & group and plug in total in 'total names' field.

    2. Count by location + group + completed projects. 

     -- These counts should happen across rather than down, which is where I'm getting stuck on how to get this accomplished. 

     

    In #1, it says location & group, do you mean (like #2) where you wrote location + group + completed, meaning your grouping, because when I look at what you say you want to do, I dont understand.

     

    New York / Blue has 3 items marked as completed, but Total Names = 1.. What is total names????

    Please provide more / clearer details etc

     


    If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

    Cheers

    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete