copy event notes to OneNote from Outlook calendar

[spatel]

Hello,

I am trying to setup flow , that copy all event from now to all future event from Outlook Calender to OneNote (My Notes) section. 

some how its not working

here are the snapshot

Thank you!

[AlanPs1]

Hi @spatel , thank you for your post.

From your description, you say you want to "copy all event from now to all future event".

Based on this, it doesn't sound to me that you would need your condition.

Could the Flow you want just be the following perhaps?

I have tested this and it is working, although when I edit an existing event this happens:

So I have made the following changes:

Just some food for thought above, but in simple terms ... When you say:

"I am trying to setup flow , that copy all event from now to all future event from Outlook Calender to OneNote (My Notes) section. "

I cannot see any need for the condition you are using. To copy "All" events, thre is no need for a condition.

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

[spatel]

Hello Alan,

Thank you!

could you please advice on following question?

Thank you

[spatel]

Hello Alan,

Well i followed the same path that you have provided and it work well with first event creation and i added other event to calender and it failed and error message says "

An item with this name already exists in this location" is there a way tha if can keep loop running even the event is not updated the exsisiting one. 

and it only grabbing the current date event not the all event that we laready created for future event.

Please advice, if i am doing incorrect steps!

Thank you very much

[AlanPs1]

Hi @spatel 

In your OneNote notebook, what are the names of the sections you have in there at present?

Is there a section called "Test Event" already perhaps?

Maybe post a picture of your onenote so I can see the names of the sections you have in there already.

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

[spatel]

Hello Alan,

Please see snapshot of OneNote.

Note: it takes a while to create a section, is there a condition that i can add as soon as event created it create a OneNote section.

Thank you!

[AlanPs1]

Hi Spatel.

Forgive me if I am missing anything. But you have a section called “Test Event”. It can’t create another with the same name hence the error.

Thanks, Alan.

[spatel]

Hello Alan,

From outlook it only one "Test Event" created from calender and through FLOW it create a OneNote Section, as soon as it created if i test run and it failed with conflict error "

An item with this name already exists in this location". now my question is, is there a way that if i can avoid these conflict error and let the exsisting event from outlook to update to OneNote. in this case if my event fromoutlook updated or not updated then still FLOW look will run and check if necessary to update the exsisitng event or not but still it will not throw any error. it jusy the sync cycle will continue. and once the evet date expire then it will close the connection and flow will start to sync event from outlook caleder on next date.

Please advice!

Thank you

[AlanPs1]

Hi @spatel , thank you for the clarification ... 2 things to consider.

1) when testing, as there is already a section, the test will always fail as you are trying to recreate a section with the same name.

2) Please see the further enhancement I have made, it creates a page within the section if the section is found to exist.

When I do this using the same section name, let's say test event, I get the following in OneNote:

It creates a new page called "untitled page" within the existing section:

The value I have used in "Notebook Selection" is:

items('Apply_to_each')?['pagesUrl']

The action to use in the "No" branch is called "Create page in a section". I can't see a way to name these pages (OOTB) but at least there is a way to add multiple updates to a section and also avoid the conflict.

Please give it a try.

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

[spatel]

Hell Alan,

Thank you very much for help!

Still it's not working see below snapshot!

[AlanPs1]

Hi @spatel 

The error is on the left hand side, it is showing conflict again

Can you please try creating a completely new email with a completely diferent subject and allowing the Flow to trigger normally.

Once you have done that, run the test flow again and see what happens.

It is working for me when I do this.

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

[spatel]

FYI

ERROR : The caller with object id '4253d68d-cd70-4408-95f8-fb776157d639' does not have permission for connection '7bfd1acb-296e-4050-9205-c61c6acde498' under Api 'shared_logicflows'.

[AlanPs1]

Hi @spatel 

This looks to be a diferent issue. Some information on that here - https://powerusers.microsoft.com/t5/Using-Flows/Invalid-Connection-error-on-a-Flow-that-has-been-wor...

Looks to be permission related and was resolved after a few hours. Maybe you could recreate the connection to the connectors you are using.

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

[spatel]

Hello Alan,

It ran yestereday succesfully and i ran today in morning and it failed only with both YES/ NO Condition "Create a section OneNote"

OneNote: auto sync few minutes ago and it popup " Monday Test" with body message that was created yesterday.

[AlanPs1]

Hi @spatel .

If I am understanding correctly, is that it all working for you now?

If so, in order to assist the other forum users when they search, can you please click "Accept as solution"

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan

[spatel]

Hello Alan

Well it work and not. while i manually test condition YES and NO both failed, may i know why? beside i can see the event created in onenote but it did not include the BODY message from OneNote!

also i have many event already created in Outlook calender from current date to future date. then why it not create all those future event in OneNote? it just create a current date!

Thank you,

Sagar Patel

[spatel]

Hello Alan,

Finally it fixed through following snapshot (i added second condition in apply to each)

Now: only error is exsisit is it create page in section ( i mean it duplcating the same event while it run)

how do i stop to duplicate?

how do i make trigger, if there is outlook calender evetn chnages then update the exsisitng page in OneNote ection?

[spatel]

items('Apply_to_each')?['pagesUrl']

above value copy the event from calender to OneNote but some how it copy the same event in all section and on your image attached  Note for event 1 is keep generiing Untiled page as many while it sync.

whta i am looking that it update the exsiting untitled page insted of generating more untitled page.

[AlanPs1]

Hi @spatel , sorry for the late reply. 

As far as I can see there are no actions that allow you to either ...

1) Update a section

2) Update a page in a section

Only to create.

So, out the box it doesn't look possible. You could consider creating a custom connector to see if you can get it working maybe, but that will take you into "developer territory",

If you have found my post helpful, please mark thumbs up.

Any other questions, just ask.

Thanks, Alan