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!

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (1)

SCTdan 604 on at

Like (0)

Report

Can you expand out the part of your flow currently doing this?

You should be able to loop through the attachments, renaming and submitting each one in turn. Create a variable, set it to increment each loop, use that as your sequential identifier.

Was this reply helpful? Yes No
i_reminisce 79 on at

Like (0)

Report

Here's a picture of it expanded, let me know if you need more information.

Can you walk me through the "Create a variable, set it to increment each loop, use that as your sequential identifier." portion of your suggestion? Despite how it seems I'm very new to Flows and don't have much programming experience.

Was this reply helpful? Yes No
Verified answer

SCTdan 604 on at

Like (0)

Report

Sure, it's pretty straightforward and very useful

Hastily thrown together example-

First you'll want to add a variable (Initialize Variable action). Give it a name, set it as an integer, and set your default value. We'll keep it simple and assume you are ok with just appending -1, -2 etc

Add that variable as part of your filename like you've done with the sharepoint fields.

Then within your loop, as the last step, add in the Increment variable action. Choose the variable you created above, and set the value to increment by. First loop through will use whatever the initial defined value was (1), then just starts counting up according to the value defined in the increment variable action until the loop exits.

*You could add some additional logic so that if you only have one attachment, it doesn't include the sequential identifier

Hope that helps

Was this reply helpful? Yes No
i_reminisce 79 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
i_reminisce 79 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
PytByt 943 on at

Like (0)

Report

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

Was this reply helpful? Yes No
i_reminisce 79 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
PytByt 943 on at

Like (0)

Report

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

Was this reply helpful? Yes No
i_reminisce 79 on at

Like (1)

Report
@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)

Was this reply helpful? Yes No
PytByt 943 on at

Like (0)

Report
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

Was this reply helpful? Yes No