need assistance in parsing a string

(0) Share

Report

Posted on by MS-22072137-0

Hello,

I am attempting to update my flows to use the most up to date API version from my company's contact center software. They changed how time is reported from "averageSpeedToAnswer": "63.612", to "averageSpeedToAnswer": "PT1M3.612S"

I cant use left,right,mid because the string wont stay the same size... and I don't know where to start on using delimiters on this mess..

any help is appreciated.

All responses (2)

Answers (1)

MS-22072137-0 7 on at

Like (1)

Report

Re: need assistance in parsing a string

thanks!
Verified answer

David_MA 11,512 Super User 2025 Season 1 on at

Like (2)

Report

Re: need assistance in parsing a string

The format your company changed to is called duration and is an ISO standard. This post on www.tomriha.com explains how to convert this into a time unit: How to convert ISO duration into single time unit with Power Automate (tomriha.com)