Unanswered

TABLIST

(0) Share

Report

Posted on by CU22071713-3

My modern control Tablist is by dates, I need the dates to be unique in the TabList and appear only once, that way in the gallery below all items with that date will populate. Any help?

Categories:

Experimental features

Picture1.png

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU22071713-3

So you want to be able to click that Date and see all the records below it that belong to that correct?

You would need to Group your records together by the date, but would need to see your data to help you truly build the code itself.

Was this reply helpful? Yes No
Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CU22071713-3

Do you still need help were you able to Group your records? Do you need any specific guidance?

Cheers

Was this reply helpful? Yes No
Suggested answer

PH-07080643-0 2 on at

Like (0)

Report

First you need to get Distinct dates for your Tablist Items:

// Replace 'YourDataSource' with your table/collection name
// Replace 'YourDateColumn' with the name of your date column
ClearCollect(
colDistinctDates,
Sort(
Distinct(YourDataSource, YourDateColumn),
Result,
SortOrder.Ascending
)
)

Then filter your dataset based on the selected date from the Tablist:
// Replace 'YourDateColumn' with the actual name of the date column in YourDataSource
Filter(
YourDataSource,
YourDateColumn = tabDistinctDates.Selected.Result
)

Was this reply helpful? Yes No