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
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,636)