i am trying to create a filter on a gallery to filter on the values of the Status column from sharepoint list.
The sharepoint list column is named Status. And the choices are "Awaiting Management Approval","Rejected", "Approved" in this column on the list.
How do I create a filter on my powerapps gallery to filter for those words in the Status.
Example in the filter if I type "Approved" in the filter then the fields I created in the gallery will populate this information.
Solved! Go to Solution.
Hi @panda ,
So you change to use Dropdown to select the choices, rather than Textinput box, right?
If so, I think the Items property of Dropdown should be set to Choices('SP'.Status), then modify the Gallery,Items as follows.
Filter('SP list', Status.Value=DropdownName.Selected.Value)
Hope this helps.
Hi, where do i need to set this --> the Items property of Dropdown should be set to Choices('SP'.Status). Do, i need to hard code the whole gallery?
FYI, the code item that i apply for my gallery now is -> SortByColumns(Filter([@'SENARAI ASET UNIKL'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))
because i have search textsearchbox also.
I try to apply this on my dropdown , Filter('SP list', Status.Value=DropdownName.Selected.Value) however, at last part selected.value, i try to insert the word value, but it can't work.
hehe, can you help me?
Thank you! I've been working on this for 2 weeks off and on. Even recreated my data (small databases) and started over on my app. I finally have it working!
Learn how to create your own user groups today!
Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!