Compose action to remove Text and only store number value

(1) Share

Report

Posted on by dafdsafdsaf

Hello.

I have a several Compose Actions that have an output that look like this

[

{

"[KPI]": 0.9333333333333333

}

]

[

{

"[KPI Delivery Value]": 0.9090909090909091

}

]

[

{

"[KPI_Value]": 0.9215686274509803

}

]

I need to store these values into Excel , which i have done, however, i just need the value storing, not the text. At the moment, i am dropping the value of compose in the excel field.

How can i have so that only the Number Value of the output is stored?

Thanks

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

trice602 15,892 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @dafdsafdsaf ,

You can use this for any of these values, to get the data after ": ",

split(outputs('Compose'), ' ')[sub(length(split(outputs('Compose'), ' ')), 1)]

Was this reply helpful? Yes No
Michael E. Gernaey 53,928 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hello,

In his case since it looks like this

[ { "[KPI_Value]": 0.9215686274509803 } ]

I would do it like this

split(trim(split(string(outputs('Compose')),':')[1]),'}')[0]

Where it first turns it into a string, so it can be split by the :, and then again split by the }
And it only shows the input as the same as the output because the input is based on the code I have so thats expect.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No