Unanswered

Filter and search with text field and dropdown

(0) Share

Report

Posted on by ckserra33

421

Hi everyone. I have a gallery that is being populated by another gallery that I am trying to use Search on the field called Name and also use a dropdown on the field called status. I am using Dataverse for my data source, so using Search in this case is ok, I cannot use StartsWith. Also, when the text field is blank, I need it to show all items filtered by the first gallery(gallery5)

I have tried multiple formulas, and this one seems to work the best, I am struggling to add in the formula to include the dropdown for status

Search(SortByColumns(Filter(AmusementAssets, Gallery5.Selected.ActualStoreNumber = CurrentStoreNumber ),"cr3db_name",Ascending),TextInput4.Text,"cr3db_name").

Thank you all for your help!

Chris

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Akash17 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi please refer
https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-gallery-by-Dropdown-and-Input-Text/m-p/1450533
https://powerusers.microsoft.com/t5/Building-Power-Apps/Filtering-dropdown/m-p/952255
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ckserra33

Since you are using Dataverse, there may be a better way to do this. It appears that there is a one to many relationship between the AmusementAsset table and the Stores table. If you have one set up, you can do a filter using dot notation between a gallery of Amusement assets and Stores table, by using Gallery5.Selected.Stores as the Items property of the second gallery. You can then Search it further and sort the results.
ckserra33 421 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp . I am very new to Dataverse. I will look into this kind of filtering. Thank you!
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ckserra33 ,

Could you please tell me:

What is the status column's data type? Is it a text column or a choice column?

What is the drop down's items property? What is the relationship with the dropdown and status?

Maybe you could try:

Filter( SortByColumns(Filter(AmusementAssets, Gallery5.Selected.ActualStoreNumber = CurrentStoreNumber ),"cr3db_name",Ascending), TextInput4.Text in "cr3db_name" && dropdown.Selected.value = cr3db_status )

Best Regards,

Bof