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
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 tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,606)