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

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
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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 Kudoed Authors
Users Online
Currently online: 204 members 6,378 guests
Please welcome our newest community members: