I have a QA flow that's working pretty well but there are a couple of things I can't get to work correctly. Primarily the status on the sharepoint list where I have every QA registered. Maybe someone can help?
The flow is as follows:
- Flow triggered when an email requesting QA arrives at a specific email address.
- The email contents are saved in a SharePoint folder and the id info (subject/time/who from/status etc) are saved in a separate SharePoint list.
- An email is sent to the requestor acknowledging receipt and giving them options on who the approver for the QA should be (ie the name of the manager/supervisor etc).
- An approval is then sent to the selected approver. with 4 options : Approve, Reject, Approve & Escalate, Reject and Request Changes.
- A loop is then started in which it will loop until either Approve or Reject has been selected. This is because the QA process could require several escalations (option 3), or several iterations (option 4) before it was correct.
- With option 4 an email is sent to the requestor every-time changes are requested noting the comments from the approver and a button in the email to be used when the changes are made.
- Once final selection made (approved or rejected) it then exits the loop and sends an email to the requestor stating the final decision with a link to the folders and to the commentary text.
The problem i have is the status (a choice column) in the SharePoint list not updating correctly. It works ok when the process starts ie it changes to "Pending", and it when its approved or rejected those statuses also work. It's the "updates required" and "escalated" are not working correctly in the SharePoint list. I suspect what is happening is that it's going through the loop so quickly when they are selected it goes back to 'pending' but I 'm not sure.
Sorry if this is as clear as mud. I've attached several screenshots of the flow to explain better.
Image A shows the overall flow & shows the loop overview.
image B is the loop expanded showing escalate option
image C is the loop expanded showing update requested flow
Any help or guidance greatly appreciated.
Thanks!
