Unanswered

Get count from one SP list to update another

(0) Share

Report

Posted on by joel914823

557

Hello, I have two SharePoint lists (Tracker) and (Matrix). I'm trying to build a flow that goes to the Tracker list, gets the count for each Unique Issues and updates the count on the Matrix table. Note that there are hundreds of different types of UniqueIssues. See desired result:

Tracker	Matrix
UniqueIssues	UniqueIssues	Count
A	A	9
A	B	8
A
A
A
A
A
A
A
B
B
B
B
B
B
B
B

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-yetonggu-msft on at

Like (0)

Report
Hi @joel914823 ,

I did a test for your reference.

In my scenario:

My SharePoint Tracker list:

My SharePoint Matrix list:

My Flow:

item()?['UniqueIssues'] union(body('Select'),body('Select'))

length(body('Filter_array'))

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
joel914823 557 on at

Like (0)

Report

Thanks so much @v-yetonggu-msft it seems this would work. The uniqueissues item on the matrix would already be created, how would I tailor this to just update the count on the matrix table. I tried to do a Get items of the matrix at the top, but then I can't do an update item within the apply to each.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @joel914823 ,

I made changes to my previous flow, deleted the Create item, added Get items to the end of compose 2 to get the Matrix list, set ‘UniqueIssues eq '@{items('Apply_to_each')}'’ in the Filter Query, and then updated the item.

My Matrix List before:

Please check this test:

UniqueIssues eq '@{items('Apply_to_each')}'

My Matrix List After:

Best Regards,

Sunshine Gu

If I solve your problem, please mark my response as a solution so I can help more people who are experiencing this challenge in the future.🤗

Was this reply helpful? Yes No