Power Platform Community Forum Thread Details

Hello everyone,

I need help with flow automation.

I have 2 lists:

1) the main list - it's a request list

2) the task list

Every task is created in the task list, has a column called 'Ref ID' that it's filled with the ID of the main list. That's the way of relationship.

In the main list, I have a column called 'Concluded'.

I need to fill this colunm with Power Automate with yes, when ALL the tasks of the another is done.

For exemple, if i have 3 tasks on the task list, this columns only can be changed to Yes, when the 3 tasks is done.

I'm building the flow as below:

When a item is modified (in the task list) this is my trigger ->

Get item from my main list (Filter ID eq 'Ref ID')

After this I need to check if All the tasks is done - I can update my item to Concluded.

If not, don't update.

My difficult is to power automate check item by item.

I need this urgently, please!!

Thanks!!!

Categories:

Relationship between lists