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
Community Champion
Community Champion

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
Community Champion
Community Champion

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
Community Champion
Community Champion

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
Community Champion
Community Champion

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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,247)