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

View solution in original post

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

View solution in original post

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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 Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,191)