Move and rename multiple attachments from SharePoint list item

(0) Share

Report

Posted on by i_reminisce

Hello everyone!

I looked around and didn't find anything that quite fit my specific issue.

Let me describe how my Flow works to give you guys a better understanding. My Flow starts by waiting for a SharePoint item to be created (data patched from PowerApps), and then essentially uses that data to do various things.

One of these things that I want to do is to be able to take the attachments submitted, and then move them to a different SharePoint site (xxx.sharepoint.com/sites/a ----> xxx.sharepoint.com/sites/b). I've been able to do this with no issues, but then a user brought something to my attention.

I've been renaming the file as I move it across, but users want to be able to submit more than one item at a time in my PowerApp. The items get renamed (via Flow) the same thing and all overwrite each other ending with one file.

Is there a way to add in a sequential format of some sort? I'm hoping to be able to rename multiple files to be something like "Timecard-i_reminisce-Date-sequentialFormat". Thanks!

All responses (13)

Answers (1)

i_reminisce 79 on at

Like (1)

Report

Re: Move and rename multiple attachments from SharePoint list item

@PytByt

We've all got to start somewhere! I'm happy my meager knowledge could help you out 🙂
PytByt 943 on at

Like (0)

Report

Re: Move and rename multiple attachments from SharePoint list item

hi @i_reminisce

wow! you are a life saver mate! thanks a lot!

and i hope you did enjoy your holiday...

cheers,
pytbyt
i_reminisce 79 on at

Like (2)

Report
Re: Move and rename multiple attachments from SharePoint list item

@PytByt , apologies for my late reply, was enjoying my holiday :). Here are my responses:

I need to make sure what exactly inside the "Get Attachment Content" is in the flow?
The "Id" is set to the ID of the "When an item is created", and the "File Identifier" is set to the Id of "Get attachments"
Is it possible to rename the whole attachment name?for example:The actual uploade name of the attachment is: newpic.jpg and then change it with flow into: 10 - Copy ID Card.jpg (where 10 is the ID from ID column of my SP list)how can i achieve that?
To do this you would have to do something like:
Run a condition against the name of the original attachment and if it matches the file TYPE (ex. jpg, doc, or pdf), to rename it appropriately...
The way I would do this is with split() expressions in multiple conditions, pictures below for example
How can i use the flow? i mean, i already created it and make it running but, i dont see the result and i dont know how to add it into my app in powerapss. Please help.
When you have a flow that is made of a trigger involving an item being created in a SharePoint list, then you're done... If you have PowerApps submitting data to the same SharePoint list then all you need to do is sit back and wait for the Flow to run when the new item gets created in Sharepoint. If you are NOT creating new items on Sharepoint, but instead modifying existing items, then you need to change the flow trigger (When an item is created) to the SharePoint trigger (When an item is created or modified).

If you need more details then what I've provided please let me know, but understand that I may not be as quick to respond as things are picking back up at work.

Picture examples of Question #2:
The concat expression is:
concat(triggerBody()?['ID'], ' - ', 'Copy ID Card', '.jpg')
The last expression is:
last(split(items('Apply_to_each')?['DisplayName'], '.'))

Here is the flow run demonstrating the rename of the file:
It may be a bit hard to tell, but the file was uploaded to SharePoint as "FlowTest2.jpg", and then was renamed to "3 - Copy ID Card.jpg" after the Flow run completed.
PytByt 943 on at

Like (0)

Report
Re: Move and rename multiple attachments from SharePoint list item

Hi @i_reminisce

Im sorry for my late reply..

i have a few question:
I need to make sure what exactly inside the "Get Attachment Content" is in the flow?
Is it possible to rename the whole attachment name?for example:The actual uploade name of the attachment is: newpic.jpg and then change it with flow into: 10 - Copy ID Card.jpg (where 10 is the ID from ID column of my SP list)how can i achieve that?
How can i use the flow? i mean, i already created it and make it running but, i dont see the result and i dont know how to add it into my app in powerapss. Please help.

Thanks.

Regards,
PytByt
i_reminisce 79 on at

Like (1)

Report
Re: Move and rename multiple attachments from SharePoint list item

@PytByt

This worked for me, let me know if you need explanations as to what is going on in the flow.

The concat formula is
concat(triggerBody()?['ID'], ' - ', items('Apply_to_each')?['DisplayName'])

Here's a picture of the attachments after they've been renamed (couldn't get it to work with .doc, but I didn't spend any time on troubleshooting why... SharePoint was being fussy about uploading one)
PytByt 943 on at

Like (0)

Report

Re: Move and rename multiple attachments from SharePoint list item

Hi @i_reminisce , thank for your reply.
Yes, i'm using powerapps with submitform formula for submitting the the whole form including the multiple attachments into my sharepoint list table.

Please help me.

Best Regards,
PytByt
i_reminisce 79 on at

Like (1)

Report

Re: Move and rename multiple attachments from SharePoint list item

Hey there @PytByt !

I can give it a shot, but I need to know how you're submitting the pictures to Sharepoint. Are you doing it through PowerApps?
PytByt 943 on at

Like (0)

Report

Re: Move and rename multiple attachments from SharePoint list item

Hi @i_reminisce

can you help me creating a flow that automatically renaming the file attachment that i uploaded into a sharepoint list?

i need to upload multiple atatchments at once for a single record in a sharepoint list, and i need to renaming it all by adding the record ID Column at the front. for example:

ID: 10

Attachments:
A.jpg
b.pdf
C.doc

Rename it so it will be:
10 - A.jpg
10 - b.pdf
10 - C.doc

how i can achieve that? please help.

much thanks,
pytbyt
i_reminisce 79 on at

Like (0)

Report

Re: Move and rename multiple attachments from SharePoint list item

I figured it out, I just did a CountRows() of the attachments in my PowerApp and submitted that back to SharePoint and used that number in a condition in Flow.

Thanks again for all of the help @SCTdan, I really appreciate it!
i_reminisce 79 on at

Like (0)

Report

Re: Move and rename multiple attachments from SharePoint list item

The increment variable will definitely be good enough for now, thanks for that!

Now you have me interested in knowing how to add in that logic you mentioned... How would I go about doing something like that? I tried a condition based on the number of attachments being > 1, but it doesn't like it since it is an object and not a number.

Thanks for all of the help so far!