web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to return more tha...
Power Apps
Answered

How to return more than one value to list all true values?

(0) ShareShare
ReportReport
Posted on by

Hey guys,

How are you doing? I hope you're all fine.

 

I think for you guys it's just simple to solve but I don't get it by myself. Hope there's a little assistance from your side.

 

Only one symbol listed.pngAs you can see above, this is a custom Dropdown I've created to add icons to each item of the O365 user list.

You can see, that there's a red information icon listed to each of the O365 users.

The Rectangle with the blue names is a Gallery with following Items property:

ShowColumns(
 Office365Users.SearchUser();
 "UserPrincipalName";
 "DisplayName"
)

 

Each of the users are listed with their mail addresses. There's also a column named Column1 (see above) and each record has a column with an OptionSet of True, False and Neutral.

 

In the Visible property of the symbol (red information icon) is following code:

ThisItem.UserPrincipalName = LookUp(CommonDataServiceTable; Column1 = [@Column1].True; Mail)

 

If I choose the LookUp function, only one value will be returned, so is Thomas Cow.

But I want to have all names returned with the True value.

 

How to achieve this?

 

Thanks so much for your support!

 

ThePowerAppsGuy

Categories:
I have the same question (0)
  • Verified answer
    yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @Anonymous 

     

    Can you try to update the expression to:

    ThisItem.UserPrincipalName in Filter(CommonDataServiceTable; Column1 = [@Column1].True).Mail

     

    Hope this Helps!

     

    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS! 

  • Community Power Platform Member Profile Picture
    on at

    Hey @yashag2255,

     

    Exactly what I'm looking for. Thanks so much!

     

    ThePowerAppsGuy

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard