Power Platform Community Forum Thread Details

Hi all,

Currently have a desk booking app that we want to have set up to remember the users chosen desk booking, and then if needed at a later date they can click cancel and it will automatically remove/cancel it in their Outlook calendar.

So far what I have set up and working is:

A collection called DeskBookings. When the user selects their desk and chosen date, it will run this to grab the Outlook Event ID and store it in the collection:

Collect(DeskBookings, Office365Outlook.V4CalendarGetItems(
 LookUp(
 Office365Outlook.CalendarGetTablesV2().value,
 name = "Calendar"
 ).id
 ).value
);

When they click cancel, it does this:

Office365Outlook.CalendarDeleteItemV2(LookUp(Office365Outlook.CalendarGetTables().value, DisplayName = "Calendar").Name, ThisItem.'Outlook Event ID');

Remove(DeskBookings,LookUp(DeskBookings, "Outlook Event ID" = ThisItem.'Outlook Event ID'));

It seems to cancel the invitation in Outlook which works, but I can't seem to get the collection to remove it from the row.

The problem I'm facing (I think) is that the collection increases by 100-200 rows for every booking and now it is at 3200+ rows, the performance seems to be running a little slower. Luckily this is just in my test version of the app so it's not effecting anyone, but still I need to figure out how to either filter the collection or have it automatically remove rows from the collection once they click cancel.

Any ideas, or even suggestions on how the above could be improved?

Categories:

Building Power Apps