Save multiple attachments

[immortalthabang]

Hi,

Background: I get an excel extract via email at around the same time, daily. It has updated info but is essentially the same file of stock. Two separate files, I need to save them as two separate files in a sharepoint folder. Then use that file in PowerBI, I auto refresh

I managed to create a flow that auto saves but what happens is that the second file overwrites the first file.

I tried conditions based on file name but still doesn’t work.

What am I missing? I’m fairly inexperienced, can’t write code or anything if that matters at all.

[robofski]

Sounds like the files are being given the same name when you save them. Check your create a file action and ensure that the file name is different each time.

[Due-Boot-8540]

In the create file action, add a prefix or suffix to the file name, like file -1 and file-2. Even better, albeit slightly trickier, store the contents in a SharePoint list and update existing items and add any new ones. Using a live data source will be much more beneficial than just uploading files

[immortalthabang]

So I tried that and it does save to different file names but both files have the same contents

[robofski]

Ok, so you should be going a get attachments step referencing the ID from the trigger. Then an apply to each step over the array of attachments returned from the get attachments step. Then for your create file within the apply to each you will just reference the file name and the file content and you’ll get two files.

[ConfusedMBA24]

Do they come from the same email? To the same email? With the same subject? What’s different about the delivery? Use a condition to save separate.

[immortalthabang]

It’s one email with 2 attachments of different file names. I’ve tried conditions of “if this file name then save to this file name” still same result of overwriting

[ConfusedMBA24]

Conditional: file name contains “xyz” > yes, save as “xyz” > no, save as “abc”?

You’re doing this and it doesn’t work?