cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alidh36
Regular Visitor

How can i rename with files with invoice No. after extraction my invoice No. from the same file (using AI builder) and saving the invoice number in excel sheet?

Hi, the flow an trying to do is to add my invoices to OneDrive document, then the flow will extract the invoice number from the file (PDF files) which is did and saved it to an excel sheet, then i want the flow to rename the file with the invoice number inside it (but using AI builder its saved in an excel sheet with the invoice number and the original file name in the same row in excel). 

 

Below, you can view the flow that have tried to do, but it give me an error. the Idea i have is the flow find the file in column 1 in excel then changer the name of the file by the invoice No. in excel. Also is it best to use desktop flow or build in model as below? 4.PNG

 

3.PNGflow.PNGflow2.PNG 

1 REPLY 1
Expiscornovus
Dual Super User
Dual Super User

Hi @alidh36,

 

The Files array (which you got from Get files in folder) should store the names/locations of the files. So, I would expect that you can just point to the CurrentItem for the File to be renamed. 

 

In the text to add field you can add your own variables like TheNameOfFile. Can you test it with the %CurrentItem% variable in the loop?

 

currentitemvariable.png

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Users online (2,043)