I have a SharePoint calendar(which is just a list) called - Calendar1.
I have a FLOW called: "InviteFlow" which sends a calendar event to the event attendees when the event is approved. (the approval process is using SharePoint designer workflow)
Now I would like to send the cancellation of the same event when the item is marked for deletion from the Sharepoint calendar. For this, I created another flow called CancellatioFLow that is using Delete Event. But this doesn't seem to work. I am not sure how I can delete the same event that was already sent out to attendees using MS Flow.
Any help/ideas are appreciated. Thank you.CancellatioFlow
InviteFLow
Solved! Go to Solution.
Hi @Yudistara,
How many events created within your Outlook calendar when a new event is created within your SharePoint calendar list?
Could you please expand the "Create event (V2)" action within your "InviteFlow" flow?
Further, could you please show a bit more about the Marked For Deletion column in your SharePoint Calendar list? Is it a Custom column?
If you only want to create one Outlook event when a new event is created in your SharePoint calendar list, I think there is something wrong with your "InviteFlow" flow. Your "InviteFlow" flow would create an Outlook event for each attendee of the SharePoint Calendar event within your Outlook Calendar.
I assume that your SharePoint Calendar event has a unique Title, I have made a test on my side and please take a try with the following workaround:
Invite Flow:
The flow works successfully as below:
CancellationFlow:
I suppose that the Marked For Deletion column in your SharePoint Calendar list is a custom column. I have create a Marked For Deletion column which is a Choice type column in my SharePoint Calendar list. Please take a try with the following workaround:
Subject eq 'Title Dynamic content of the trigger'
Note: The Title Dynamic content is wrapped with single quotes within above formula.
Add a "Apply to each" action, input parameter set to output of "Get events (V2)" action. Within "Apply to each" action, add a "Delete event" action, specify Calendar Id and Id field set to Id dynamic content of the "Get events (V2)" action.
Image reference:
The flow works successfully as below:
Best regards,
Kris
Hi @Yudistara,
How many events created within your Outlook calendar when a new event is created within your SharePoint calendar list?
Could you please expand the "Create event (V2)" action within your "InviteFlow" flow?
Further, could you please show a bit more about the Marked For Deletion column in your SharePoint Calendar list? Is it a Custom column?
If you only want to create one Outlook event when a new event is created in your SharePoint calendar list, I think there is something wrong with your "InviteFlow" flow. Your "InviteFlow" flow would create an Outlook event for each attendee of the SharePoint Calendar event within your Outlook Calendar.
I assume that your SharePoint Calendar event has a unique Title, I have made a test on my side and please take a try with the following workaround:
Invite Flow:
The flow works successfully as below:
CancellationFlow:
I suppose that the Marked For Deletion column in your SharePoint Calendar list is a custom column. I have create a Marked For Deletion column which is a Choice type column in my SharePoint Calendar list. Please take a try with the following workaround:
Subject eq 'Title Dynamic content of the trigger'
Note: The Title Dynamic content is wrapped with single quotes within above formula.
Add a "Apply to each" action, input parameter set to output of "Get events (V2)" action. Within "Apply to each" action, add a "Delete event" action, specify Calendar Id and Id field set to Id dynamic content of the "Get events (V2)" action.
Image reference:
The flow works successfully as below:
Best regards,
Kris
HI @v-xida-msft, This is perfect. My InviteFlow didn't have any issues. The only piece I was missing is the Get Event (V2) prior to delete event.
Once i added the Get event (V2) and updated my CancellationFlow as you indicated, everything worked perfectly.
BTW here are some answers to your questions.
Yes, Marked for deletion is a custom column in my SharePoint calendar list.
Below is the screencap of my "Create event (V2)" for your reference
Once again thank you for the support. I love this FLOW poweruser group.
Cheers!
User | Count |
---|---|
36 | |
22 | |
18 | |
17 | |
11 |
User | Count |
---|---|
27 | |
21 | |
21 | |
14 | |
13 |