cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Create Notebook (Section) with Calendar Event Date

Hi,

 

i would like to create a Flow which creates a new Section within a specified Notebook if a new calendar event is created. If i add the triggerBody()?['Start'] function to the section name, it returns an illegal character error for the "Create section in a Notebook" part.

Also, i would like to only add the YYYY-MM-DD part of the which is returned by the function. Is there a way to only read out the first 8 characters of the returned value? For example, the created name of the section should look like this:

 

[Date of Event(YYYY-MM-DD)] - [Location of Event] - [Subject of Event]

2019-07-03 - The Moon - Take Photo of Flat Earth

 

I´m not a skilled programmer / developer, but not stupid either... Any help? 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Re: Create Notebook (Section) with Calendar Event Date

@DuckPuppy 

It sounds like you have most of the pieces already except for the time format stuff?  I'm not a skilled programmer either, so I will often use Convert Time Zone.  Check out the Flow below and let us know what you think:

20190702a.PNG

Note the case on the date format...it matters.  I tested this and it seemed to work, but let us know if you bump into any trouble.   (You'll want to adjust the to/from timezones to meet your needs).  For research, I think there is a FORMATDATE expression that will also do this for you.

 

-Ed-

 

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

View solution in original post

4 REPLIES 4
Highlighted
Super User III
Super User III

Re: Create Notebook (Section) with Calendar Event Date

Hi @DuckPuppy ,

 

If you could do the screen shot of your current flow steps that would be helpul.

 

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
Highlighted
Super User II
Super User II

Re: Create Notebook (Section) with Calendar Event Date

@DuckPuppy 

It sounds like you have most of the pieces already except for the time format stuff?  I'm not a skilled programmer either, so I will often use Convert Time Zone.  Check out the Flow below and let us know what you think:

20190702a.PNG

Note the case on the date format...it matters.  I tested this and it seemed to work, but let us know if you bump into any trouble.   (You'll want to adjust the to/from timezones to meet your needs).  For research, I think there is a FORMATDATE expression that will also do this for you.

 

-Ed-

 

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

View solution in original post

Highlighted
New Member

Re: Create Notebook (Section) with Calendar Event Date

Thx! That did exactly what i was looking for!

You, Sir, are awesome 🙂

 

Cheers!

Highlighted
Super User II
Super User II

Re: Create Notebook (Section) with Calendar Event Date


@DuckPuppy wrote:

Thx! That did exactly what i was looking for!

You, Sir, are awesome 🙂

 

Cheers!


Happy to help out!  Thanks for the kind words.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (5,156)