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!
Hi! it works!!! Thank you so much!
But there's a yellow underline below the "in" and the message is:
"Delegation warning. The highlighted part of this formula might not work correctly on large data sets."
Is it okay if I used the formula with a warning like that?
Omg, it works!!! Thank you so much for your help!
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 🙂
Hi @saphiraputri,
Because LookUp() function only returns the first record of the matched results, you need to use Filter() function:
Concat(Filter(SalesAdmin,Name in DataCardValue1.SelectedItems.Value,Email),Email,";")
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1