
Hi all,
Looking for some help regarding customisation with the AI Builder invoice processing. Is it possible to bring in fields from another source like SQL table to populate fields not on an invoice if it recognises an account number on a invoice?
Thanks
Hi @GlitchedDuck - good use case!
Yes, you can do this in a cloud flow in Power Automate by using the SQL Server connector. After the step to 'extract information from invoices' add the action to 'Get row' where you can query your table by the account number extracted by 'Extract information from invoices' step. Then you can use the results from the AI Builder model and the SQL database in the successive steps of the flow.
I hope this helps! 🙂