Calendar events not displaying properly in Gallery control

(0) Share

Report

Posted on by taiping8

I am having trouble displaying calendar events properly in a vertical Gallery control.

I ran the following code to get the Calendar ID and then use the ID to retrieve the events.

Set(varUserCalendarId,
LookUp(Office365Outlook.CalendarGetTablesV2().value,
name=Office365Users.MyProfile().Mail).id
);

Set(varCalendarEvents,Office365Outlook.GetEventsCalendarViewV3(
varUserCalendarId,
Text(Date(2022,11,01),DateTimeFormat.UTC),
Text(Date(2023,01,30),DateTimeFormat.UTC)
).value);

However, the events displayed in the Gallery showed only the event date. The timing and event title were not displayed.

I tried another piece of code:

Office365Outlook.CalendarGetItems(varUserCalendarId).value

But this time, only the title was shown and the rest is gibberish:

How can calendar event dates, timings and titles be retrieved and displayed properly?

The documents and blogs I referenced are:

Solved: Display Outlook Calendar Events in PowerApps - Power Platform Community (microsoft.com)

Power Apps Guide - Outlook - How to add, edit, delete, and list Outlook calendar events - Power Apps Guide - Blog

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

taiping8 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Any one who is able to extract calendar events properly?

Was this reply helpful? Yes No
Verified answer

HamidBee 932 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
The way you are displaying the events in the Gallery control might not be properly configured.
To display the events with their dates, times, and titles, you can use the "Items" property of the Gallery control and set it to the "varCalendarEvents" variable that you created with the code you provided.

Then, you can add three labels inside the Gallery control, each one bound to a different property of the events: one for the date, one for the time, and one for the title.

For example:

For the date, you can use the "Start" property of the event, which returns a date and time. You can use the "Date" function to display only the date.
For the time, you can use the "Start" property of the event and use the "Time" function to display only the time.
For the title, you can use the "Subject" property of the event.
Here is an example of how you can set the Items property and configure the labels:
Set the Items property of the Gallery control to "varCalendarEvents"
Add a label inside the Gallery control and set the Text property to:

Date(ThisItem.Start)

This will display the date of the event.
Add another label inside the Gallery control and set the Text property to:

Time(ThisItem.Start)

This will display the time of the event.

Add a third label inside the Gallery control and set the Text property to:

ThisItem.Subject

This will display the title of the event.
Please note that the properties that you are using are specific to the Office365Outlook connector. If you are using a different connector, the properties will be different.
You can also format the display of the date and time by using the Text function and a format string, for example :

Text(ThisItem.Start, "dd/MM/yyyy hh:mm:ss")

It's also worth noting that you need to make sure that you have the correct permissions to access the calendar events and that you are using the correct connector to access the calendar.

If my reply helped you, please give a 👍, & if it solved your issue, please 👍& Accept it as the Solution to help other community members find it more.

Was this reply helpful? Yes No
taiping8 26 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for the explanation and steps. The gallery is now able to display the calendar information perfectly. 👍

I would just to share a couple of minor tweaks to the code. To show the start and end date and timing of the calendar event, I used ThisItem.startWithTimeZone and ThisItem.endWithTimeZone respectively.
For the gallery control, I also selected a different layout in order to have more labels to display the event information.

Was this reply helpful? Yes No