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
Solved! Go to 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,
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.
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,
User | Count |
---|---|
176 | |
116 | |
85 | |
44 | |
41 |
User | Count |
---|---|
239 | |
153 | |
131 | |
77 | |
72 |