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 Apps / Finding number datatyp...
Power Apps
Unanswered

Finding number datatype invoice elements from ai builder

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi, 

I have trained a custom model with invoices using the AI builder. Then I wanted to use the model in power app. I was able to find all the string type values (attached screenshot) but I was not able to get the number datatype values to show in the power app. Where do I find the default number datatype invoice elements like invoiceTotal or subTotal?

Asadman_0-1688782088978.png

Thank you.

Categories:
I have the same question (0)
  • plarrue Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Thanks for reaching out. Have you tried this? FormProcessor1.Fields.'invoiceTotal' to retrieve the details of the extracted form field "invoiceTotal".

     

    Hope it helps.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I tried doing this and it does not work either. The error says that 'invoiceTotal' isn't recognized.

    Asadman_0-1688874613639.png

    Thank you.

  • plarrue Profile Picture
    Microsoft Employee on at

    In the Choose information to extract, do the invoiceTotal and subTotal data come from a Table or a Field?

    Thanks,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    They come from a Field. So, I have trained my model and these (screenshot below) are the elements that I want to extract. But I can only find the string datatype elements when I use this model in power app. Except paymentTerms and purchaseOrder, all the other fields are number datatype and I cannot find them in the power app. 

    Asadman_0-1688940405340.png

    Thank you.

  • plarrue Profile Picture
    Microsoft Employee on at

    Hi @Anonymous 

     

    We have discovered an issue on our end. I will ensure to keep you informed about the resolution as soon as possible. Thank you for your patience.

    Regards,

     

  • plarrue Profile Picture
    Microsoft Employee on at

    Hi @Anonymous 

     

    The ongoing solution is being implemented and is expected to be released on Tuesday 8th of August.
    I invite you to try again on that date.
    Sorry for the inconvenience and thank you for your patience.
    Regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you for letting me know!

  • plarrue Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    This number type field issue has been fixed, Can you please confirm that you are no longer encountering this problem in PowerApps?

     

    Thanks,

    Regards.

  • plarrue Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Document processing field types is now GA and brings several benefits.
    It allows for the extraction of fields with specific types and formats, such as a number, date, checkbox, table, or text field.

    https://learn.microsoft.com/ai-builder/extract-dates-and-numbers


    https://powerautomate.microsoft.com/blog/custom-processing-for-invoice-and-document-field-types-generally-available/

     

    Regards,

    Philippe

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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard