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
