cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bbsin
Post Prodigy
Post Prodigy

urgent help need how to sort also by it category??

HI 

 

anyone can help on the sort by it's category too when user select the tab to view by category and also with the drop down fro ["This Week","This Month","Next Month","Following 2 Months"] 

 

at the moment the dropdown is working fine but it's showing overall.. how to be able to display by category only when user click?? thank you

 

SortByColumns(
Filter(
'EventInfo(Admin)',
IsBlank(CalculatedStartdate) || (StartDateAdmin >= CalculatedStartdate && (IsBlank(CalculatedEnddate) || EndDateAdmin <= CalculatedEnddate)) && Category.Value = galCatTab.Selected.Name
),
"StartDateAdmin",
If(
IsBlank(SortDescending1) || SortDescending1,
Descending,
Ascending
)
)

 

Category.Value = galCatTab.Selected.Name - nothing happened when I click on the tab.. thank you

 

@StalinPonnusamy  - not sure if you can help too?  Thank you

 

bbsin_0-1631780962807.png

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
StalinPonnusamy
Super User
Super User

Hi @bbsin 

SortByColumns(
Filter(
'EventInfo(Admin)',
(IsBlank(CalculatedStartdate) || (StartDateAdmin >= CalculatedStartdate && (IsBlank(CalculatedEnddate) || EndDateAdmin <= CalculatedEnddate))) && (IsBlank(galCatTab.Selected.Name) || Category.Value = galCatTab.Selected.Name)
),
"StartDateAdmin",
If(
IsBlank(SortDescending1) || SortDescending1,
Descending,
Ascending
)
)

View solution in original post

StalinPonnusamy
Super User
Super User

Hi @bbsin 

 

This query does not filter anything when the Overall tab is selected.

SortByColumns(
Filter(
'EventInfo(Admin)',
(galCatTab.Selected.Name = "Overall") ||
((IsBlank(CalculatedStartdate) || (StartDateAdmin >= CalculatedStartdate && (IsBlank(CalculatedEnddate) || EndDateAdmin <= CalculatedEnddate))) && (IsBlank(galCatTab.Selected.Name) || Category.Value = galCatTab.Selected.Name))
),
"StartDateAdmin",
If(
IsBlank(SortDescending1) || SortDescending1,
Descending,
Ascending
)
)

 

View solution in original post

3 REPLIES 3
StalinPonnusamy
Super User
Super User

Hi @bbsin 

SortByColumns(
Filter(
'EventInfo(Admin)',
(IsBlank(CalculatedStartdate) || (StartDateAdmin >= CalculatedStartdate && (IsBlank(CalculatedEnddate) || EndDateAdmin <= CalculatedEnddate))) && (IsBlank(galCatTab.Selected.Name) || Category.Value = galCatTab.Selected.Name)
),
"StartDateAdmin",
If(
IsBlank(SortDescending1) || SortDescending1,
Descending,
Ascending
)
)

hi @StalinPonnusamy 

 

Thank you it's working but I have a tab that is call overall, when I click on it this tab is not show all the records.

bbsin_0-1631798100600.png

 

The other specific tab will not be affect by the drop down right for this week, next month etc.  

 

I have a question, if it happens that there no event with that month , week for any of the tabs.. is there any way to have a pop up stating no event happening now?  Thanks

 

Thank you

StalinPonnusamy
Super User
Super User

Hi @bbsin 

 

This query does not filter anything when the Overall tab is selected.

SortByColumns(
Filter(
'EventInfo(Admin)',
(galCatTab.Selected.Name = "Overall") ||
((IsBlank(CalculatedStartdate) || (StartDateAdmin >= CalculatedStartdate && (IsBlank(CalculatedEnddate) || EndDateAdmin <= CalculatedEnddate))) && (IsBlank(galCatTab.Selected.Name) || Category.Value = galCatTab.Selected.Name))
),
"StartDateAdmin",
If(
IsBlank(SortDescending1) || SortDescending1,
Descending,
Ascending
)
)

 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (4,242)