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.

All responses (2)

Answers (0)

AdrianP 13 on at

Like (0)

Report

Re: Flow with time, format time from SharePoint

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.
v-yamao-msft on at

Like (0)

Report

Re: Flow with time, format time from SharePoint

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