Unanswered

Flow with time, format time from SharePoint

(0) Share

Report

Posted on by AdrianP

Hello,

I want to send a e-mail at the endtime of an SharePoint list element. My problem is that Flow is handling the times in UTC+8 but i'm in UTC+1 so i have to subract 7 hours from the dynamic input endtime. (eg. When the user writes today 8:00AM in the endtime field, in the flow its then 3:00PM).

I can't use the time trigger from Flow, because the trigger is the creation of a new list element.

I don't know which programming language is used to achive this in Mircosoft Flow.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-yamao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi AdrianP,

I guess that you could use addhours function in your flow.

Please check this documentation about Workflow Definition Language for more details:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

Best regards,
Mabel Mao

Was this reply helpful? Yes No
AdrianP 13 on at

Like (0)

Report
Copy link

Link copied!

Hi, thank you for linking the documentation.

After some time i was certain that the code has to look somethink like this:
@addhours(triggerBody()?['EndTime'], -7)

But for some reason i get "String was not recognized as a valid DateTime" as an Error in Flow. (I also tried to add formatDateTime())

I'm not really sure if i handle the input right. I used this in a similar flow like this:
@equals(triggerBody()?['HasAttachment'], bool('true'))
and this is working just fine.

Was this reply helpful? Yes No