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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Azure form recognizer ...
Power Automate
Answered

Azure form recognizer output to get invoice line items

(0) ShareShare
ReportReport
Posted on by 10

Hi All,

I am sending some invoices in pdf format to azure form recognizer from power automate. I am getting the JSON output that is way complex.

I want to get all the line item details such as the description,amount, quantity, unit price etc  from the JSON output but so far i am able to get only the first line item.

 

Please help me out in this. 

I am using the parse json object and after that in the select action i am using this expression (

item()?['fields']?['items']?['valueArray'][0]['valueObject']['Description']['content']

)

as this code returns only the first item description is there a way to get all the available descriptions in the available JSON

 

I am attaching the JSON output in here so you can check.

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Ratnesh_Chitko ,

     

    I managed to parse the JSON and get what you need, please refer to below screenshots:

    vjefferni_0-1699005182138.png

     

    Result:

    vjefferni_1-1699005228479.png

     

    expression for From of Select:

    json(YourJsonString)['analyzeResult']['documents'][0]['fields']['items']['valueArray']

    field values in Select:

    @item()['valueObject']['description']['content']
    @item()['valueObject']['amount']['content']
    @item()['valueObject']['quantity']['content']

    etc.

     

    Best regards,

  • Ratnesh_Chitko Profile Picture
    10 on at

    Hi @v-jefferni ,

    Can you please post the whole flow so i can uinderstand it completely

  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Ratnesh_Chitko ,

     

    I just initialized a sting variable to hold the JSON of yours and use these two actions to parse and get values.

    vjefferni_0-1699236256908.png

     

    Best regards,

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

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!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 62 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 58

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard