Get approvers list as a result of multichoice in lookup field

[Artem1981]

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

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.

Would be gratefull for any advice.

Thanks in advance!

Best regards,

Artem.

[ScottShearer · Accepted solution]

@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".

[Artem1981]

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