Unanswered

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

(0) Share

Report

Posted on by Community Power Pla...

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.

I have the same question (0)

All responses (6)

Answers (0)

Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Pstork1 68,271 Most Valuable Professional on at

Like (1)

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

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.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

@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!!

Was this reply helpful? Yes No
Pstork1 68,271 Most Valuable Professional on at

Like (0)

Report

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

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.

Was this reply helpful? Yes No
msweeney2 4 on at

Like (0)

Report

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

This worked great. Thank you!

Was this reply helpful? Yes No