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

Get Approver Name from SharePoint List

Hi All, I am having SharePoint List in Cloud which contains Approval Data base on Department and Designation. Can you please let me know how i can Look up the Approval from That sharePoint list base on Department Name and Designation and Assign That person as Approval in Start Approval Activity. Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User III
Super User III

 

 @NikTan:

 

Here is a solution that should work for you.

 

In my example, the Approvers are stored in a list called Approvers.  I store the department name in the Title column and the approver in the Approver column which is a person or group column.

 

In the list with data to be approved, I have a chopice column where the user will select a department.

 

When a new item is created, I lookup the row of data in the Approvers list where the Title is equal to the Department name.  I use the Approvers email form that row of data when assigning an Approver in the Approval action.  You need to click on Advanced Options to expose the Filter Query input box.

 

Please note that my Approval action is in a loop.  This is because, technically, more than one row of data can be returned from the Get Items action when I loopkup the approver.  Only one row will be retruned because you only have one row with each department name.

 

Also note that the single quotes around the Department in the Odata filter.

 

ApproverList.jpg

 

If this solves your issue, please mark your post as Solved.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

4 REPLIES 4
ScottShearer
Super User III
Super User III

 

 @NikTan:

 

Here is a solution that should work for you.

 

In my example, the Approvers are stored in a list called Approvers.  I store the department name in the Title column and the approver in the Approver column which is a person or group column.

 

In the list with data to be approved, I have a chopice column where the user will select a department.

 

When a new item is created, I lookup the row of data in the Approvers list where the Title is equal to the Department name.  I use the Approvers email form that row of data when assigning an Approver in the Approval action.  You need to click on Advanced Options to expose the Filter Query input box.

 

Please note that my Approval action is in a loop.  This is because, technically, more than one row of data can be returned from the Get Items action when I loopkup the approver.  Only one row will be retruned because you only have one row with each department name.

 

Also note that the single quotes around the Department in the Odata filter.

 

ApproverList.jpg

 

If this solves your issue, please mark your post as Solved.

 

Scott

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

View solution in original post

Did not work for me. The filter statement is giving error. I did exact steps given. Any ideas? 

@YatinMumbai 

Please post a screen shot of your Flow along with the actual error.

 


@YatinMumbai wrote:

Did not work for me. The filter statement is giving error. I did exact steps given. Any ideas? 


 

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott

Update: The solution has worked now

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (85,545)