Count active Items in a sharepoint list and update the total number of counts on another sharepoint list

(0) Share

Report

Posted on by SinaM

Hello everyone,

I am new to power automate and I am looking for help regarding my case to count items in a sharepoint list:

I have two lists: List A and List B

List A has three columns ( One column is a choice column and shows the name of the person working on a task - Second column is the name of the task - Third column is another choice column and shows if the task is completed or active )

List B has two columns ( One column is a single text column and consists of the name of the people in list A - Second columns is the total number of active tasks)

I am looking to make a flow that counts number of active tasks that a person has in List A and update the number in the second column of List B

Any help would be much appriciated

Thank you

All responses (2)

Answers (1)

SinaM 40 on at

Like (0)

Report

Re: Count active Items in a sharepoint list and update the total number of counts on another sharepoint list

Hey@v-dezhili-msft

You are awesome, this works perfectly.
Verified answer

v-dezhili-msft Microsoft Employee on at

Like (1)

Report

Re: Count active Items in a sharepoint list and update the total number of counts on another sharepoint list

Hi @SinaM ,

I did a test for your reference.

Best Regards,
Dezhi