Return multiple values from Lookup field separated by comma

Like (0) Share

Report

Posted on 22 Jan 2024 10:59:59 by saphiraputri

Hello!

I hope someone can help me to solve this because I can't find any solution for this issue.

I'm trying to return two values selected from a Lookup field I created and want to separate it by comma.

Fyi, DataCardValue1 is Sales Admin field that I created using Lookup (SalesAdmin list in Sharepoint)

So, If a user selected multiple names from Sales Admin field, I want to get their Email data from the Sales Admin list I created to fill the Pending PIC field, but I have an issue bcs it only returns one value not based on how many user selected the value in Sales Admin field. And, I also want the selected value to be separated by comma..

Is there any solution for this? I tried using concat in Default just like in the screenshots but it keeps giving me an error saying it has some invalid arguments.

Thank you so much for your help!

Categories:

General Questions

All responses (4)

Answers (1)

Verified answer

victorcp 2,347 Moderator on 22 Jan 2024 at 11:09:27

Like (1)

Report
Re: Return multiple values from Lookup field separated by comma

Hi,

Yes, you have to create a table with all the selected values, then lookup in the SalesAdmin and finally concat them, like this:

Concat( ForAll( DataCardValue1.SelectedItems As item, LookUp(SalesAdmin, Name = item.Value) ), Email, ";" )

I hope it helps 🙂