Return multiple values from Lookup field separated by comma

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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,";")

Was this reply helpful? Yes No
Verified answer

victorcp 2,350 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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 🙂

Was this reply helpful? Yes No
saphiraputri 23 on at

Like
a
(0)

Report
Copy link

Link copied!

Omg, it works!!! Thank you so much for your help!

Was this reply helpful? Yes No
saphiraputri 23 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No