Unanswered

Create a separate file while saving attachments

(0) Share

Report

Posted on by AbhijitP

Hello,

I have created a flow which saves a file from a particular mail every day successfully to my share point folder. However, the file is always replaced by the new file ( since all the files coming from this mail have the same name). I want them to be saved with a new file name instead of replacing the old file. e.g. the file come is abc.xls. The flow should save the file which comes the next day by the name abc1.xls and then the next day abc2.xls and so on instead of replacing the first file.

Note: I have already disabled versioning.

can anybody help me!!!

Categories:

Using flows

I have the same question (0)

All responses (11)

Answers (0)

jdoss 458 on at

Like (0)

Report

You can get the number of items in the folder (List Folder SharePoint action), then get the count of them (use compose with expression length([outputs of list folder])) then add that +1 to the file name. So if there are 5 files in the folder the new file would be abc6.xls

Was this reply helpful? Yes No
AbhijitP 10 on at

Like (0)

Report

As I have mentioned, my file comes from the outlook and overwrites the existing file as the attachment in the mail always has the same name. What option should I try so that the file is not overwritten and new file is created with another name. Like abc1.xls and so on.

Was this reply helpful? Yes No
jdoss 458 on at

Like (0)

Report

Well you can use the option I mentioned, or what I typically do is use the guid() function and create a unique code. Just get the file name while parsing and change it and add the guid to the file name. More specifically the substring(guid(), 0, 😎 with the last number being how long you want the id to be. Without seeing that part of your flow it's hard to help.

Was this reply helpful? Yes No
AbhijitP 10 on at

Like (0)

Report

Was this reply helpful? Yes No
jdoss 458 on at

Like (0)

Report

What happens in the condition? Are you saving the file somewhere or just getting the attachment?

Was this reply helpful? Yes No
AbhijitP 10 on at

Like (0)

Report

Was this reply helpful? Yes No
jdoss 458 on at

Like (0)

Report

In that create file function instead of putting attachments name, put whatever you would like, since it is always the same you can use the guid(), see image. If you want to get the filename you can use the compose and a function to get the filename and attach a guid to it.

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @AbhijitP ,

Since you will have the file stored in SP folder everyday (one file for one day I guess), you can also create a variable to store current date as text and format as "yyyyMMdd" and append the date along with the file name, so you could conveniently find the file in other days.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
AbhijitP 10 on at

Like (0)

Report

Where do I put the Initialise variable so that it would be helpful to me??

Was this reply helpful? Yes No
AbhijitP 10 on at

Like (0)

Report

I tried this too but it did not halo the file is still being overwritten.

Was this reply helpful? Yes No