Answered

Problem passing correctly formatted date to Outlook Out of Office

(0) Share

Report

Posted on by dynamicl

Hi,

I've just started to work with flow and have been testing out various functionality. I want to create a flow that activates your OOO for 1 hour and I have tried the following without success:

Start: @{addhours(utcnow(),1)}
End: @{addhours(utcnow(),2)}
ERROR: "message": "Invalid value '@{addhours(utcnow(),1)}' for parameter 'ScheduledStartDateTimeOffset'",

Start: "@{addhours(utcnow(),1)}"
End: "@{addhours(utcnow(),2)}"
ERROR: "message": "Invalid value '\"2017-05-11T10:43:33.8798644Z\"' for parameter 'ScheduledStartDateTimeOffset'",

Start: "@{concat(formatDateTime(addhours(utcnow(),1),'s'),'-00:00')}"
End: "@{concat(formatDateTime(addhours(utcnow(),2),'s'),'-00:00')}"
ERROR: "message": "Invalid value '\"2017-05-11T12:18:08-00:00\"' for parameter 'ScheduledStartDateTimeOffset'",

For some reason, the fields seem to require quotation marks around the date expression ... but then that makes it invalid. If I type in the dates manually it works perfectly. There is a calendar flow template that uses the utc date expression and that seems to work fine.

Am I being stupid and missing something obvious or is this a bug with this particular Outlook action?

Hope you can help,

Many thanks
Maurice

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

RajRa Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Can you post a view of how you are trying to achieve this? In general you currently cannot input logic app expresssion into the actions cards at thsi time.

Was this reply helpful? Yes No
Verified answer

v-micsh-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @dynamicl,

As @RajRa mentioned, currently the DataCard of the Action can't accept the expression as valid input, as you have noticed, the outputs of the expression would contain double quotes.

To workaround this, please consider add two Compose Action, then use the Compose output as the Parameter, this would remove the double quotes:

Was this reply helpful? Yes No
dynamicl 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thank you for your help ... the compose option works perfectly!

I think the built in calendar template confused me because when you edit it you see this, so I assummed you could do inline expressions ...

Was this reply helpful? Yes No