web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Compose action to remo...

Power Automate

Unanswered

Compose action to remove Text and only store number value

(1) Share

Report

Report

Posted on by dafdsafdsaf

Hello.

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

1.

[

{

"[KPI]": 0.9333333333333333

}

]

2.

[

{

"[KPI Delivery Value]": 0.9090909090909091

}

]

3.

[

{

"[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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

trice602 15,927 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,932 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

Join the conversation