How to Get Image from a SharePoint Image Column Using Power Automate

Introduction

Working with images in SharePoint can be confusing, especially when using them in Power Automate. Image columns don’t work like normal attachments and store data in a different way, which makes it hard to get the actual image. In this article, I will show you an easy way to retrieve images from a SharePoint image column and use them in your flow.

Requirement

I have a SharePoint list called Test List with an Image column (data type: Image). Whenever an item is created or modified in this list, I want to automatically get the image from the Image column and send it as an email attachment using Power Automate.

End Result

Below are the steps to Get Image from a SharePoint Image Column Using Power Automate:

Step 1: Create an Automated Cloud Flow

Go to make.powerautomate.com and click on Create. Select Automated cloud flow, then choose the trigger When an item is created or modified. Give your flow a name and click Create to continue.

Step 2: Add Send an HTTP Request to SharePoint

Add the action Send an HTTP request to SharePoint because the normal filter query does not work for getting images from an Image column. Set the Method to GET and in the Uri, use the format below.
Make sure you replace the list name in getbytitle with your SharePoint list name, use the dynamic ID value, and at the end use the internal name of your Image column.

_api/lists/getbytitle('Test List')/items(triggerOutputs()?['body/ID'])/Image

Step 3: Run the Flow and Check Output

Run the flow and go to Run History to check the output of the Send an HTTP request to SharePoint action. In the next step, we will use this response to get the Image filename .

Step 4: Add Compose to Get file Name

Add a Compose action and use the below expression to get the file name from the HTTP response. This will extract the Image file Name which we will use in the next steps.

json(outputs('Send_an_HTTP_request_to_SharePoint')?['body']?['d']?['Image'])?['fileName']

Step 5: Get File Content Using Path

Now that we have the file name, we need to get the actual file content.
So Add the action Get file content using path and select your Site Address.
In File Path, use the format below. Make sure you replace Test List with your list name, pass the dynamic ID from the trigger, and at the end pass the file name from the Compose action.

/lists/Test List/Attachments/triggerOutputs()?['body/ID']/outputs('Compose')

Step 6: Send Email with Image Attachment

Add the action Send an email to send the image as an attachment. In Attachment Name, give any name that suits your requirement.
In Attachment Content, pass the File Content from the Get file content using path action. This will send the image along with the email.

Conclusion

By following these steps, you can easily retrieve images from a SharePoint Image column using Power Automate. Since image columns don’t behave like normal attachments, so using HTTP request is the best way to access them. Using this approach you can send images via email or store them in a document library based on your requirement.