Unanswered

Incremental rename files

(0) Share

Report

Posted on by joaoseabra

Hi the community,

I am trying to build a flow, so when I scan an invoice (in de onedrive app) that Power Automate renames the file based on the previous one.

For example: latest created, is named 'ACH 230057', it must name the new scanned file 'ACH 230058' and so on..

Thanks in advance!

Best

Joao

Categories:

Building flows

flow print.pdf

I have the same question (0)

All responses (5)

Answers (0)

Unknown geen idee 1,757 on at

Like (0)

Report
Dear joaoseabra,

This should be relatively simple, provided your files always have the same name structure.
Suggest you include the following steps in your flow:
Create variable "HighestNumber".
Get all the files in the folder.
Within an 'Apply to all' loop:
Use compose action with split() to split the file names and get just the number.
Create condition to save the output number from the compose action only if it is higher than the current variable number.
Save the number as variable "HighestNumber".
At the end of the loop the variable "HighestNumber" will have the highest number of the file names.
Use a compose to do "HighestNumber" + 1 and use this output in the filename.
Save the file.

Hope this helps,
Happy flowing,
Koen

Was this reply helpful? Yes No
joaoseabra 4 on at

Like (0)

Report

Hi Koen,

Did not have time yet to check this out. Will check your steps tomorrow and let you know if it works.

Best,
Joao

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

@joaoseabra Will the flow be triggered when you create a new file in your folder (need to rename the file that was created), or do you create the file within the flow itself (set the name when you create the file)?

Was this reply helpful? Yes No
joaoseabra 4 on at

Like (0)

Report

@grantjenkins Hi grantjenkins, flow needs to triggered when I scan an invoice, file is then created in onedrive (pdf) with name 'scan - XXXX' - see example attached.

scanning with one...

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

@joaoseabra Sorry for not getting back to you earlier. Do you still need help with this flow? If so, then I can see what I can do for you tomorrow.

Was this reply helpful? Yes No