Power Platform Community Forum Thread Details

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 possible	Count (Desired Result)	Table B - Records of System Issues reported
Issue 123	3	Issue 123
Issue 456	0	Issue 123
Issue 000	1	Issue 123
Issue 111	0	Issue 222
Issue 222	2	Issue 222
		Issue 000

Categories:

Building flows

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:

Add an action Get items to table and to retrieve all items.
Then from the values returned from this Get items action, add an Apply to each action.
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').
You can then use a Length expression to find out how many items are returned with the second get items action.
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.