Unable to Access Dynamic Content from SharePoint Trigger in Power Automate Flow

[anzocontrols]

Hello Power Automate Community,

I am facing an issue with accessing dynamic content from a SharePoint trigger in my Power Automate flow. I am trying to create an email notification when a new item is created in my SharePoint list. However, I am unable to see any dynamic content within the "Send an email (V2)" action, making it challenging to include the necessary information from the newly created item in the email body.

Details of the problem:

• Trigger: "When an item is created" from SharePoint.
• Flow Action: "Send an email (V2)" to notify the relevant users about the new item.
• Expected Behavior: I should be able to access the properties of the newly created item directly from the SharePoint trigger's dynamic content, but it's not showing up in the "Send an email" action.
• Error Message: I received a "Flow save failed with code 'DynamicOperationRequestClientFailure'" error with a message stating that the "ProfilePicture" field data type is not supported.

Steps taken to troubleshoot:

1. I created a view in my SharePoint list, excluding the "ProfilePicture" column from the view, but the issue persists.

Any guidance or assistance in resolving this issue would be greatly appreciated. If anyone has encountered a similar problem or has insights on how to access dynamic content from a SharePoint trigger, please share your thoughts.

Thank you in advance for your help!

Best regards,

AnzoControl

[CFernandes]

@anzocontrols - Try to add a compose and see if you get the Dynamic data...

If that works pass the compose action to send email notification.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

[anzocontrols]

i tried but this is what i get. No dynamic content. 

[trice602]

Hi @anzocontrols ,

There's an issue with your view because my dynamic content appears when rebuilding this.

Always glad to help! Tom

[anzocontrols]

does your list have a column whose datatype is Picture? 

My list has a column whose data type is Picture. I tried creating a view on top of my list which excludes the Picture column but when I save the flow using the view, then also I get same error and error mention the picture column.

below is my list with default view "All View" and you can see the picture column 

below is my list with my custom view "PowerAutomateView" and you can see there is no picture column 

within my flow, I am referncing to PowerAutomateView which do not have picture column, but when I use this view in flow, still no dynamic content and when I try to save the pkg, it fails as still its referring to the picture column. 

Is it a bug  in power automate that it can not use a list which has a picture column?

Now even though, I am referring my view which do not have the profile picture column, but power automate still giving error for the picture column when I save the flow. 

[CFernandes · Accepted solution]

@anzocontrols Get items will not work.

Image\Picture columns in SharePoint are not returned in the output of the Get items action in Power Automate.

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

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[anzocontrols]

Thanks, finally it worked after I made the image column of my list from Required to Not Required. Thanks alot everyone.