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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Getting a count from o...
Power Automate
Unanswered

Getting a count from one SP table to another

(0) ShareShare
ReportReport
Posted on by 557

I have two SharePoint List - one that is a matrix of all possible types of systems issues (table A) and another that list the actual system issues being recorded (Table B).  How can I get the count from Table B into Table A via a flow to update the sharePoint list table A.  See desired result below

 

Table A - Matrix List of all possibleCount (Desired Result) Table B - Records of System Issues reported
Issue 1233 Issue 123
Issue 4560 Issue 123
Issue 0001 Issue 123
Issue 1110 Issue 222
Issue 2222 Issue 222
   Issue 000

 

 

Categories:
I have the same question (0)
  • David_MA Profile Picture
    13,912 Super User 2026 Season 1 on at

    I think I understand what you are asking. You can start out with a manually triggered flow and once it is working, you can change it to a recurring flow to run on a schedule. Then you would:

    1. Add an action Get items to table and to retrieve all items.
    2. Then from the values returned from this Get items action, add an Apply to each action.
    3. Add a Get items action into the Apply to each and point it to table B. Use a query filter to only get items where (I don't know what you have the field named) Issue 123 eq Issue 123 (tableAvalue eq 'tableBvalue').
    4. You can then use a Length expression to find out how many items are returned with the second get items action.
    5. You can then use an Update item action to update Table A with the count of how many items were found in Table B.

    I hope this makes sense. Note, depending on how many items are in each list, you could have some performance issues and may need to enable paging.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 251 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 239

#3
Expiscornovus Profile Picture

Expiscornovus 220 Most Valuable Professional

Last 30 days Overall leaderboard