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
Solved! Go to Solution.
Hi @lpr ,
In that case, change your formulas to:
Distinct(ListName,User.DisplayName)
Filter(ListName, Dropdown1.Selected.Result in User.DisplayName)
Regards,
Mona
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."
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
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?
although database refreshed, nothing found.
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
set item as "splist.user" or "[@splist].user
i can not get anything for the combobox field property.
the formula is ok but this time, emails are displayed. i want to display the name.
Hi @lpr ,
In that case, change your formulas to:
Distinct(ListName,User.DisplayName)
Filter(ListName, Dropdown1.Selected.Result in User.DisplayName)
Regards,
Mona