web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Extracting 8 digit num...
Power Automate
Answered

Extracting 8 digit numbers from JSON (Output from "recognize text in an image or PDF"_

(0) ShareShare
ReportReport
Posted on by dmgc 10

Hi,

 

Apologies if this seems dumb, I can do this in powershell, but have a requirement to use PA instead.

Essentially I have a 2 page PDF as a sample (some PDF will contain more pages, although could be jpg in same format as PDF occasionally) and the pages each have a number at the top that I need to extract from each page. Occasionally a page will not have a number at that top, dont care about these pages! The number will ALWAYS be 8 digits and will ALWAYS be at the absolute top of the page if that helps.

 

I have used "recognize text in an image or pdf document" and that spits out JSON in the below format. (8 digit numbers appear twice on each page, the top number is the easiest as it will always be first on each page)

 

[
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "page": 1,
 "lines@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "lines": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "43431212",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.7324705882352941,
 "top": 0.09742727272727274,
 "width": 0.12194117647058833,
 "height": 0.015645454545454532,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.7324705882352941,
 "y": 0.09742727272727274
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.8544117647058824,
 "y": 0.09742727272727274
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.8544117647058824,
 "y": 0.11307272727272727
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.7324705882352941,
 "y": 0.11307272727272727
 }
 ]
 }
 }
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "I am the first page in the PDF. I am some junk text that I do not need, this",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.19141176470588236,
 "top": 0.2245181818181818,
 "width": 0.6360823529411764,
 "height": 0.014481818181818179,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.19141176470588236,
 "y": 0.2245181818181818
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.8274941176470588,
 "y": 0.2245181818181818
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.8274941176470588,
 "y": 0.239
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.19141176470588236,
 "y": 0.239
 }
 ]
 }
 }
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "can be ignored as it is not part of the process.",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.1905529411764706,
 "top": 0.2461818181818182,
 "width": 0.3952,
 "height": 0.014490909090909082,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.1905529411764706,
 "y": 0.2461818181818182
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.5857529411764706,
 "y": 0.2461818181818182
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.5857529411764706,
 "y": 0.2606727272727273
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.1905529411764706,
 "y": 0.2606727272727273
 }
 ]
 }
 }
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "This is another paragraph of text that can be ignored, it has no benefit",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.1897529411764706,
 "top": 0.2777,
 "width": 0.6111882352941177,
 "height": 0.014481818181818151,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.1897529411764706,
 "y": 0.2777
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.8009411764705883,
 "y": 0.2777
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.8009411764705883,
 "y": 0.29218181818181815
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.1897529411764706,
 "y": 0.29218181818181815
 }
 ]
 }
 }
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "whatsoever.",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.19016470588235296,
 "top": 0.2998909090909091,
 "width": 0.1059176470588235,
 "height": 0.011609090909090902,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.19016470588235296,
 "y": 0.2998909090909091
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.29608235294117646,
 "y": 0.2998909090909091
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.29608235294117646,
 "y": 0.3115
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.19016470588235296,
 "y": 0.3115
 }
 ]
 }
 }
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "43431212",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.23502352941176471,
 "top": 0.7815181818181819,
 "width": 0.12192941176470587,
 "height": 0.015645454545454518,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.23502352941176471,
 "y": 0.7815181818181819
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.3569529411764706,
 "y": 0.7815181818181819
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.3569529411764706,
 "y": 0.7971636363636364
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.23502352941176471,
 "y": 0.7971636363636364
 }
 ]
 }
 }
 }
 ]
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "page": 2,
 "lines@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "lines": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "12341234",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.7343764705882353,
 "top": 0.12379090909090908,
 "width": 0.1208588235294118,
 "height": 0.01564545454545456,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.7343764705882353,
 "y": 0.12379090909090908
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.8552352941176471,
 "y": 0.12379090909090908
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.8552352941176471,
 "y": 0.13943636363636364
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.7343764705882353,
 "y": 0.13943636363636364
 }
 ]
 }
 }
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "I am another page. I am some junk text that I do not need, this can be",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.19141176470588236,
 "top": 0.25125454545454545,
 "width": 0.6053176470588235,
 "height": 0.01441818181818183,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.19141176470588236,
 "y": 0.25125454545454545
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.7967294117647059,
 "y": 0.25125454545454545
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.7967294117647059,
 "y": 0.2656727272727273
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.19141176470588236,
 "y": 0.2656727272727273
 }
 ]
 }
 }
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "ignored as it is not part of the process.",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.19101176470588235,
 "top": 0.27285454545454546,
 "width": 0.3325058823529412,
 "height": 0.014481818181818151,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.19101176470588235,
 "y": 0.27285454545454546
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.5235176470588235,
 "y": 0.27285454545454546
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.5235176470588235,
 "y": 0.2873363636363636
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.19101176470588235,
 "y": 0.2873363636363636
 }
 ]
 }
 }
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "This is another paragraph of text that can be ignored, it has no benefit",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.1897529411764706,
 "top": 0.3045181818181818,
 "width": 0.6111882352941177,
 "height": 0.014481818181818207,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.1897529411764706,
 "y": 0.3045181818181818
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.8009411764705883,
 "y": 0.3045181818181818
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.8009411764705883,
 "y": 0.319
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.1897529411764706,
 "y": 0.319
 }
 ]
 }
 }
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "whatsoever.",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.19016470588235296,
 "top": 0.32655454545454543,
 "width": 0.1059176470588235,
 "height": 0.011609090909090958,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.19016470588235296,
 "y": 0.32655454545454543
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.29608235294117646,
 "y": 0.32655454545454543
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.29608235294117646,
 "y": 0.3381636363636364
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.19016470588235296,
 "y": 0.3381636363636364
 }
 ]
 }
 }
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "text": "12341234",
 "boundingBox": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "left": 0.2369294117647059,
 "top": 0.8081818181818182,
 "width": 0.12085882352941174,
 "height": 0.015645454545454407,
 "polygon": {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "coordinates@odata.type": "#Collection(Microsoft.Dynamics.CRM.crmbaseentity)",
 "coordinates": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.2369294117647059,
 "y": 0.8081818181818182
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.35778823529411763,
 "y": 0.8081818181818182
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.35778823529411763,
 "y": 0.8238272727272726
 },
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.expando",
 "x": 0.2369294117647059,
 "y": 0.8238272727272726
 }
 ]
 }
 }
 }
 ]
 }
]

 

 

Then an apply to each to pick out the extracted text and append it to an array variable.

dmgc_0-1695726693393.png

 

When I compose this, obviously all the text data including the body of the PDF is included in the array.

dmgc_1-1695726834570.png

 

Is there any way to extract or even filter the array to just the first number from each page (hopefully without duplicates)? So it looks like;
[
"43431212",
"12341234"
]

 

Many thanks 🙂

 

 

Categories:
Building flows
I have the same question (0)
  • Expiscornovus Profile Picture
    Expiscornovus 33,828 Most Valuable Professional on at

    Hi @dmgc,

     

    You could use an isInt function to check if the contents of the text property of an item is a number in the lines array.

     

    Try something like below in a Filter Array action

     

    @equals(isInt(item()['text']), true)

     

    isint_lines_textnumber.png

  • Verified answer
    Matthy79 Profile Picture
    Matthy79 4,188 Super User 2024 Season 1 on at

    Hello @dmgc,

     

    Don't use apply to each to extract such data. There are more efficient ways to extract the text from such JSONs. But in your requirement you don't want to extract this information. You only want the first line of each page. This could be done like that:

     

    Matthy79_0-1695735025442.png

     

    So no apply to each and just one action after the ai action. You have to put the result of the ai action at "From". To only get single values (not key value pair) you have to switch to text mode when using the Select action.

     

    Of course you can use expressions to check if the values found fits your requirement (@Expiscornovus provided a sample expression for that).

  • dmgc Profile Picture
    dmgc 10 on at

    Hi,


    Thanks for the suggestion, I have just tried this but I am getting an error where the data in the array is string. Am i missing something silly? 

     

    Thanks!

     

    dmgc_0-1695735712401.png

     

  • Expiscornovus Profile Picture
    Expiscornovus 33,828 Most Valuable Professional on at

    Hi @Matthy79,

     

    In the example payload which was shared page 2 also had a number on the last line item? So, not sure you only want to use the first line item of each item 😅

     

    Btw, if you want to avoid apply to each actions you could also convert the json to xml and use xpath.

  • Matthy79 Profile Picture
    Matthy79 4,188 Super User 2024 Season 1 on at

    Hello @Expiscornovus 

     

    I always use xpath to do that but in that case it is not needed. The requirement is to get the number (it will always be at the top of each page). Using select I have grab all pages and within that I only need the first line. That is why first works for that. The number is also somewhere else in the text but the requirement was also that it shouldn't be more than once so the top position is the best way to find it.

  • Expiscornovus Profile Picture
    Expiscornovus 33,828 Most Valuable Professional on at

    Hi @Matthy79,


    Yes, that is a good point. If the number on one of the other lines on the same page is always the same as the number of the first line there would be no point in using either xpath or filtering each line 👍

  • dmgc Profile Picture
    dmgc 10 on at

    Hi @Matthy79 ,

     

    Thanks for your simple answer, spot on!

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 594

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 281 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans