Hello, I have a flow I've been working on for a few days now and have slowly gotten it to work for the most part. However, it's not producing the desired results.
I have two lists (PTO Requests and PTO Tracker). The concept is that requests are put in via a form and placed in the PTO Request List, and when the PTO has actually been confirmed as completed, the Supervisor marks it as Completed, and the PTO Tracker list adds the hours used for the specific request to their Employee Records PTO used Column. Below is the PTO Request List. This flow I'm working on should trigger when a record is modified.
Well, I'm at the point where when the Request Status is marked as Completed, the flow is triggering, but it appears to be ignorning the Condtion that the Request Status equal Completed, and it's taking the PTO Requested Hours from the first record in the PTO Requested lists and updating all Employee Record PTO Used Column in the PTO Tracker list to the first record's PTO Requested Hours.
In the screencap above, the Request Status was marked as Completed. The flow will trigger as it should, but this is where it doesn't do what I need it to. Below is the entire flow.
Below is the screencap from the results of the Flow in the PTO Tracker list. It's adding 40 hours to each employee's PTO Used Column. Based on what was updated on the PTO Request list, it should first, ignore the first request because it's marked as Requested and NOT Completed. Secondly, once it gets past that, it should be adding the PTO Requested Hours of 8 to the affected Employee's Record in the PTO Tracker List. In other words record 1 should still be 0 (zero) and record 2 shoud be 8.
Can someone please tell me where my logic is broken in this flow and set me straight? I know I'm not doing something right. Also, a couple other notes... the expressions on the Set PTO Used and Update PTO Used On PTO Tracker PTO Used Column were finally completed after discovering the flow was not cooperating with quick expressions available from previous steps.