Answered

Filter Gallery with Combo Box User List

(0) Share

Report

Posted on by Motty_25

Hi,
I have created a Combo Box (ComboBox4) which allows me to select users from our Office 365 Directory (through the use of the Office365Users data source).

However, I want to set up a filter gallery that filters results based on the user I have selected in the ComboBox, but I am struggling to do this.

So far, I've tried:
Filter (<DataSourceName>, ComboBox4.SelectedItems)
Filter (<DataSourceName>, ComboBox4.SelectedText)
Filter (<DataSourceName>, ComboBox4.Selected)

But none have worked.

Would appreciate any help on this. 🙂

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You need column to match. Let's say you have email column in the list you want to filter based on User. That list have column named email. then gallery's item code will be
Filter(ListName, Email = ComboBox1.Selected.Mail || IsEmpty(ComboBox1.SelectedItems );

The above code will filter data by user's email in that list and if nothing is selected it will show all data.

Was this reply helpful? Yes No
Motty_25 29 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @zmansuri

Many Thanks for your reply, although unless I've mis understood, it hasn't worked.

I have a column called Current Owner in the list I want to filter. That column is a user column which pulls data from our M365 directory.
I have a ComboBox, also pulling users from the M365 directory, and showing them as their DisplayName.

I want the filter gallery to show all entries where the DisplayName selected on the combo box, matches the name in the Current Owner field.

For example, if I enter an asset with the Current Owner set to Ben Mottram, I want that asset to appear in the filter gallery when "Ben Mottram" is selected on the dropdown menu.

The syntax I entered was:
Filter(List Name, 'Current owner' = ComboBox4.Selected.DisplayName || IsEmpty(ComboBox4.SelectedItems )

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Motty_25,

Have you solved your problem?

Do you want to filter based on the Combo Box selected user?

Could you please share a bit more about your scenario?

Please modify your formula as below:

If( IsEmpty(ComboBox34.SelectedItems), Product, Filter( Product, 'Current owner'.DisplayName in ComboBox34.SelectedItems.DisplayName ) )

I assume that the 'Current owner' is a Person column in your SP list.

Was this reply helpful? Yes No
Motty_25 29 on at

Like
a
(0)

Report
Copy link

Link copied!

That works, thank you!!

Was this reply helpful? Yes No