Answered

Get_file_content_using_path' failed: File not found

(1) Share

Report

Posted on by baaaailey

I've been trying to follow these YT videos,https://www.youtube.com/watch?v=GVi4ubxcmTg https://www.youtube.com/watch?v=UkcZ6IxiD5w without much success.

My end goal is to get the base64 from the image column 'Attachment2' from a Sharepoint list that we'll send to an external system. I'm stuck on parsing the JSON output from the HTTP request, I cannot get any of the parameters I need extracted out.

Here is the setup I have:

the first Parse Json's generated Schema using the output from the HTTP Get request,

{
    "content": {
        "d": {
            "Attachment2": "{\"fileName\":\"Screenshot 2025-05-09 0659092.png\",\"originalImageName\":null,\"serverRelativeUrl\":\"/teams/mycompanyname/SiteAssets/Lists/12329fc5-db95-4f5c-9489-21ccd672cb91/Screenshot%202025-05-09%200659092.png\",\"id\":\"fec059c2-0a8a-4b97-93a8-346138461be0\",\"serverUrl\":\"https://mycompanyname.sharepoint.com\",\"thumbnailRenderer\":null}"
        }
    },
    "schema": {
        "type": "object",
        "properties": {
            "fileName": {
                "type": "string"
            },
            "originalImageName": {},
            "serverRelativeUrl": {
                "type": "string"
            },
            "id": {
                "type": "string"
            },
            "serverUrl": {
                "type": "string"
            },
            "thumbnailRenderer": {}
        }
    }
}
 
 
this is the output from the above's Parse JSON that is used in Compose:
{
    "body": {
        "d": {
            "Attachment2": "{\"fileName\":\"Screenshot 2025-05-09 0659092.png\",\"originalImageName\":null,\"serverRelativeUrl\":\"/teams/mycompanyname/SiteAssets/Lists/12329fc5-db95-4f5c-9489-21ccd672cb91/Screenshot%202025-05-09%200659092.png\",\"id\":\"fec059c2-0a8a-4b97-93a8-346138461be0\",\"serverUrl\":\"https://mycompanyname.sharepoint.com\",\"thumbnailRenderer\":null}"
        }
    }
}
 
 
 
 
 
the final Parse JSON 1 which uses the output from Compose
 
and finally the Get file content, which is coming out like this when I test it:
'//Attachmemnt1'  so for some reason the parameters of the path are all blank in this step, even though they have values in previous steps
 
 
I've wasted 3 days on this already, does anyone have any insight?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (0)

Report

Hi @baaaailey,

Please see: How to Get SharePoint File Content in Power Automate: File Paths vs URLs – Ellis Karim's Blog

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
baaaailey 25 on at

Like (0)

Report

thanks for the response. I have already read this article though!

Specifically I'm looking for help in understanding exactly where in my flow I'm going wrong to get a blank serverRelativeURL

Was this reply helpful? Yes No
Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (0)

Report
Just to confirm, you are trying to get the content of a SharePoint image column.

Please share the screenshot of how the following actions are configured

When an Item is created or Modified

Get Item

"Send an HTTP Request to SharePoint" has been configured.

Could you also please share the output body of the "Send an HTTP Request to SharePoint".

Ellis Karim
Blog | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
Verified answer

Inogic 1,135 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

This is happening because the value you're accessing directly from the JSON is actually a JSON string, not a proper JSON object.
Your data is available in the Attachment2 field. The data looks like the following:
"{\"fileName\":\"Screenshot 2025-05-09 0659092.png\",\"originalImageName\":null,\"serverRelativeUrl\":\"/teams/...\",\"id\":\"...\",\"serverUrl\":\"https://...\",\"thumbnailRenderer\":null}"
This is a string, not an object.
In order to get the data properly, you need to add the following steps:

Add a Compose action and use the following Power FX expression:

json(body('Parse_JSON')?['body']?['d']?['Attachment2'])

After this, add a Parse JSON action to parse the output.

Pass the output from the previous Compose as the content.

Use the following schema:

{
    "type": "object",
    "properties": {
        "fileName": {
            "type": "string"
        },
        "originalImageName": {
            "type": [
                "string",
                "null"
            ]
        },
        "serverRelativeUrl": {
            "type": "string"
        },
        "id": {
            "type": "string"
        },
        "serverUrl": {
            "type": "string"
        },
        "thumbnailRenderer": {
            "type": [
                "string",
                "null"
            ]
        }
    }
}
After parsing this, you will get all the values you need directly from the Parse JSON action.

Hope this helps.

Thanks!

Inogic

Was this reply helpful? Yes No
baaaailey 25 on at

Like (0)

Report

thanks! trying this out now

Was this reply helpful? Yes No
baaaailey 25 on at

Like (0)

Report

Im still getting a file not found. However, instead of the path being null, it's now there but the file cant be found.

I've tried the following fx formula to decode the uri string as well (didn't work either):

If I paste the uri into my browser, the image comes up though!

Was this reply helpful? Yes No
baaaailey 25 on at

Like (0)

Report

Actually, I re-read your article and spelled the file path out like it's mentioned there and it worked.

thanks for the help!

Was this reply helpful? Yes No
Ellis Karim 11,683 Super User 2025 Season 2 on at

Like (0)

Report

Hi @baaaailey

Glad to hear it!

If this solved your issue, please mark it as ✅ Accepted Answer to help others.

Ellis Karim
Blog | LinkedIn | Bluesky

Was this reply helpful? Yes No