Skip to main content

Notifications

Power Automate - General Discussion
Answered

Returning only the text

(1) ShareShare
ReportReport
Posted on by 5

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"}

 

Flow.png

 

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 Smiley LOL
 
Thanks in advance!
  • Auto-mate Profile Picture
    Auto-mate 2 on at
    Re: Returning only the text

    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.

    Automate_0-1688828741263.png

    Regards

  • Verified answer
    Re: Returning only the text

    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:

    1.png

    The expression in the Compose as below:

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

    The flow would run successfully as below:

    2.png

     

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard