Power Platform Community Forum Thread Details

What I would like to achieve is:

1. Within the folder, the excel file is created, once the responses are submitted via FROMS - this works so far.

2. Created file contains the name and email address of a specific person - I would like to set this person as a document approver automatically - I have already managed to create a button called GET SIGNED which once is clicked, the pop up opens and prompts user to provide the approver's email address prior to getting the document signed; when this is filled in, I click SEND FOR APPROVAl and approver is notified via email, and so on.

Is there a way to automate the approval process as described above so once the button is clicked, it automatically retrieves the email address from the excel file and sets this person as approver?

Button code:

{
 "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
 "elmType": "button",
 "txtContent": "Get Signed",
 "customRowAction": {
 "action": "executeFlow",
 "actionParams": "{\"id\": \"e3b60b22-a7e8-4c38-ab98-df7960261206\"}"
 },
 "style": {
 "background-color": "purple",
 "color": "white"
 }
}

Approval Flow (current one):

The template I used from pre-sets : Request approval (everyone must approve) for a selected file

Categories:

Using flows