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?
Solved! Go to Solution.
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:
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.
Hi @DuckPuppy ,
If you could do the screen shot of your current flow steps that would be helpul.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsIt 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:
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.
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.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
44 | |
41 | |
36 | |
36 | |
22 |
User | Count |
---|---|
40 | |
33 | |
28 | |
27 | |
27 |