Unanswered

Get link of file from OneDrive folder link

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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