Add or Update Image Column in SharePoint with Power Automate: Download and Use Images from the Web

The blog post titled Update image in SharePoint/Microsoft Lists Image columns using Power Automate by Ganesh Sanap rovides a guide on how to update an image column in SharePoint or Microsoft Lists using Power Automate. The native “Create Item” and “Update Item” actions in Power Automate do not directly support adding or updating image columns. Instead, Ganesh suggests using the “Send an HTTP Request to SharePoint” action to accomplish this.This blog post covers how to download an image from an image url and add/update the image column.

This blog post focuses on downloading an image from a URL and subsequently adding or updating the image column.

Create a list with the following columns

To begin, either use an existing list or create a new list with the following columns:

Make sure to populate both the title and mediaUrl fields. In the provided example, Instagram image URLs are utilised.

Ensure Assets library Creation with PnP PowerShell

To ensure the creation of the Assets library, execute the following PnP PowerShell script:

Connect-PnPOnline -Url https://contoso.sharepoint.com/sites/<siteName>/ -Interactive
$web= Get-PnPWeb
$web.Lists.EnsureSiteAssetsLibrary()
Invoke-PnPQuery

Power Automate flow

Navigate to Power Automate and create a new Instant cloud flow using Manually trigger a flow trigger.

1. Add the Get Items action to retrieve all items from the SharePoint List, specifying the Site Address and List Name.

2. To upload the image to the Site Assets library, use the Create File action to save the image obtained from previous step. Set the Folder to SiteAssets/lists/ and the FileName to the title of the list item suffixed with .png.

To obtain the listId, navigate to the list settings and copy the list id from the URL.

Disable Allow Chunking for the Create File action to prevent flow failure if the file already exists.

3. To save the image to column, use the Send an HTTP request to SharePoint action and configure the properties as follows

Method : POST Uri : _api/web/lists(’’)/items(@{items(‘Apply_to_each’)?[‘ID’]})/validateUpdateListItem() Headers: content-type : application/json;odata=verbose accept : application/json;odata=verbose

Body:

{"formValues":[{"FieldName":"media","FieldValue":"{\"type\":\"thumbnail\",\"fileName\":\"@{items('Apply_to_each')?['Title']}.png\",\"fieldName\":\"media\",\"serverUrl\":\"https://contoso.sharepoint.com\",\"serverRelativeUrl\":\"/sites/siteName@{outputs('Create_file')?['body/Path']}\"}","HasException":false,"ErrorMessage":null}],"bNewDocumentUpdate":false,"checkInComment":null}

The final flow looks like like this.

Save and test the flow. After the flow completes, the image column of all items will be populated from the URL specified from mediaUrl field

• Image, PowerAutomate
• SharePoint List