Power Automate

Grab information from a concat

(0) Share

Report

Posted on by Keavie

Hi All,

I want to get specific information from this line that I have concatted from a variable.

I want to get the information that is highlighted in this compose.

I have tried to split it but it doesn't seem to work.

Any assistance would be appreciated

[{"goods_id":"1305503d1b9252100a81848cd34bcba5","goods_description":"Bathroom Accessories Mirrors","package_marks":"ADDR"},{"goods_id":"6b05503d1b9252100a81848cd34bcbbf","goods_description":"Bathroom Accessories Mirrors","package_marks":"ADDR"}]

Thank you

Keavie

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Pacel1 79 on at

Like (0)

Report
Copy link

Link copied!
You can use "Parse JSON" action and use belowed code in schema

{ "type": "array", "items": { "type": "object", "properties": { "goods_id": { "type": "string" }, "goods_description": { "type": "string" }, "package_marks": { "type": "string" } } } }

After this You will be able to use goods_id property in next steps, for example select action :)

Was this reply helpful? Yes No
Keavie 20 on at

Like (0)

Report
Copy link

Link copied!

Hi Pacel1

I have tried this however it errors out when trying to do the Parse JSON,

Was this reply helpful? Yes No
Chriddle 8,638 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

outputs('Compose')[0].goods_id

Was this reply helpful? Yes No
Pacel1 79 on at

Like (0)

Report
Copy link

Link copied!

Are You sure, You used my shema? In Your screen i can see that You used „Object” property, in my schema i used „Array”. Please check that again :)

Was this reply helpful? Yes No
Keavie 20 on at

Like (0)

Report
Copy link

Link copied!

I did try this and it only pulled through the first enter from the JSON. I need to get all the goods ID's as we can have up to 30 in this lookup.

I am doing a HTTP GET to get the Goods ID therefore when trying to Parse JSON it is failing when trying to do it as an Array.

Was this reply helpful? Yes No
Pacel1 79 on at

Like (0)

Report
Copy link

Link copied!

So try in different way :)

1. copy body outputs of your http request from your previous tests

2. go to edit flow

3. in parse json click generate from sample

4. paste in new window body of http request

5. click generate

6. test it again

Was this reply helpful? Yes No