Unanswered

Taking Image Submissions from Forms, Renaming and Moving Files in OneDrive

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am looking to create a flow that does the following:

There is form where a Shipment Number and image files are uploaded. I want to when a new response is recorded to take the image files from where Forms saves them and rename them to the Shipment Number that was recorded for the submission and move them to another folder. I can't find any online advice on how to do this.

Files go to: /Apps/Microsoft Forms/Claims & Customer Complaints/Claims Images

I want them copied or moved to /Desktop/Industrial Engineer/IE-Communal/Claims & Customer Complaints Supporting Documents

but renamed with the shipment number for EACH file uploaded with the submission. Shipment Number_1 or something for duplicates is fine.

Categories:

Building flows

All responses (6)

Answers (0)

Sort by

Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

You don't have an option to rename the files when you copy or move them. But you can retrieve the file contents and then create a new file with that content and whatever name you want in the new location. Then delete the old file.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pstork1

How would I do that? What is the syntax or steps that are needed to. When the forms submission has multiple images and I need them all renamed in a new location. Can that be done with retrieving the file contents and creating new files, if so how?

Thanks
Pstork1 69,665 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Here's an example.

Form is submitted triggers the flow

Get Response Details from the form

Parse the REsponse Details to get the Ids of the files that were uploaded.

Initialize a variable as a counter

For each file

Get the content

Increment the counter variable

Create a new file using the content and a filename created by concatenating the name you want to use with the counter variable.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1

Thank you, I got it all to work except that when it puts the file in the new location the type is just "File" instead of like a JPEG or PDF. How can I fix this/where in the flow and codes is this found?
Thanks for how much you've helped!!
Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

When specifying the file name in the Create File action make sure you attach the appropriate file extension. Otherwise, OneDrive doesn't know how to handle the file and the browser doesn't know what program to use to open it.
msweeney2 4 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked great. Thank you!