Answered

Returning only the text

(1) Share

Report

Posted on by agonsales

I'm building a flow where I want to get the description text from "Describe Image Content" - through using SELECT and JOIN operations to parse the output string I'm left with a string like:

{"text":"a fighter jet flying through a blue sky"}

All I want now is simply: a fighter jet flying through a blue sky

I've tried all sorts of functions, connectors, and odd combinations, but I can't get this result, is there a way to get this string only? And by the way, would be really handy to to skip the SELECT and JOIN steps... but it seems very unlikely

Thanks in advance!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-alzhan-msft on at

Like (2)

Report
Copy link

Link copied!
Hi @agonsales ,

Do you want to get the string a fighter jet flying through a blue sky from string {"text":"a fighter jet flying through a blue sky"}?

If yes, you could refer to my screenhsot below to extract the string:

The expression in the Compose as below:

first(split(last(split(variables('string1'),'"text":"')),'"}'))

The flow would run successfully as below:

Please let me know if your problem could be solved.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Auto-mate 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,
a bit late but may help someone else.
I believe the easier more straight forward solution to your problem would be to switch from "Map to value mode" to "Map to text mode". Simply done by clicking the button in the red circle below. The first part, ie. the field name/Map name (marked with a red X) will then be omitted in the result set.

Regards

Was this reply helpful? Yes No