Hi @romankorchak2
Here is the sample flow to extract content of Image column in SharePoint list.
In the below example, 'ImageCol' is the name of Image column in SharePoint list 'Action Tracker'.
Firstly, add "Send an http request to SharePoint" action and set input parameters as shown below to retrieve the Image column object. Here, I have hardcoded the ID of the list item, but you could pass it dynamically:
Site Address: <SharePoint site collection URL>
Method: Get
Uri: _api/web/lists/getbytitle('Action Tracker')/items(1)?$select=ImageCol
pls replace the list name, item id & column name as per the need.
Next, add "Get file content by path" action where we will pass the path of the file obtained from the previous action. We would be adding expression to exact the file path. Expression needs to be added in the expression box as shown below:
join(skip(split(json(body('Send_an_HTTP_request_to_SharePoint')?['d']?['ImageCol'])['serverRelativeUrl'],'/'),3),'/')
pls replace the image column name with the actual name in the above expression.
The output of get file content could be further passed to the AI builder action.
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
