cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Artem1981
Frequent Visitor

Get approvers list as a result of multichoice in lookup field

Hi All,

 

I created SP list to manage requests with reference to another list (to dynamically define 2nd level approvers). To do that I use Lookup field in my primary list

Artem1981_0-1636033147497.png

 

To manage requests properly I created Automated approval flow and was planning to use Policy Owner E-mail field (derived from secondary list as additional to lookup field "Policy Affected") to get 2nd level approvers list.

Trick is multichoice is possible for "Policy Affected" field (as shown on snapshot above) and I was happy to see consolidated info derrived into "Policy Owner E-mail" field. BUT when I try to use this field to "Create approval" it gives back just 1 (last) e-mail record as a result. When I use "Policy owner E-mail value" it returns me a loop which doesn't allow me to use "Create Approval" function.

 

Please advice potential solution for my issue: I need to get list of Policy Owner E-mails as a result of multichoice in lookup field "Affected Policy".

Part of flow created.

Artem1981_0-1636034608305.png

 

 

Would be gratefull for any advice.

Thanks in advance!

 

Best regards,

Artem.

1 ACCEPTED SOLUTION

Accepted Solutions
ScottShearer
Super User
Super User

@Artem1981 

It sounds like what you need to do is this:

  1. Create a string variable
  2. Loop through the "Policy owner E-mail value" entries
  3. Inside the loop, use an append to string action and append the Policy Owner email value and a semicolon (;) to the string
  4. Use the variable for the Approvers field in your Approval action

I am assuming that actual email addresses are stored in "Policy owner E-mail value".

 

 

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

2 REPLIES 2
ScottShearer
Super User
Super User

@Artem1981 

It sounds like what you need to do is this:

  1. Create a string variable
  2. Loop through the "Policy owner E-mail value" entries
  3. Inside the loop, use an append to string action and append the Policy Owner email value and a semicolon (;) to the string
  4. Use the variable for the Approvers field in your Approval action

I am assuming that actual email addresses are stored in "Policy owner E-mail value".

 

 

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

Scott

Thanks Scott! That is 100% solution I was looking for 👍

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,905)