web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Flow and Azure DevOps

Power Automate

Unanswered

Flow and Azure DevOps

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi, I'm trying to get the time spent on a work item. Like, if I activated the user story/task at 15:30 and closed it at 15:44, I would have spent 14 minutes on it. This is what I'm trying to do right now

hd2gTrT.png (615×375) (imgur.com)

Q4Iuv4z.png (615×207) (imgur.com)

iew6cXx.png (1036×182) (imgur.com)

where is expression in the compose is

div(sub(ticks(formatDateTime('tempo_fechamento', 'h:mm')),ticks(formatDateTime('tempo_abertura', 'h:mm'))),864000000000)

(i got the idea for the expression in this link Solved: Convert utcNow to integer - Power Platform Community (microsoft.com))

and the error I get is

Unable to process template language expressions in action 'Compose' inputs at line '1' and column '14946': 'In function 'formatDateTime', the value provided for date time string 'tempo_fechamento' was not valid. The datetime string must match ISO 8601 format.'.

could somebody give me a hint as what to do

Categories:

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
The format for Date time needs to be in ISO 8601 format. When using FormatDateTime in Power Automate use the built-in format of 'o' for that. So use this formula instead.

div(sub(ticks(formatDateTime('tempo_fechamento', 'o')),ticks(formatDateTime('tempo_abertura', 'o'))),864000000000)
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I'm still getting the same error 😞
The flow looks like this iZsFqFW.png (614×634) (imgur.com)
and at the end I'm just sending a message in the Teams app

Join the conversation