Skip to main content
Community site session details

Community site session details

Session Id : fKwn/RgRVv+E2Iiu0fpWW4
Power Apps - Building Power Apps
Answered

Return multiple values from Lookup field separated by comma

Like (0) ShareShare
ReportReport
Posted on 22 Jan 2024 10:59:59 by 23

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! 

 

image.png

 

Categories:
  • saphiraputri Profile Picture
    23 on 23 Jan 2024 at 03:05:03
    Re: Return multiple values from Lookup field separated by comma

    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?

  • saphiraputri Profile Picture
    23 on 23 Jan 2024 at 03:01:17
    Re: Return multiple values from Lookup field separated by comma

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

  • Verified answer
    victorcp Profile Picture
    2,347 Super User 2025 Season 1 on 22 Jan 2024 at 11:09:27
    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 🙂

  • v-qiaqi@microsoft.com Profile Picture
    on 22 Jan 2024 at 11:07:36
    Re: Return multiple values from Lookup field separated by comma

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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Loading complete