Answered

Update start date based on another list item's end date

(0) Share

Report

Posted on by pilvo

I have a large list that tracks progress on every step in a manufacturing cycle. Each list item corresponds with the work that needs to be done by a certain work center with all of the work captured under a single manufacturing order (MO#). Simply, I have multiple items per MO#.

What I am trying to do is that whenever the Estimated Completion Date is changed in one list item, I want to have the Estimated Start date change on the next item. Unfortunately, the next item won't always be the next ID number. Rather, every step is given a sequence number so my thought is that whenever a Estimated Completion Date value changes, I have a flow query everything with that MO# and sorted by the sequence number and that way I can retrieve the information from the list item that corresponds with the next step in the manufacturing process. But so far I haven't had any luck getting it to work.

I've attached a photo to illustrated what dates I want to be "linked" by this flow. Another way to think of it is I want the list to behave like it would in Microsoft Project where if I adjust the due date of one item it changes the start dates of all the successive tasks down the list.

Any help is appreciated! Thank you

Flow Example.png

All responses (4)

Answers (1)

v-liwei-msft on at

Like (0)

Report

Re: Update start date based on another list item's end date

Hi @pilvo ，

When you modify the end date column to trigger the flow to run, the condition result will not be equal to false.
Please check whether the parameters in your trigger and action are consistent, for example:

Best Regards,
Levi
v-liwei-msft on at

Like (0)

Report

Re: Update start date based on another list item's end date

Hi @pilvo ，

When you modify the end date column to trigger the flow to run, the condition result will not be equal to false.
Please check whether the parameters in your trigger and action are consistent, for example:

Best Regards,
Levi
pilvo 2 on at

Like (0)

Report

Re: Update start date based on another list item's end date

Thanks Levi,

I replicated what you have here and I'm encountering problems at the condition step. The condition "Has Column: Estimated Completion Date Changed?" keeps returning as "False" despite me changing it? Any advice to problem solve?
Verified answer

v-liwei-msft on at

Like (0)

Report

Re: Update start date based on another list item's end date

Hi @pilvo ,

I have made a test for your reference:

1. Use When an item is created or modified as Trigger.
2. Add Get changes for an item or a file (properties only) to get whether the End date column has changed.
3. The flow continues to run only when the End date column changes.

4. Use Get items:
Enter the formula as shown in the filter query (make sure to enter the correct internal column name) .
Enter 1 in Top Count (only one item is returned).

5. Use Apply to each to traverse the Value returned by Get items.
6. Add Update item in Apply to each and change the Start date column of the next item.

Best Regards,
Levi