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

Community site session details

Session Id :
Power Apps - AI Builder
Answered

Zero's are being dropped of extracted values..

(0) ShareShare
ReportReport
Posted on by 65

So I have an issue where some of the validation expressions I am using fail as a result of the AI Builder saving values and dropping off any zero's that are on the end of a number. Any suggestions?

 

As you can see from the attachments, when in the AI Builder module, it recognizes the number with a zero, but in the automate extraction, the number value is being saved without a zero if that is the correct number.

Categories:
I have the same question (0)
  • Verified answer
    jk_one Profile Picture
    Moderator on at
    Re: Zero's are being dropped of extracted values..

    Hello!

    You can use the Use format data by examples to change the format of data with Power Automate - Power Automate | Microsoft Learn to change the display/format of data in Power Automate.

    Here, you would use something like formatNumber(float(outputs('Extract_information_from_invoices')?['body/responsev2/predictionOutput/result/fields/subTotal/valueNumber']), '0.00')

    hope that helps,
    JK

  • TheAvo1 Profile Picture
    65 on at
    Re: Zero's are being dropped of extracted values..

    Thanks JK, works a charm!

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 714 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 243

Last 30 days Overall leaderboard