See if these steps help@Rapikur_
Let's say you are using a SharePoint List.
Step 1: Create a Power App or open your existing Power App. Make sure you have the data source (i.e. Books list) connected.
Step 2: Add a dropdown and a text input field for search.
- Click
Insert in the ribbon, go to Input, and click on Dropdown.
- Then add a Text input field for search. Click
Insert in the ribbon, go to Input, and click on Text input.
Step 3: Set the Items property of the dropdown.
- Suppose that you are using a SharePoint list and you want to use a column, say 'Category', you could use the
Distinct function to get unique categories. Set the Items property of the dropdown control as Distinct('YourDataSourceName', Category)
Step 4: Add a Gallery control to display the books.
- Click
Insert in the top menu, go to Gallery, and choose the layout you prefer (e.g., Vertical or Horizontal).
Step 5: Set the Items property of the gallery.
-
If you want to search by 'Creator' and filter by 'Category' selected in the dropdown, you could use the Filter and Search function together.
-
Try to set the Items property of the gallery as something like this: Search(Filter('YourDataSourceName', Category = Dropdown1.Selected.Result), TextInput1.Text, "Creator")
You may need to adjust the formula for your use case.
Replace 'YourDataSourceName', Category, and Creator with the actual names used in your case.
The search function should usually not be case-sensitive in the case of SharePoint List, and it should return all records that contain the string from TextInput1 in the 'Creator' field, and match the selected 'Category' from Dropdown1. Note that while Filter and Search may not be case sensitive, any string comparison used in those formulas on the column like Title = "My Title" - this may be case sensitive.
See if it helps @Rapikur_
