@rrahat93
Please find the below approach:
Code:
Folder.GetFiles Folder: $'''D:\\pdf''' 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
SET DTgroupedFiles TO { ^['FirstFiveDigits', 'FilePath'] }
Scripting.RunDotNetScript Imports: $'''System
System.Data
System.IO
System.Linq''' Language: System.DotNetActionLanguageType.CSharp Script: $'''DataTable dt = new DataTable();
dt.Columns.Add(\"FirstFiveDigits\", typeof(string));
dt.Columns.Add(\"FilePath\", typeof(string));
foreach (string file in files)
{
string fileName = Path.GetFileNameWithoutExtension(file);
string firstFiveDigits = fileName.Substring(0, 5);
dt.Rows.Add(firstFiveDigits, file);
}
string currentGroup = null;
string filePaths = null;
foreach (DataRow row in dt.Rows)
{
string firstFiveDigits = row[\"FirstFiveDigits\"].ToString();
string filePath = row[\"FilePath\"].ToString();
if (currentGroup == null || currentGroup != firstFiveDigits)
{
if (currentGroup != null)
{
groupedFiles.Rows.Add(currentGroup, filePaths);
}
currentGroup = firstFiveDigits;
filePaths = filePath;
}
else
{
filePaths += \",\" + filePath;
}
}
if (currentGroup != null)
{
groupedFiles.Rows.Add(currentGroup, filePaths);
}''' @'name:files': Files @'type:files': $'''List''' @'direction:files': $'''In''' @'name:groupedFiles': DTgroupedFiles @'type:groupedFiles': $'''Datatable''' @'direction:groupedFiles': $'''InOut''' @groupedFiles=> DTgroupedFiles
LOOP FOREACH CurrentItem IN DTgroupedFiles
Text.SplitText.SplitWithDelimiter Text: CurrentItem['FilePath'] CustomDelimiter: $''',''' IsRegEx: False Result=> FileList
IF FileList.Count > 1 THEN
Pdf.MergeFiles PDFFiles: FileList MergedPDFPath: $'''D:\\pdf\\%CurrentItem[0]%.pdf''' IfFileExists: Pdf.IfFileExists.AddSequentialSuffix PasswordDelimiter: $''',''' MergedPDF=> MergedPDF
END
END
Just copy and paste the above code into you new flow power automate desktop and change your folder name path.
Thanks,
Deenuji Loganathan 👩💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥
-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀
