
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 |
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:
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.