Filtering gallery using multiple filter.

[sagar_shah]

Hello Everyone,

I am developing app where I am having gallery and it is filter using Filter function but also want to add Dropdown or search box how can I filter data with help of multiple filtering.

I am attaching ss please have a look any help will be good.

using drop down the code is : If(Dropdown6.Selected.Result = "All",TaskTable,Filter(TaskTable,ProjectName.Value = Dropdown6.Selected.Result))
now I want to filter using User login like whenever user logs in task related to him should be displayed plus i should able to sort data ascending or descending format.
Regards,
Sagar Shah

[eka24]

Hi use:

Sort(If(Dropdown6.Selected.Result = "All",TaskTable,Filter(TaskTable,ProjectName.Value = Dropdown6.Selected.Result,Email=User().Email)),ColumnToSort)

Or

Sort(If(Dropdown6.Selected.Result = "All",TaskTable,Filter(TaskTable,ProjectName.Value = Dropdown6.Selected.Result,Email.Value=User().Email)),ColumnToSort)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[v-xida-msft · Accepted solution]

Hi @sagar_shah ,

Based on the needs that you mentioned, I have made a test on my side, please take a try with the following formula (Set Items property of Gallery to following😞

Sort(
   Filter(
       TaskTable,
       If(
          Dropdown6.Selected.Result = "All",
          true,
          ProjectName.Value = Dropdown6.Selected.Result
       ),
       Email = User().Email
   ),
   Start-Date,             // sort your Filter results based on Start-Date column in your TaskTable
   SortOrder.Descending
)

Please consider take a try with above solution, then check if the issue is solved.

Best regards,