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"
}
}
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional