Effortlessly Create a Bill Invoice in Excel for Administration

Bill invoice in excel for Administration

hey everyone let's take a look at how we can automate copying data from invoices into Excel using AI Builder we'll start by creating a new Excel file in our one drive for business we'll Define a few columns here like invoice ID vendor due date and total amount and then we'll make that into a table now we'll log into powermate.com with our work or school account then we'll go to the AI Builder tab in the explore section for our use case we'll select the extract information from invoices option and we'll upload a sample invoice to try it out looks like it extracted all that information from our invoice so let's test it out in a power automate flow we'll create a new flow using this template and at the end of the flow we're going to add a new action using the Excel connector to add a row into a table we're going to select the Excel file that we created at the beginning and we'll point it to the document library that it's located in find the file and then finally point it to that table that we created now all that's left to do is to map the information that was extracted by the AI Builder model into each column of the table and that's all we need to do to configure the flow now it's ready for action now let's select save and we'll test and pick one of the invoices and there you have it the flow runs extracts the data from the invoice using AI Builder and sends me an email summary of the extracted data and the information is added to Excel and the best part is it it only took us a minute to configure