Unanswered

Only text fields in document processing?

(0) Share

Report

Posted on by vmatkus

How does document processing models have only text fields? Why it is not possible to choose numerical or dates? AI should be capable to detect comma after some number and understand that i do not need it. Or plainly ignore space in amounts, and find dates that may be a bit in different format in invoices. Now document processing is not AI model, but more OCR document recognition with a bit of guessing where the data is for same format of documents...

Categories:

AI Builder

I have the same question (0)

All responses (4)

Answers (0)

CedrickB Moderator on at

Like (1)

Report

We are working to enable support of date and numerical fields.

This should be available before Microsoft build this year.

In the meantime, post processing in Power Automate performing the conversion is the way to go.

Was this reply helpful? Yes No
sossie07 79 on at

Like (0)

Report

vmatkus, I have struggled with similar issues. I think MS must have a very imaginative marketing department. Its not AI, its OCR. Best I could do was in fields where I expected only numbers I could go through and remove any incorrect characters - e.g. the following replaces letter O with 0, and removes spaces: replace(replace(xxxx,'O','0'),' ','')

It can be done with a heap of nested replace() functions, or there are some articles on how to do it in a big loop if you have a lot of invalid chars, but that is also a horrible mess of programming.

Was this reply helpful? Yes No
vmatkus 17 on at

Like (0)

Report
From today field types should be available. I do not see it or do not understand how it should work? I should choose what type of field i want? WHere?...
I found a list of available types here Microsoft Release planner (dynamics.com)
Text
Text with no spaces
Text (alphanumeric)
Number
Currency
Date

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

@vmatkus @sossie07

You could try this template that creates a text replica of a given file & passes it to GPT where you can customize most things directly in the prompt:

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Extract-Data-From-PDFs-and-Images-With-GPT/td-p/2201345

Was this reply helpful? Yes No