Unanswered

Zero's are being dropped of extracted values..

(0) Share

Report

Posted on by TheAvo1

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:

AI Builder

Extracted values ...

Extracted Values ...

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

jk_one Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
TheAvo1 65 on at

Like (0)

Report

Re: Zero's are being dropped of extracted values..

Thanks JK, works a charm!

Was this reply helpful? Yes No