Flow and Azure DevOps

(0) Share

Report

Posted on by Community Power Pla...

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:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 68,678 Most Valuable Professional on at

Like (0)

Report
Re: Flow and Azure DevOps

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)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Flow and Azure DevOps

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

Was this reply helpful? Yes No