cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shertech25
Helper III
Helper III

Retrieve specific approver's email for Approval Flow

Hi everyone!

 

I've previously done up an approval form workflow, and for each approval, the email was sort of "hard coded" onto the start and wait for approval's "assigned to" with the specific email address. However, i would like to create a separate list on Sharepoint that stores the different approver's email. 

 

e.g Stage 1 approval will be 'Admin Staff 1', then stage 2 will be 'Admin Dir 2'

 

Sharepoint list:

(Approval list)

shertech25_0-1624435537187.png

 

shertech25_1-1624435874184.png

Expression: 

first(body('Get_items')?['Value'])?['Admin_Staff_1']
 
(Is the above expression correct??)

 

 

Thank you!!

8 REPLIES 8
v-bofeng-msft
Community Support
Community Support

Hi @shertech25 :

Please try :

 

 

outputs('Get_items')?['body/value'][0]['Title']

 

The function of the subscript [0] is to get the first record

 

Best Regards,

Bof

Hi @v-bofeng-msft 

 

shertech25_0-1624502746761.png

shertech25_1-1624502760271.png

 

 

Hi @shertech25 :

Get it.Please try this flow:

vbofengmsft_0-1624504493610.png

Note:On your side, you should connect the user's Email with ";".

Next, you can directly call the variable Users directly in the approval action.

Best Regards,

Bof

 

 

Approval list:

shertech25_0-1624514250486.png

Just liddat? The testing failed. But the system wont know to retrieve the email from "Admin staff 1" column right?

shertech25_1-1624514429899.png

 

 

I know its easier to just put the email under approval flow, but then i think with a separate approval list would be easier for admin side to make changes e.g Email address when approval is out of office for the time being.  

Hi @shertech25 :

I'm not sure if I understand what you mean:

1\From the screenshot of your data source, there are two records. Do you want to send two approvals separately based on these two records, or merge them into one sending? Or just send based on the first record?

2\I mentioned earlier that the object of Assigned to must be an email address. Should on yourside use the value in the Email field?

vbofengmsft_0-1624514834604.png

Best Regards,

Bof

 

Under Approval List's "Admin Staff 1" has two approval. It would be first to respond; Either approval to proceed this request to the next approval (Admin Dir 2)

 

Yes, it should retrieve the email from the "email" column from Approval list. 

 

Thank you

Hi @shertech25 :

I've made a test for your reference:

vbofengmsft_0-1624516089998.png

The flow:

vbofengmsft_3-1624516560931.png

Best Regards,

Bof

 

 

 

 

 

shertech25
Helper III
Helper III

Currently i have 2 separate lists on sharepoint; Approval List & Stationary list. 

 

Stationary list:

This list contains the information of what the requestor filled up on Microsoft Form to request for stationary 

shertech25_0-1624517640256.png

 

Approval list:

This list consists of the email address of the admin approval that will approve the stationary request

shertech25_1-1624517722086.png

 

The workflow will first update all these information of the stationary request form onto Stationary List, while at the same time retrieve the email address of Admin approval from Approval list. 

 

Am i confusing you? Hahah sorry

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,218)