cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DuckPuppy
Level: Powered On

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

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

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!



Super User
Super User

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
DuckPuppy
Level: Powered On

Re: Create Notebook (Section) with Calendar Event Date

Thx! That did exactly what i was looking for!

You, Sir, are awesome 🙂

 

Cheers!

Super User
Super User

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

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

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