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.
As 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