Answered

Get values as number from a form

(0) Share

Report

Posted on by Community Power Pla...

Hello everybody!

I've been working on a project using a form processing AI model to extract values from invoices, and uses them to fill in a sharepoint database via Power Automate.

I noticed the AI formats all extracted camps as Text, but some of the camps represent numbers (i.e. 1,000.00) and the sharepoint list column where these values are input doesn't allow text.

Is there any way to tell the AI which camps are numbers, or any way to convert these values to numbers without manual intervention?

Thanks in advance!

Categories:

AI Builder

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

JoeF-MSFT on at

Like (2)

Report

Hi @Anonymous,

Thank you for the question. Indeed today the AI Builder Form Processing model extracts fields as text. To convert them to numbers, you can use expressions in your flow in Power Automate. The following link will show you how to do it: https://docs.microsoft.com/en-us/ai-builder/form-processing-model-in-flow#convert-a-form-processing-output-string-to-a-number-in-power-automate

In a future update of AI Builder Form Processing, we will allow defining the type of a field (text, number, date...).

Also, have you tried our AI Builder Invoice Processing prebuilt model? It extracts the most common fields found on invoices without having to train a model. This model returns numerical fields in a number format.

I hope this helps! Let us know if you have further questions.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks! can you tell me which connector is that one under the AI builder one? i can't seem to find it anywhere.

Was this reply helpful? Yes No
JoeF-MSFT on at

Like (1)

Report

Hi @Anonymous,

It's the Dataverse connector, but it's just an example. You don't need to use the Dataverse connector. Just use the float() or int() expression as shown in the animation, in the SharePoint action for the inputs where you need a number value.

Was this reply helpful? Yes No