1

Flow was working fine until I added a column of type Image to the SharePoint list.

(I was hoping to be able to get the image and send it in an email etc).

But now the Flow fails at the Get Items action:

The required field "My Image" data type is not supported.

Issue should be reproduceable by doing a Get Items on any SharePoint list with an Image column.

I am using a Filter Query in Get Items, so that only 1 item is returned, eg:

Unique_x0020_Values eq '@{variables('search_string')}'  
1

As per my research, Image columns in SharePoint are not returned in the output of the Get items action in Power Automate.

However, you can get the Image URL using SharePoint REST API (using Send an HTTP request to SharePoint action) like:

https://<tenant>.sharepoint.com/sites/SPConnect/_api/Web/Lists/getByTitle('List Name')/items?$select=Title,LogoImage

Where LogoImage is internal name of image column.

Sample response:

<m:properties>
    <d:Title>New Power Apps logo looks cool! Really really cool!!</d:Title>
    <d:Image>{
          "fileName": "Power Apps logo.jpg",
          "serverRelativeUrl": "/sites/SPConnect/SiteAssets/Lists/dbc6f551-252b-462f-8002-c8f88d0d12d5/Power%20Apps%20logo.jpg",
          "type": "thumbnail",
          "fieldName": "Image"
      }
    </d:Image>
</m:properties>

Where serverRelativeUrl is the URL of image which you can use in your Power Automate flow.


Related reading:

SharePoint Online: All you need to know about New Image column type


Further implementation:

To retrieve a single item's Image column value in Power Automate, and add it to an email using the Send an email (V2) action, you could do something like this:

  1. Send an HTTP request to SharePoint (where EventImage is internal name of Image column):
Site Address:  Team Name - https://yourtenant.sharepoint.com/sites/yoursite  
Method:  GET  
Uri:  _api/web/Lists/getByTitle('Events')/items(@{variables('event_id')})?$select=EventImage  
  1. Initialize a variable with an expression that gets the fileName of the image:
Name:  event_image_filename
Type:  String   
Value:  json(body('Send_an_HTTP_request_to_SharePoint')?['d']['EventImage'])['fileName']
  1. Get file content using path:
Site Address:  Team Name - https://yourtenant.sharepoint.com/sites/yoursite
File Path:  /SiteAssets/Lists/your-list-folder-name-here/@{variables('event_image_filename')}
Infer Content Type:  Yes
  1. Initialize a variable to create an <img> tag from the base64 of the image file:
Name:  event_image_img_tag
Type:  String  
Value:  <img style="display:block;" src="data:image/jpg;base64,@{body('Get_file_content_using_path_-_Event_image')['$content']}" alt="Event Image" border="0" width="300" height="300">
  1. And then insert the variable in your email's HTML code.
4
1

Change the "Require that this column contains information" to "NO" and the issue disappears:

enter image description here

1
  • The error has gone away but I cannot see the column in the Raw Outputs of Get Items - is the Image column property being returned for you? Jul 30 at 9:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.