web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter SharePoint Choi...

Power Apps

Answered

Filter SharePoint Choice field based on another column

(0) Share

Report

Report

Posted on by Aethyta

I have the following list with two columns:

- Owner (Person)

- Folder Name (Lookup)

List Name: [Folder Owners]

So if current user is Name2, the Folder Name choice field should only show FolderA and FolderD.

Folder Name	Owner
FolderA	Name1
FolderA	Name2
FolderB	Name1
FolderC	Name1
FolderD	Name2

In power apps, I want to filter the choice field (Folder Name) to only show where current user matches the Owner field.

Currently:

Items = Choices([@'Folder Owners'].'Folder Name')

I tried below but the choice field is empty.

Items = Filter(Choices([@'Folder Owners'].'Folder Name'), Value in Filter('Folder Owners', Owner.Email = User().Email).'Folder Name')

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Tamras ,

Please try:

Filter( Choices([@'Folder Owners'].'Folder Name'), Id in ForAll(Filter('Folder Owners',Owner.Email = User().Email),'Folder Name'.Id) )

Best Regards,

Bof
Verified answer

Aethyta on at

Like
a
(0)

Report
Copy link

Link copied!
Solved. I should have used 'Title' instead of 'Folder Owner' at the last bit.
Items = Filter(Choices([@'Folder Owners'].'Folder Name'), Value in Filter('Folder Owners', Owner.Email = User().Email).Title)
Aethyta on at

Like
a
(0)

Report
Copy link

Link copied!

@v-bofeng-msft Thanks. That worked too - using this one instead. 🙂

Join the conversation