Get link of file from OneDrive folder link

[Anonymous]

I am using powerquery with Excel for getting details of each students (name, last name, school, grades, onedrive link...) 

Each student have a onedrive folder that contains files as photo (Document_Photo.jpg)

However I would like to get the photo from this onedrive link folder for each student

Then i would lilke to know if when i get this photo file, i want to rename it as Name_LastName.jpg for each student

Thanks for your help

[CNT]

@Anonymous To do this u'll need to use Flow with the OneDriveForBusiness Connector.

1. To get the Photo, u'll use the GetFileContent function and

2. To rename the File, u'll use the UpdateFile function.

Please check the full doc here, OneDrive for Business - Connectors | Microsoft Docs

Hope this helps!

Please remember to give a 👍 and accept the solution as it will help others in the future.

[Anonymous]

@CNT Is it possible to do this with Flow ? :

I would get the photo from the onedrive link i can have in my Excel file,

Rename the file by name and last name of the student (I have the details in my Excel file)

And put the link of the photo in my excel file

Then each line have the name / last name / onedrive link / onedrive link photo 

[CNT]

@Anonymous Yes all that's possible with Flows. Please check these videos,

https://www.youtube.com/watch?v=KdnWlZCEu2c

https://www.youtube.com/watch?v=dEjDhmT3P0w

https://www.youtube.com/watch?v=pEHnQ_BQPXw

Regrading storing photos in Excel, I'm not an Excel expert so I can't say much.

Hope this helps!

Please remember to give a 👍 and accept the solution as it will help others in the future.

[CNT]

@Anonymous Just checking if you got is working. 🚧

Please remember to give a 👍 and accept the solution as it will help others in the future.

[Anonymous]

@CNT  I tried something but it seems still not working ... 

I forgot to mention that student folder is into subfolder with different levels as :  

Folder 1 -> Folder 2 -> Folder 3 -> Folder 4 -> Folder 5 -> Name_LastName (folder with student name)

I tried to browse each folder (each one contains subfolders), in order to find the Document_Photo.jpg file, to rename it according to the name of the student's folder 

I can find the first folder, it find me 5 subfolders but I am stuck after that

[CNT]

@Anonymous I would suggest to get some thing simple working first and then add more to it!