cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Flow to copy, Amend or Delete calendar entries in O365`

I am looking for a method of monitoring a web based calendar (from a 3rd party) for changes and replicating these in my primary O365 calendar.  

 

I have built the flow that appears to be most logical but it fails, The sync time between O365 and the external calendar is Approx 3 hours which means testing is somewhat disjointed (Can this be reduced at all?), so we have moved to testing using the inbuilt "Birthdays Calendar" in O365 for speed and to rule out the issue being with permissions relating to the web calendar, but get the same failure;

 

Your request can't be completed. Read-only calendars can't be modified.
clientRequestId: 9e48e898-5135-4e9e-bb0f-cbd0b7ce7d29
serviceRequestId: 17a371e4-5c9a-443c-a25b-b1db0619678b

 

The flow I have set up is;

When an event is added, updated or deleted (V3)

 Calendar id is Birthdays (Selected from the drop down)

 

Update event (V4)

All options are selected from the drop down or the dynamic content selection toolbox

Calendar id - Calendar (drop down)

id - id (dynamic content)

Subject - Subject (dynamic content)

Start - Start time (dynamic content)

End - End time (dynamic content)

Time Zone - UTC+00.00 (drop down)

 

If I create the same with a "create" entry output it works fine but id outputs of  "Modify" or "delete" are used on their own or as part of the Update Event output I get the same error.

 

Can anyone please assist with this?  I am new to power flow and would like to get this working as it is holding up a larger project we are trying to deploy.

 

Many thanks in advance

6 REPLIES 6
abm
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous

 

Let see the below links can be helpful or not. If not please update.

 

Solved: can't share Google calendar to outlook.com by Micr... - Power Platform Community (microsoft.com)

 

Solved: Office365.V2CalendarPostItem - Power Platform Community (microsoft.com)

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

@abm Thank you for responding.

 

Permissions on"Calendar" are set to people in my organisation can edit.

The permissions on Birthdays or the 3rd party calendar can't be edited.

On Birthdays I can write and delete evens so have full permissions to that and on the 3rd party, this is read only.

 

The error is coming up on the output path which suggests that the "Calender" is the issue, but changing permissions here appears to have made no difference.

 

"Calendar" appears to be my default calendar already and both lists come up with the same order when I build the flow.  I am sorry, but I am unsure what a drop down control is or how to create it, so this has not been attempted.

 

Please find below my flow and the error received.  

Many thanks

 

Flow.jpgFlow error.jpg

 

 

Anonymous
Not applicable

Morning @abm 

Thanks for your time and assistance yesterday.  The changes you made to the flow far exceeded where I woudl have go t to.

 

I have asked our Admin about permissions and wait to hear from then.  

The issue with not having permission to delete using the flow (Calendar reports as being read only) is a strange one when I can can create and delete manually and we can create using the flow - hopefully it will be a simple fix and I will keep you posted.

abm
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous 

 

Thanks for your update. Once the permissions are sorted test again. If not raise a MS support ticket for this. Explain about you can manually create and modify using another flow.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Anonymous
Not applicable

@abm Thanks for all your help with this.  After many hours on support with MS I am at the point of throwing in the towel and just changing the software that we were using, but wanted to give you an update on this as there are several things going on.

 

Firstly, we need to start with the create function which worked perfectly - when and event is added in Birthdays (source) - create in Calendar (Output).  

 

Second process was if modified in Birthdays - update in calendar - we had a get event function in here to get the event id in calendar that matched the birthdays one 

LeonKJ_0-1625653889351.png

 

We were getting an error to say that the calendar was read only despite being able to read/ write in the output within outlook online.  This stumped us when we spoke and several MS engineers on both Powerapps and O365  support.

 

There are 2 issues here

1 - the get event function looks for the event ID from the source calendar (Birthdays for our test) then tries to modify the same event in output (primary calendar in this case).  However, during the create process the new event in the output has a different ID.  The system should flag this as an ID error as  the ID does not exist in output but there is a glitch in the software that does not flag this up as an issue.  The process should have stopped here with an ID error  

 

2 - As the event id is in the source - the process then tries to update the event in the source (even though we have entered for it to be updated in output.  This is where the second "Glitch / issue" comes in. as it shoudln't have tried this.

Whilst I have full read / write permissions for the Birthday calendar in outlook online, the flow uses Graph API to make the changes, and the GraphAPI permissions say that I don't have edit for Birthdays so we get the error message that the calendar is read only.

Whilst we can change the Graph API settings to be Edit =True, this does not help as it is still trying to write to the source calendar and not the output calendar required, so isn't something we will pursue.

 

I am told that we would need to write several flows or 1 large one which would incorporate look up tables of IDs so would go something like

 

When created in Source - create in output - get and write the IDs for both both the source event and output event in to an excel table, where  they will be used to look up for future changes

 

When a source event is modified - find the original Source ID in excel - cross reference to the ID of the output calendar then modify that event in output calendar

 

For deletions they suggested something along the lines of when a source calendar event is deleted, find the ID in the excel table, delete the corresponding event in the output calendar and delete the line from the table in Excel.  However, the chap i spoke to also mentioned that this may not work as he wasn't sure there would be a trigger to set off the flow, and what we might need for delete is a regular check of entries to periodically check the Source Calendar IDs in excel against what is in the source calendar - if an ID in the table is no longer in the source calendar, get the corresponding id for the output calendar from the table, remove the event from the output calendar then delete the line from the table.

 

It was thought that this would probably need to be set up for each user with their own record table and so will be horrendously long winded to manage and so probably not worth progressing with.

 

I have also discovered that the latency experienced in Outlook.office.com on subscribed calendars is generally around 3 hours but that Microsoft's official line is that that they can take up to 24 hours to update.

 

Thanks again for your help on this - just wanted to let you know the findings in case you come across some of these erroneous errors again.

abm
Most Valuable Professional
Most Valuable Professional

Hi @Anonymous 

 

Thanks a lot for the detailed explanation. Definitely this feedback is very useful for the community.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22   Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2   Anil_g2   SharonS2  

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (1,335)