Hello,
I am trying to design a flow in Power Automated that would need to do the following:
1. Retrieve the information from a form
2. If the product ranking is Low > I am fine, the flow works
2. If the product ranking is Medium or High, I need it to do the following
a. Retrieve the list of conditions from each submitted form
b. Identify who are the condition owners from the respective form
c. Create a table with all conditions raised for each condition owner
d. Retrieve the email address of each condition owner from a Sharepoint list
e. Send a separate email containing the table of conditions to each condition owner. The email should have the option to "Approve" or "Reject with comments"
f. If Approved, a separate email would be distributed to a specific email, as well as to the condition owner and condition requestor (as retrieved from the Sharepoint list on point d avove)
g. If "rejected with comments", I need to make a loop between the condition owner and condition requestor until it gets to status Approved
h. Once conditions get to status approved, they should be copied to a Sharepoint list
For me it seems as a simple flow, but I am struggling as I keep getting failures since the condition of product ranking medium or high :(
Many thanks in advance for your help.