web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to turn multiple c...

Power Apps

Answered

How to turn multiple choice column from a filtered list into a gallery?

(0) Share

Report

Report

Posted on by petenmemoq

5

Hi,

I have this sharepoint list containg this data:

Employee column is a person or group column(so it contains user name, email etc)

LicenseType is a multiple choice lookup field.

I want to filter to the current user using the app by email and display their licenses in a gallery.

The list is called "AdobePermanentPool".

But i can either put all choices with

Choices([@'AdobePermanentPool'].LicenseType)

But then this doesnt filter to what the actual user has and there i havent found a way to put a filter in this part

so i could filter to a user.

I tried multiple variations such as:

Choices([@'Filter(AdobePermanentPool, Lower(Employee.Email) = Lower(User().Email))'].LicenseType)

or any this similar, without @ or ' etc...

But it doesnt work. There is no way to filter there?

I want each gallery record to be 1 of the license value.

So if 3 Licenses are assigned, the gallery has 3 records.

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

madlad 2,637 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi!

I think here you're looking for the ungroup function, to separate a record by the license types.

Ungroup( Filter( AdobePermanentPool, Lower(Employee.Email) = Lower(User().Email) ), LicenseType )

^This will separate 1 record with multiple license types into different records for each license type they have. The license type will be referenced by using ".Value" instead of ".LicenseType"

See more about the ungroup function here

Hope this helps!
petenmemoq 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you this was very helpful and what i was looking for.
I didnt know about this function.

Join the conversation