Answered

Chat GPT makes a mistake about the new Image Type Col field

(0) Share

Report

Posted on by rashantha

Hi I have been trying to figure out how to download the file in the image type col via Power Automate triggered by selecting an item in the Sharepoint List.

I reached out to Chat GPT, which I think gets it wrong (please see step 4).

If you know a way of doing this. I would greatly appreciate it.

CHAT GPT outuput

ME:

Can you be more specific with this step Next, add an action to get the image from the Image Column Type. Choose the "Get file content" action and provide the site URL, library name, and the Image Column Type field dynamic content

Chat GPT:

Sure, here are more detailed steps to add an action to get the image from the Image Column Type:

In Power Automate, add a new action to your flow after the "Get item" action.
Search for "Get file content" in the search bar and select the "Get file content" action.
In the "Get file content" action, select the "Site Address" field and provide the URL of your SharePoint site.
In the "Library Name" field, provide the name of the document library where your image is stored. Note that this library must be the one associated with the Image Column Type.
In the "File Identifier" field, click the "Add dynamic content" button, select "Add dynamic content" and search for the Image Column Type field from the dynamic content.
Make sure to select the correct dynamic content from the list, which will have the display name of the Image Column Type field in your SharePoint list.

Once you have completed these steps, the "Get file content" action should retrieve the image from the specified Image Column Type in your SharePoint list.

I hope this helps! Let me know if you have any further questions.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @rashantha,

You could use two actions to retrieve the file content. The first is a Send an HTTP request to SharePoint action to retrieve the image column and it's properties (one of them is the serverrelativeurl to the uploaded file). In the second HTTP request you can retrieve the encoded file content.

Below is an example of that approach.

In this example the Image column is called ImageTypeColumn

1. Uri first HTTP request

_api/web/lists/getbytitle('ChatGPT example')/items(1)?$select=ImageTypeColumn

2. Headers first HTTP request

{ "Accept": "application/json;odata=nometadata", "Content-Type": "application/json;odata=nometadata" }

3. Uri second HTTP request

_api/web/getfilebyserverrelativeurl('@{json(outputs('Send_an_HTTP_request_to_SharePoint')?['body']['ImageTypeColumn'])['serverRelativeUrl']}')/$value

Was this reply helpful? Yes No
rashantha 65 on at

Like (0)

Report
Copy link

Link copied!

Thank you.
I used the create file at the end to download the file and
json(outputs('Send_an_HTTP_request_to_SharePoint')?['body']['Image'])['fileName']
to obtain the name of the file.

Was this reply helpful? Yes No