Saving File with different name if the file name already exist?

Help Something Else
38

Hi @kumar.varun2

You can try this assign activitiy around

file_name= If(Directory.GetFiles(folderpath).Where(Function(file) Path.GetFileName(file).ToString.Contains(Now.ToString(“yyyyMMdd”))).Count=0, Now.ToString(“yyyyMMdd”), Now.ToString(“yyyyMMdd”)+“_”+ Directory.GetFiles(folderpath).Where(Function(file) Path.GetFileName(file).ToString.Contains(Now.ToString(“yyyyMMdd”))).Count.ToString)+“.xlsx”

This will give u the file name too

But if it is complex in way if understanding, then u can normal flow approach as I suggested before

5 Likes