Forum Discussion
Built in function to only show todays outlook calendar events?
Hello all, I am currently designing a visitor sign in kiosk where it shows if the visitor is expected for a meeting at my company and allows them to sign in. Currently I'm using 2 or 3 collection to ...
Hi flowadm20000 ,
If you are using events that are stored in a list or in dataverse, then you can speed things up if you create a new string column as a quick "index" in your database.
On item save write just a date string (like "09/14/2023") into that column.
If you want to filter hourly, add another text field and fill it like "09/14/2023 10:00" for all entries between 10:00 and 11:00
Then just filter for that string value. Filtering for string equality should directly be delegated to the database and should be much faster than calculating dates while querying.
If you are trying to access events from an exchange calendar then you can use this command.
Office365Outlook.GetEventsCalendarView(
LookUp(Office365Outlook.CalendarGetTables().value;DisplayName="MyCalendarName").Name;
"2023-07-03T00:00:00.000Z";
"2023-07-03T23:59:00.000Z"
).Values
Best Regards,
Sven
Best Regards,
Sven