Answered

How to filter on user combobox ?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I created from a SharePoint list a PowerApp. One of my SharePoint metadata is a people field. I created a user combobox on the landingpage. Below the combobox you will see all the list items. I would like to filter the list items by the selected user in the combobox. How to filter on a user combobox?

I try this but it is not working:

Filter(CoronaWerkplekRooster, Persoon=PersonDataCardValue4_1.SelectedItems.Claims)

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

The easiest way to go about that would be to consider the following formula:

Filter(CoronaWerkplekRooster, Persoon.Email = User().Email )

This will give you items where the email in SharePoint is equal to the email of the current user.

Note, sometimes the case of the two emails is different and a Lower function needs to be applied.

I hope this is helpful for you.

Was this reply helpful? Yes No
dreamsat 96 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes Thanks! I dont want to filter on the current user. I would like to filter on the selected user in the combobox.

PersonDataCardValue4_1.SelectedItems

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@dreamsat

Selected "User" or "Users"? Is this a multi-select combobox, or are you just interested in the currently selected person in the combobox?

Was this reply helpful? Yes No
dreamsat 96 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes the selected user. Only 1 user, not multiple users.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@dreamsat

Very good. Then your filter formula should be this:

Filter(CoronaWerkplekRooster, Persoon.Email = PersonDataCardValue4_1.Selected.Email )

That should give you what you need.

Was this reply helpful? Yes No
dreamsat 96 on at

Like (1)

Report
Copy link

Link copied!

great it works!

Was this reply helpful? Yes No