Power Platform Community Forum Thread Details

I have a flow that I can’t get to cooperate. I have only been building flows for a few weeks. This is only my 4th flow.

Here’s what I’m trying to do:

I have a list (Tasks) used to sync with Project. Tasks has the following columns:

Tasks List.png

Each Tasks list (Task List content type) has 2,000 to 5,000 items. Users report completion against about 60% of the items, but we would like to complete the rest of the items automatically based on completion of dependent items. The items users report directly against are denoted by “Yes” in the “WR Flag” column. The items not reported against have “No” in that column.

When an item in the table is updated, the flow is triggered and does the following:

Set some variables for later processing

Init Variables.png

Init Variables2.png

Check to see if the modified item is now complete

If Yes,
1. Get items filtered by
  1. NWR Flag is “No”
  2. % Complete < 1
  3. The modified item is a predecessor

Get items.png

NOTE: I tried to filter in the same get items statement, but got an error saying that the ‘get items’ couldn’t refer to itself
I am also worried that even if I get this to work, the contains statement will bring back erroneous results (e.g. when modified item is ID ‘1’, it will return records where the predecessor ID is ‘16’ or ‘3416’, etc.)
2. Update some variables for use in updating items(s)

Set Variables.png

My worry is that % complete won’t be calculated correctly if an item is modified again after it is already complete since I have no way of triggering the flow selectively and don’t know how to set a condition to check if the modification to the item is marking it complete for the first time.

I thought about creating another array column to hold the ‘ID’ of the completed predecessors and then updating it with the current modified ID so I can include it in the condition, but I’m not sure if that will work.

Update item(s)

Update items.png

If No, stop processing.

My error is in the Apply to each 2 Step

Any help on this is greatly appreciated!

Community site session details

Complex Flow to Auto Complete Task Items Not working

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates