Hi, I'm using a Sharepoint add-in that manages time off, the add-in creates a Sharepoint list/calendar where the time off entries are stored, I am using a flow where it then enters these into an Outlook calendar using a "Sharepoint when an item is created" trigger and then an "Outlook create an event" action.
What I want to do is create a flow where it will delete the calendar entry if it is deleted from the Sharepoint list. The only availble sharepoint attrbute available to the When an item is deleted trigger is ID, so I have stored the ID in the body of each event when they are created (with no other text).
My current idea for a flow would be somehting like:
Can anyone give me an example of how this could be done, I've done a lot of Googling and tried different configurations and I'm a bit stuck as I'm not proficient in Power Automate.
Thanks In advance for any help!
Rick
Hi, sorry I must have missed this. In case it is of any use I am using a solution by a company called Ivero Welcome to IVERO.NET, it's a basic SharePoint based software and but works well enough, they also offer lifetime licenses which is unusual in these times of subscriptions! You need to make sure you are placing the ID in the body.
Flow works without errors, unfortunately it does not delete anything from the calendar.
Hi @v-litu-msft,
I have tried this below but no content appears in the html to text conversion if I use the body property in the action, I did try using the ID but this appears to be deleting all calendar events for the user, I am testing with a test account at the moment.
Could you please advise?
Thanks in advance.
Hi Rick,
May I please ask what you are using to track leave? Also the automation and any other useful information please?
Thank you in advance!!
@v-litu-msft thanks so much for the great reply/solution works perfectly!
Hi @RichardHy,
Please refer to the following steps to approach that:
1. Create a trigger when an item is deleted;
2. Get Events;
3. Apply to each action + HTML to text action, loop events, and convert their body to text;
4. Create a condition action, check if the body equals to the deleted item ID (this part should convert the integer ID to a String ID):
string(triggerOutputs()?['body/ID'])
5. If yes, delete the event by using Event ID get from the Get events.
Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
WarrenBelz
146,651
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional