Unanswered

Help creating a flow to upload new images added to onedrive to a Sharepoint/Microsoft List new item image column

(0) Share

Report

Posted on by LisaBowen

Hi everyone,

Image uploads seem to be a tricky thing for Lists and I can't get my head around the HTTP request process and how to add it to an automatic flow. I have searched the database of Q&As and nothing suggested seems to work for my particular need, so I'm posing my own question.

Keen to hear from the experts!

Thank you 🙂

Below is the flow I would like to create:

Flow description:

When an image is added to a folder in OneDrive, upload it to a new record in an existing Microsoft/SharePoint List

(automatic flow)

Connectors:

OneDrive

Microsoft/SharePoint List

Trigger:

A new image is added to my OneDrive images folder

Actions:

1. Create new item in existing Microsoft/SharePoint List

2. Add today's date to Date field (this may auto populate per my New Item settings?)

2. Add image filename as text in Detail field.

3. Upload image to Image 1 field

4. Add image file link to Hyperlink field

Categories:

Using flows

I have the same question (0)

All responses (16)

Answers (2)

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@LisaBowen so you want to create a flow when new image is added to OneDrive? You need to use "

When a file is created" trigger to create the flow. Then you need to use Get File Content action to get the file content, then use "Create File" action to create that file in SharePoint using the outputs of Get File Content. Then you can use Update File Properties to upload the field properties

Was this reply helpful? Yes No
LisaBowen 32 on at

Like (0)

Report

Thanks for your help Anna,
I can't find my Image field in either "update file properties" or "update item properties".
Am I missing something?

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@LisaBowen i am sorry i overlooked that image column wont appear in Update File Properties, alternatively you can use Rest API to update the image and hyperlink column value, refer to below posts

To update image column value, here the image should already exists in the SharePoint site

https://powerusers.microsoft.com/t5/Using-Connectors/HTTP-POST-to-Update-Document-Library-Cloumn-Image-Thumbnail/td-p/2238697

to update hyperlink column value

https://www.annajhaveri.com/power-automate/rest-api-to-create-and-update-sharepoint-list-items-from-power-automate

Was this reply helpful? Yes No
LisaBowen 32 on at

Like (0)

Report

Hi Anna,

Thanks for your continued help with this.

My Flow already includes an action that adds the required image as an attachment to the list item and the image is also contained in another folder in my Sharepoint site.
I've tried directing the Compose & HTTP request to both of these locations and the flow succeeds but the thumbnail will not display in my list.

Can you help me find out why?

Thanks again,
Lisa
Here are some screenshots:

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@LisaBowen from the urls in your payload, it looks like your list and images are in onedrive or SharePoint?

Was this reply helpful? Yes No
LisaBowen 32 on at

Like (0)

Report

Hi again Anna, please excuse my inexperience across these applications.

So, the images and List need to be stored specifically in the "SharePoint site", would you mind assisting me to move them to the correct location?

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

@LisaBowen it this list is for use of multiple people i would suggest to store the list and images in SharePoint site.

To move the list there isnt a straightforward method to move the lists, unless you are using third party migration tools or PowerShell. You can create a new list from existing list, this will copy the structure of the list but you will need to copy the data manually, do you have a lot of data and images currently in your personal site?

Was this reply helpful? Yes No
LisaBowen 32 on at

Like (0)

Report

@annajhaveri It is just myself using the list. Other users enter into the form separately to enter items but don't need to access the list.
The list is quite large (3700 items) and includes a number of thumbnails uploaded directly.
But I do want to automate the processing as much as possible so to have this flow working correctly would be extremely useful. So I can move to a new list if I have to. Would there be any guidance available for this?
I thought I was using a sharepoint site already? Can you advise on where I should look for a better understanding of Sharepoint site vs Sharepoint etc? I did set up a SharePoint site and a Teams group but found navigation confusing and deleted them, but this List is much older than that.
Thanks again foe your help 🙂

Was this reply helpful? Yes No
Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report

@LisaBowen you can know more about lists here https://learn.microsoft.com/en-us/microsoftteams/manage-lists-app

To move list to SharePoint site you can try trial version of this migration app https://sharegate.com/microsoft-migration, this is the easiest way to migrate along with data

Was this reply helpful? Yes No
LisaBowen 32 on at

Like (0)

Report

Thank you for your time and patience @annajhaveri
I looked at all the information you provided and migrated my List from my "personal" SharePoint site to a brand new Team site. After that and a few tweaks, my flow finally works!
Ever grateful,
Lisa

Was this reply helpful? Yes No