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
