cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User III
Super User III

Re: Get Approver Name from SharePoint List

 

 @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
Highlighted
Super User III
Super User III

Re: Get Approver Name from SharePoint List

 

 @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

Highlighted
Advocate II
Advocate II

Re: Get Approver Name from SharePoint List

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

Highlighted
Super User III
Super User III

Re: Get Approver Name from SharePoint List

@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
Highlighted
Advocate II
Advocate II

Re: Get Approver Name from SharePoint List

Update: The solution has worked now

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (2,168)