Email addresses from an excel cell which uses VLOOKUP for an approval

[lewis_ward1]

Good Afternoon,

I have a form which a user submits the detail is then added to an excel table and this then allows the end cell to preform a VLOOKUP and generate the email addresses the first approval needs to be sent to. 

I have it working when it is is a single email address but when I have 2 or more it doesn’t seem to work but also doesn’t fail.

In the same cell it is currently appearing as:

name1@mail.com; name2@mail.com; 

Can anyone shed any light on why this may not be working, I’m still fairly new to this but love learning about its capabilities.

Thanks 

Lewis

[ChristianAbata]

hi @lewis_ward1  could you share an screanshot?

[lewis_ward1]

Good Morning,

As requested please find screenshots attached. 

[linxiao · Accepted solution]

Do you want to send approval to multiple users simultaneously or send separately?

For simultaneously: try to use string( Approvals got from Excel ) as the approval

For separately, please use split( Approvals got from Excel, ';' ) to get each email and then send approval one by one in an Apply to each action.

[lewis_ward1]

Morning Linxiao,

Perfect thank you, I also identified that I was using 'List Row' rather than 'Get Row' which was then sending various emails based off the data found in the table not on the row. 

Thank you for your help.