MS form date to flow to group calendar, adding time issue

[slewis1972]

Hi

So, MS Form collected a leavers end date.

Flow sends all details to HR via email - fine.

But want to add the date to a group calendar - fine BUT....it adds it at time 00:00

I want the time to be like 5pm. How can I add hours to the data submitted considering in ms forms you only 

[efialttes]

Hi!

Assuming you have your input date in ISO8601 format, you can use addHours() WDL function

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#a...

If you are unfamiliar with WDL expressions, great stuff here

https://flow.microsoft.com/es-es/blog/use-expressions-in-actions/

Now, please let us know your progress, if you find a blocking issue, do not hesitate to write back, in such case please remember to add a screenshot from your current flow design

Cheers!

[slewis1972]

Hi I am populating the time from a data field from MS forms.

The value 'addHours('2020-08-21', 10)' of parameter 'DateTime' is invalid.

So looks like its now ISo format. Any ideas how to fix?

[efialttes]

Mmmm....

I just tested the very same WDL expression you shared and as you can see in the screenshot below it is working fine. Just wondering if you can share a screenshot from your flow design, so we can see how you added the expression and try to figure out why it is failing

THanx!

If you are unfamiliar with WDL expressions, please follow these steps to add them to an action block (both the expression and the action block in the video are not related to this issue):

https://youtu.be/LPZ-WZoWwp4

Hope this helps

[slewis1972]

Hi

Using it to create a group event (calendar), using a dynamic field from the MS form.

Code is:

            "start": {

                "dateTime": "addHours('@{triggerBody()?['rb2791dae94f94ba3b8a97c6b5a18a92e']}', 10)",

                "timeZone": "UTC"

[efialttes · Accepted solution]

Hi!

The problem is, that way you are adding WDL expressions by typing them directly to the action block target input, which is a wrong approach.

Please follow these steps to add them to an action block (both the expression and the action block in the video are not related to this issue):

https://youtu.be/LPZ-WZoWwp4

Hope his helps

[slewis1972]

Hi,

Adding expression in correctly now eg

formatDateTime(triggerBody()?['rb2791dae94f94ba3b8a97c6b5a18a92e'],'yyyy/MM/dd 17:00')

But date is off by an hour. How do I correct the time zone?

[efialttes]

Hi!

So, the problem you originally reported is now solved, right?

Hurray! Great Job!

So, please mark this topic as "Solved" by clicking "Accept as a solution". THis way others facing a similar problem can find a solution faster. Please also note you can even select several responses as solution, even from different community members!

Now, on your new challenge... please note there is another WDL function called convertTimeZone()...

https://powerusers.microsoft.com/t5/General-Power-Automate/Formatting-Date-And-time-in-MS-Flow/m-p/7...

...and also an action block for the same purpose...

https://powerusers.microsoft.com/t5/Building-Flows/Converted-time-is-an-hour-out-on-Sharepoint-list-...

In the meantime, please remember that the easiest fastest way to say thanks to somebody that simply tried to help, even on weekends is by clicking on 'Thumbs up' in every answer from this current thread you found valuable... or even in all of them 😉

Please let us know your progress!

[Zaschen]

do you have this as text? I don't get on with watching videos