Announcements
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...
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.
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.
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)
@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
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 392 Most Valuable Professional
11manish 136 Super User 2026 Season 2
MS.Ragavendar 109 Super User 2026 Season 2
