cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
NikTan
Level: Powered On

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
Super User
Super User

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
4 REPLIES 4
Super User
Super User

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
YatinMumbai
Level: Powered On

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? 

Super User
Super User

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
YatinMumbai
Level: Powered On

Re: Get Approver Name from SharePoint List

Update: The solution has worked now

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020.

thirdimage

Flow Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Flow Community Video Gallery!

Users Online
Currently online: 380 members 5,853 guests
Please welcome our newest community members: