cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ikarthik
Microsoft
Microsoft

Image column is not showing in Dynamic content - Power Automate

I have a list contains three columns:
1. MM/dd/YYYY - Date (is a unique value, so it will have only 1 record from the entire list),
2. Product,
3. Image
and the type of the columns are Date & Time, Single line of text and Thumbnail.

I have created a schedule flow, and would like to send an email 
To: MyTeam
Subject: Product (from Dynamic Content)
Body: Image (from Dynamic Content - but couldn't find it)
Now, I would like to have the Image embedded in the email, which should be from the record that meet the date criteria (MM/dd/YYYY - Date = Today's date), but I couldn't find Image column in Dynamic Content.
ikarthik_0-1630388350788.png

 

Could you please help me to resolve this?

3 REPLIES 3
ekarim2020
Super User
Super User

Image columns in SharePoint are not returned in the output of the Get Items action in Power Automate. You can get the Image URL using SharePoint REST API:

https://sharepoint.stackexchange.com/questions/296641/performing-a-get-items-action-on-a-list-with-a...

Ellis

KatjaK
New Member

I have a list with 12 columns and one is a Photo/ thumbnail. I am not trying to retrieve the photo into my approval flow, however it completely blocks all dynamic content, even when limiting return data to a view without the photo column. I tested this by replicating this list and deleting the photo column, at which point dynamic content becomes available again. Is this a bug? 

I had this same problem. I solved it by making my image column not required.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (5,477)