Answered

Bulk renaming photo files

(0) Share

Report

Posted on by OttarLM

Hi all,

Me and my colleagues work with ships inspections and through this work we gather a lot of photos, photos often tell a better story than words.

Now that we have started using Teams, SharePoint and MS 365, we see that it is potential to be a bit smarter in our storage and organizing of the photos we gathers.

I hope now that you can give me som good advice on how to build a Flow or PowerApp similar to what I write below.

Beer in mind that not everyone in our team is as tech-savvy as other.

User: Upload photos to a specific folder in SP (Photos Import Folder)

User: Fills in a MS Form

Date of photos taken (Only one day's photos will be uploaded at a time. This, as the date stamp on photos not always correspond to reality)
Vessel Name
One main key word from inspection
Otherkey word from inspection

Flow: Rename files "YYYYMMDD_indexNO_VesselName_MainKeyWord" (Example: 20200411_1_Osprey_Engine).

Flow: copy or moves files from "Photos Import Folder" to SP Photos Library.

Flow: Fill in column for Vessel Name in SP Photos Library.

Flow: Adds main key word and other key words as tags to all files.

Flow: Delete remaining files from "Photos Import Folder".

Flow: Sender user confirmation of job done.

Thank you in advance for your good advice and tips

@RandyHayes 😀

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @OttarLM

If the users are all in your organization, you can enable attachments on forms and the users can directly upload it on the form. You can follow my post here to understand how attachments and forms work with Power Automate. https://www.bythedevs.com/post/working-with-files-on-ms-forms-in-ms-power-automate

Once you get the attachment, you can create a new file with it and name it as you like and that should be it.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
OttarLM 10 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the quick reply @yashag2255 ,

MS Form´s is a great tool for register manual input.
I plan to insert the above abovementioned fonder (Photo import folder) and the MS Form on a SP Page, with surrounding explanatory text.

I see that my Form have a limitations of 10 uploaded files at a time, unfortunately, this will not be enough.

Do you have any good tips on how I should build a suitable Flow?
yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @OttarLM

Sure. So you can get the form filled and then use action to list files in a folder. And then add the rename action (available in OneDrive only) and for SharePoint, get content of each file, create a new folder and then create a new file for each file that was listed by adding a new name and then finally delete the files from the main folder.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @OttarLM ,

Do you use Microsoft Forms to collect your data?

How do you upload photos to specific folder in your SP Library?

Based on the needs that you mentioned, I afraid that there is no easy solution to achieve your needs. As an direct solution, you could consider set up a SP List to collect user's entry. Within this SP List, you should contain the following fields:

- Date of photos taken - Vessel Name - One main key word from inspection - Otherkey word from inspection

Then you could generate an app based on this SP List, and then go to the Edit form, enable the "Attachments" field, then you could use the Attachments control to upload files as attachments of submitted SP List record.

Within your Power Automate flow, you just need to add a "When an item is created or modified" trigger or "When an item is created" trigger of SP connector. Then you could use the "Get attachments" action to get the attached files of current submitted List Item record. You may need to apply a "Apply to each" action to the Output result from the "Get attachments" action. Within the "Apply to each" action, add a "Get attachment content" action to get the attachment file content. Then add a "Create file" action to create a file in your SP Library

Please take a try with above solution, then check if the issue is solved.

Note: The "When an item is created" trigger would be fired when a new item is created in your SP List.

More details about expression supported in Power Automate flow, please check the following article:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference

Best regards,
OttarLM 10 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-xida-msft

Thank you so much for your solutions. I definitely think we are on the right track here.
Using SP List with columns works good and it is probably the way to go. 👍

Unfortunately I did not get my Flow two to work.
When it came to the step for "Apply to Each" I got a time out error.
Unfortunately, I am not skilled in using expressions, so I didn't manage to set up a increasing index number.
See attached screenshot.
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @OttarLM ,

For "Time out error" within "Apply to each" action, please go to the "Settings" option of the "Apply to each" action, then enable "Concurrency Control" option, then change the "Degree of Parallelism" option to maximum value -- 50 as below:

then save your flow, try it again, check if the issue is solved.

More details about how to use expression in flow actions, please check the following blog:

https://flow.microsoft.com/en-us/blog/use-expressions-in-actions/

If the solution I provided above could help in your scenario, please go ahead to click "Accept as Solution" identify this thread has been solved.

Best regards,