Filter events in Gallery by current date and selected date

[BuiDucNghia]

Hi everyone

I am trying to make my custom calendar (as Outlook Calendar), I want:

1. Every app start, Gallery 1 (events) displaying by current date (today)

2. When click on date in weekday gallery 2, events in Gallery 1 will displaying by selected date. Pls help me ( sorry for my Eng)

[v-qiaqi-msft · Accepted solution]

Hi @BuiDucNghia,

Do you want to display the events based on current date once the app is on start?

Could you please share a bit more about your scenario?

1). Set the OnStart property as below:

ClearCollect(Events,SortByColumns(Filter(MyCalendarEvents,Text(Start,DateTimeFormat.ShortDate)=Text(Today(),DateTimeFormat.ShortDate)),"Start")

2). Add a DatePicker and set the OnSelect as below:

Set(SelectedDate,DatePicker1.SelectedDate)

3). Populate the Gallery with the collection as below:

If(
    !IsBlank(SelectedDate),
    SortByColumns(
        Filter(
            Events,
            Text(
                Start,
                DateTimeFormat.ShortDate
            ) = Text(
                SelectedDate,
                DateTimeFormat.ShortDate
            )
        ),
        "Start"
    ),
    SortByColumns(
        Filter(
            Events,
            Text(
                Start,
                DateTimeFormat.ShortDate
            ) = Text(
                _dateSelected,
                DateTimeFormat.ShortDate
            )
        ),
        "Start"
    )
)