File rename with 01,02,03....10,11,12 possible? (Not 1,2,3....)

(0) Share

Report

Posted on by Glueck

112

Hi guys.

We are supposed to rename multiple files with

#vendor code_vendor name_ddMMyy_01

#vendor code_vendor name_ddMMyy_02

#vendor code_vendor name_ddMMyy_03

Is it possible to rename with 01,02,03...10,11,12...?

In my Desktop flow

1.Change a file name to "_number"

2.Add ddMMyy

3.Add #vendor code_vendor name_

file rename.jpg file rename2.jpg

But I can't find any idea to change 01,02,03....

Categories:

Power Automate Desktop

I have the same question (0)

All responses (11)

Answers (1)

Sort by

ryule 929 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

This code takes the files in the folder and renames them all with the date and adds the 0 in front of the number if necessary. I'm not sure how you are pulling vendor code and name, but you could easily throw those into this as well.

Folder.GetFiles Folder: $'''\\\\server\\genactg\\SHARED\\RPA\\TEST''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files
DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDateTime
Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CurrentDateTime CustomFormat: $'''_ddMMyy''' Result=> FormattedDateTime
LOOP FOREACH CurrentItem IN Files
Variables.ClearList List: Positions
File.GetPathPart File: CurrentItem.FullName FileNameWithoutExtension=> FileNameNoExtension
Text.ParseText.Parse Text: FileNameNoExtension TextToFind: $'''_''' StartingPosition: 0 IgnoreCase: False OccurrencePositions=> Positions
LOOP FOREACH CurrentItem2 IN Positions
SET LastUnderscore TO CurrentItem2
END
Variables.IncreaseVariable Value: LastUnderscore IncrementValue: 1
Text.GetSubtext.GetSubtextFromStartTo Text: FileNameNoExtension NumberOfChars: LastUnderscore Subtext=> StartofFileName
Text.GetSubtext.GetSubtextFrom Text: FileNameNoExtension CharacterPosition: LastUnderscore Subtext=> Subtext
IF Subtext < 10 THEN
SET Number TO $'''0%Subtext%'''
ELSE
SET Number TO Subtext
END
SET NewFileName TO $'''%StartofFileName%%FormattedDateTime%_%Number%'''
File.RenameFiles.Rename Files: CurrentItem.FullName NewName: NewFileName KeepExtension: True IfFileExists: File.IfExists.Overwrite RenamedFiles=> RenamedFiles
END

Was this reply helpful? Yes No
Pavel_NaNoi 1,074 on at

Like
a
(1)

Report
Copy link

Link copied!

Shouldn't be an issue, as long as the number is in a string format, you'd be able to rename it using the Rename File action as 01,02,03,04, etc.

To get a number that increments like that just do the following:
-Set variable to 1 and name it something, in this case I'll name it "OriginalNumber" for clarity
-Put in an IF Statement that asks if %OriginalNumber% is < 10
If so then:
-Set variable to 0%OriginalNumber% and name it something, in my case "NumberToWrite"
-Increase variable %OriginalNumber% by 1 via "Increase Variable" action
Else:
-Set Variable %OriginalNumber% to %NumberToWrite%
-Increase variable %OriginalNumber% by 1
IF END
Now just write your number as you'd like.
Here's an example of what the flow I've written above would look like in PAD:

Was this reply helpful? Yes No
Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Here is a sample flow:

Copy and Paste

Folder.GetFiles Folder: $'''D:\\SampleFiles''' FileFilter: $'''*.pdf''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files LOOP FOREACH CurrentItem IN Files Text.SplitText.SplitWithDelimiter Text: CurrentItem.NameWithoutExtension CustomDelimiter: $'''_''' IsRegEx: False Result=> TextList Text.Pad Text: TextList[3] PadPosition: Text.PadPosition.Left PaddingText: 0 TotalLength: 2 PaddedText=> PaddedText File.RenameFiles.Rename Files: CurrentItem.FullName NewName: TextList[0] + '_' + TextList[1] + '_' + TextList[2] + '_' + PaddedText KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles END

Regards

Kaif

Was this reply helpful? Yes No
Glueck 112 on at

Like
a
(1)

Report
Copy link

Link copied!

Dear @ryule, @Pavel_NaNoi, @Kaif_Siddique
Thank you very much for your help!!!
I will try your advice and will provide the feedback😉

Was this reply helpful? Yes No
Glueck 112 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ryule , since I would like to learn more about PAD, I am trying each advice. For your advice, I tried the same, but got some error.
For instance, For #8 "For each", I got the error msg "Positions should be list, database or datarow".
Before #8, I set each action as below. Please let me know if I am wrong.

Was this reply helpful? Yes No
ryule 929 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Disable this "First occurrence only" option

Also, this should just be %CurrentItem.FullName%

Was this reply helpful? Yes No
Glueck 112 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ryule , thank you for taking your time to check my error.
I amended, but I got the error next for #11. The error msg is "The value should be a number ".
Is there anything wrong for my setting? Sorry lots of questions...

Was this reply helpful? Yes No
Verified answer

momlo 1,527 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Glueck / All,

I scanned the thread and I would suggest simple solution using "PAD Text" action.

No IFs or any custom logic required:

Folder.GetFiles Folder: $'''C:\\TEST''' FileFilter: $'''*''' IncludeSubfolders: False FailOnAccessDenied: True SortBy1: Folder.SortBy.NoSort SortDescending1: False SortBy2: Folder.SortBy.NoSort SortDescending2: False SortBy3: Folder.SortBy.NoSort SortDescending3: False Files=> Files DateTime.GetCurrentDateTime.Local DateTimeFormat: DateTime.DateTimeFormat.DateAndTime CurrentDateTime=> CurrentDateTime Text.ConvertDateTimeToText.FromCustomDateTime DateTime: CurrentDateTime CustomFormat: $'''ddMMyy''' Result=> date SET counter TO 1 LOOP FOREACH CurrentItem IN Files Text.Pad Text: counter PadPosition: Text.PadPosition.Left PaddingText: 0 TotalLength: 2 PaddedText=> number File.RenameFiles.Rename Files: CurrentItem NewName: $'''vendorname_%date%_%Number%''' KeepExtension: True IfFileExists: File.IfExists.DoNothing RenamedFiles=> RenamedFiles Variables.IncreaseVariable Value: counter IncrementValue: 1 END

Was this reply helpful? Yes No
Glueck 112 on at

Like
a
(0)

Report
Copy link

Link copied!

@momlo
Thank you very much for your advice. Finally this works!!!
This is simple and it was helpful😃
Result

Was this reply helpful? Yes No
Glueck 112 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear @ryule, @Kaif_Siddique , @Pavel_NaNoi

I tried each advice of yours, unfortunately it was not working(and because of my language issue😣).
But I really appreciate your kind advice. Thank you very much.
Test each advice

Was this reply helpful? Yes No