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

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

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

Power Automate Video Tutorials
Super User II
Super User II

@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

Thx! That did exactly what i was looking for!

You, Sir, are awesome 🙂

 

Cheers!


@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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (7,369)