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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Invoice Processing Pre...
Power Automate
Unanswered

Invoice Processing Prebuilt Model (date and amount fields)

(1) ShareShare
ReportReport
Posted on by 169

Hello,

I'm using the Invoice Processing Prebuilt Model with a custom power app and I'm facing the following issues:

- the date and amount fields (text) are accurate most of the time. The respective date (date) fields give null values most of the time (sometimes the amount (amount) fields as well) which causes the following issues:

- I have to do the date conversion myself (from text to date) which is very tricky since the date of the invoices comes in every possible way (12 Feb 21, 12.02.2021, 02/12/21, 2021 Feb 12, etc just to name a few)

- The date metadata (which is the confidence % field) depicts the confidence of the text field, not the confidence of the date one. In my power app, I'm showing the date (date) field with the confidence of the date(text) field which is completely inaccurate (usually the confidence is above 95% while the field is empty!)

Are there any plans of impoving the date/amount fields soon?

Thank you

Categories:
I have the same question (0)
  • JoeF-MSFT Profile Picture
    on at

    Hi @Iro_,

     

    Thanks for the question!

     

    From which regions are your invoices?

     

    Currently the invoice processing prebuilt model officially only supports English invoices from the US, which might explain why dates not in US format are not being converted properly. 

     

    On the first half of 2022 we will be adding support to invoices from some European markets, so that will improve date conversions. 

     

    Thank you again for sharing this feedback. 

  • Community Power Platform Member Profile Picture
    on at

    Hi Joe,

     

    I'm from Australia and experiencing the same date formatting issue. Are you able to advise if the invoice support has been released, and if it's available down here? I was hoping I could just change a regional setting.

     

    Cheers

  • JoeF-MSFT Profile Picture
    on at

    Hi @Anonymous - thanks for the question. We're hearing more and more asks for support for invoices from Australia. It's unfortunately not yet available, but we have it planned in our roadmap for beginning of 2023.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard