I've got an approval process flow linked to a Microsoft List - I've been running some tests to make sure every possibility is working before I roll it out, but I've run into a strange issue where the Flow Run information is not accurately reflecting what actually happened in the run.
The relevant part of the flow is:
- Scheduled: Daily at 7am
- Get Items from X list
- Condition: If the Review Date is less than 30 days away
- Condition: If the Approval status is NOT equal to Pending
- True: (Do other things - not important right now)
- False:
- Update Item: Change Approval Status to Pending
- Start and wait for an approval
- Condition: If the approval outcome is 'Approve'
- True: (Do other things - not important right now)
- False:
- Update Item: Approval Status to Rejected, Approver Name, Response Date, Response Comments
I did a test and approved the item. The list item showed 'Approved' and the flow run showed everything was successful.
I did a second test, rejected the item. The list item showed as Rejected and had all the details filled in, so the run was successful right? But when I go to the flow run, yes it says Successful, but the necessary actions were 'Skipped'. Even though judging by the list, they obviously weren't skipped because it did exactly what I wanted it to do.
The first actions (Scheduled and Get Items) were successful, but the Condition regarding the Review Date comes up as 'false' meaning it was skipped in the flow run. But again, it obviously wasn't because the rest of the consecutive actions ran perfectly?
Is this some expected behavior I'm not aware of? What's happening here? I am new-ish to Automate.
Before you ask:
- Yes, I'm looking at the correct flow run. I've tested this like 4 times and looked at every run because I thought I was going crazy.
- I have tried this as a manual test, an automatic test, and just a normal scheduled run in case it was something to do with the fact it was a test. I even let the approval flow sit for ten mins before rejecting to see if that somehow made a difference.
- There are no SharePoint List triggers / other approval process / other flows active that I can see. This is a test list only shared and created by myself.
