Items of combobox/dropdown which filter Gallery

[lpr]

Hello,

1. question:

There is a sp list which has a field named "users" that pick up users.

Need a dropdown or combobox to filter the gallery in powerapps which its item has to be the distinct records of "users" field.

so while filtring, i can filter by "dropdown.selected.Email.

need assistance for the item.

2. question:

I got an assistance from here

as question 1, i want to put a filter for the customer-projects that will have ID to filter the gallery.

Thanks

[mdevaney]

@lpr 

Question #1

Is your Users column a Person/Group type?  If so, I believe you can achieve your goal with the help of a ComboBox and the FILTER function.  First, create a new ComboBox with the following properties

Items: [@your_SPlist_name].Name
DisplayFields: ["Email"]
SearchFields: ["DisplayName","Email"]
IsSearchable: true

Then put this code in the Items property of your Gallery.

Filter(your_datasource_name,SPemailColumnName in ComboBox1.SelectedItems)

Question #2:

It is unclear what you want here.  What column type is customer projects in SP?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[lpr]

q #1:

column type is just person type.

When i type the listname.column name as for item, at the combobox property, there is no choice to display email or displayname.

it is not working

q #2:

i will ask in another post

[mdevaney]

Can you find either of the properties DisplayName or Email when typing [@your_sp_list_name]. into the Items property?  If the answer is no, can you please try refreshing your datasource?

[lpr]

although database refreshed, nothing found.

[v-monli-msft]

Hi @lpr ,

Insert a dropdown control and set its Items property to:

Distinct(ListName,User.Email)

And set the Items property of your gallery to:

Filter(ListName,  Dropdown1.Selected.Result in User.Email)

Regards,

Mona

[lpr]

set item as "splist.user" or "[@splist].user

i can not get anything for the combobox field property.

[lpr]

the formula is ok but this time, emails are displayed. i want to display the name.

[v-monli-msft · Accepted solution]

Hi @lpr ,

In that case, change your formulas to:

Distinct(ListName,User.DisplayName)

Filter(ListName,  Dropdown1.Selected.Result in User.DisplayName)

Regards,

Mona