Answered

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

(0) Share

Report

Posted on by bbsin

1,994

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

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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 ) )

Was this reply helpful? Yes No
bbsin 1,994 on at

Like (0)

Report
Copy link

Link copied!

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.

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

Was this reply helpful? Yes No
Verified answer

StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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 ) )

Was this reply helpful? Yes No