Answered

Extracting a text value from an embedded string value (OCR via attachment)

(0) Share

Report

Posted on by Community Power Pla...

Hi guys,

This would be my first post here and one issue has me scratching and pulling all nighters. Its addictive!..

Here are my pics.

I have an email attachment for a pdf which is first fed into a variable (string type)

Then conditioned.

and finally passed trough AI for image recognition.

The value is then embedded into a string variable.

However now I simply need to get the Text value from here in the above [0] string. It is not an array so I cannot pass it though filter array function. Tried many alternatives with split() function and item()? type as well but of no use.

From a total of 1200 lines I need to only filter those starting with "text:" values and then append them as an array into a sharepoint file. Just..that..simple 😕

Would be really grateful if some of the experts here can shed some light on to it. Eagerly awaiting your replies!

Categories:

Using flows

I have the same question (0)

All responses (38)

Answers (1)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous

Once you got the output from AI as the output data for pdf file,

Next step you can parse the json string obtained to Parse json action.

Next use the output from parse json and pass it to Select action, here specify value section as the output from parse json and select the highlighted option

Then after that in the same field specify item()?['text']

Output from select action would array having only text values 🙂

Hope it helps 🙂
Mark it as solution if it resolves your query 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Nived_Nambiar thank you for your reply. Would really appreciate if you can guide me on how to parse json in this case (a total newbie here unfortunately!)...Thanks a lot!

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous

Refer this video
https://youtu.be/e0dzMqoJGtY

What you have to do is the output which you are getting in form of json you have to pass into Content Field
In schema section, click Generate from sample and then paste the same json structure which would generate schema from sample.

Hope it helps !
Mark it as solution if this resolved your query

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Nived_Nambiar

How do I get a JSON output here that can be sent to JSON parser. (The one im sending as an input is generating null values)

I have this as an out of the appended variable output

On expanding the output it gives all in row, which is not what is perhaps required in the schema for parsing json?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

as per the video, do I need to create another variable and place the previous appended string values of 'PDF_Content' into it before parsing?

Was this reply helpful? Yes No
Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

No, currently which dynamic content is giving the required value, place that in Content section of parse json, then if you have same json content with you [ may you can do a run and using compose function you can capture the json data] , you can generate schema from it 🙂

Video is just giving an idea on how to work with that 🙂

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Nived_Nambiar getting the below error here

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Could you show me the flow (without running )?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Here is the flow without running

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Anonymous

See this

Next to Recognize text in pdf or image document, place the parse json action, in the content, place the results instead of PDF_content.

Also make sure schema matches that of result dynamic content 🙂

Let me know if it works 🙂

Was this reply helpful? Yes No