Is there a way to save the eventID of a calendar event after creating it?

(0) Share

Report

Posted on by FacundoGorla

293

Hi! to give a little context I created an app that manage calendar.

It has it's own calendar but my client wants to also use Outlook calendar so this app has the same data in Outlook calendar and in sharepoint (I'm using SP lists as datasource).

Now, one thing that's problematic is to edit and delete already created events from the app since you need the eventid.

My cuestion is if there's a way to immediatly save the eventid after creating it using the Office365Outlook.V4CalendarPostItem function in powerapps so I can Patch my SP list items with that ID to later use it in case of needing edit or delete the event

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-yutliu-msft on at

Like (0)

Report
Hi @FacundoGorla ,

Do you want to get the event id that you last created?

If so, I suggest you get events by using V4CalendarGetItems function, and then sort the result based on created time.

The last item's ID would be the event id that you want.

Try this:

Last(Sort(Office365Outlook.V4CalendarGetItems(Calendar id).value,createdDateTime)).id

Please replace Calendar id with the Calendar id when you create the event.

You could use this to get the calendar id:

LookUp(Office365Outlook.CalendarGetTablesV2().value,name="Calendar").id

Or filter based on other name, like "Birthday","Holiday",etc.

Best regards,

Was this reply helpful? Yes No
FacundoGorla 293 on at

Like (0)

Report

@v-yutliu-msft wrote:
Hi @FacundoGorla ,
Do you want to get the event id that you last created?
Yes!

I'll try that and get back to you. The main thing is that I onyl want the last one so I want to limit the amount of event I "load" with the getitems. I guess I have to limited that with the Createddatetime. I'll see what I can do and get back if I have any issue.

Just to comment, my way of solving it was making a colection with all the SP list items that don't have an eventid, then in another gallery I would have all the calendar events with the same name.
Then i would patch the items getting the id from each element using a lookup function

Thanks, as always, for the answer!

Was this reply helpful? Yes No
hkmamun 106 on at

Like (0)

Report
@v-yutliu-msft Can you please tell me what will happen for below situation,
Lets say, I am creating event from Power App by using Office365Outlook.V4CalendarPostItem() function, after that I am following your process to get the last created Event ID with below code
Last(Sort(Office365Outlook.V4CalendarGetItems(Calendar id).value,createdDateTime)).id
so when the upper code is processing that time another event is created in my calendar from outside the app (may be from outlook desktop client or outlook online web or someone invite me for a meeting) and it was created before few millisecond while the upper code executing . So in that case which Event's ID the upper code will return.

Thanks!

Was this reply helpful? Yes No