File not found, when I know it's correct

(0) Share

Report

Posted on by jimkpncarena

Hi, this is driving me crazy.

I have a flow that I am getting an image from a SharePoint Column,

the flow goes like this(all thru the outputs, I can see my file name and it is correct)

in Get File Content from a SharePoint list , I am using this:

encodeUriComponent(replace(body('Parse_Image_JSON')?['serverRelativeUrl'],/sites/'MYSITE_GOES_HERE',''))
 
I can see the file name in my output:
{"fileName":"275f876e-41f1-47fa-a2c8-31fc44ecc063.jpeg","serverRelativeUrl":"/sites/MYSITE/SiteAssets/Lists/d7ef4c88-6cd9-4738-b02b-2e4ea6c5885f/275f876e-41f1-47fa-a2c8-31fc44ecc063.jpeg","id":"4a084b5d-2ac8-4a43-9960-260e82f1e615","serverUrl":"https://mymainsite.sharepoint.com","thumbnailRenderer":null}
 
When I actually look at MYSITE/SiteAssets/Lists/d7ef4c88-6cd9-4738-b02b-2e4ea6c5885f/275f876e-41f1-47fa-a2c8-31fc44ecc063.jpeg  I can see the image and display it in the browser.
 
The only thing I can see is that the"serverUrl" is our main sharepoint and not my actual site....
 
I just don't know.
 
Help Please. Thanks!
Jim

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Expiscornovus 33,768 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @jimkpncarena,

You could also use another HTTP request. With that type of approach you don't have to replace and parse your values, because the serverRelativeUrl value is already in the correct format for the GetFileByServerRelativeUrl method with the $value property.

Below is an example of that approach.

In this setup the Image column name is Bild btw. You need to replace that by your column name.

1. Get File Content HTTP request

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

2. Json to create the file in OneDrive

json(outputs('Send_an_HTTP_request_to_SharePoint')?['body']['Bild'])['fileName']

Was this reply helpful? Yes No
jimkpncarena 19 on at

Like (0)

Report
Copy link

Link copied!

Hi The 2nd Uri formula is failing:

'@{json(outputs('Send_an_HTTP_request_to_SharePoint')?['body']['MyImageColumn'])['serverRelativeUrl']}')/$value

in my designer it looks like:

How much should be in the formula and what parts are dynamic content?

Thanks!

Was this reply helpful? Yes No
Expiscornovus 33,768 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @jimkpncarena,

You can either directly copy/paste it as text (in that case you can leave the at-sign and {} characters around it).

If you want add the expression via the expression editor, it would be the below:

json(outputs('Send_an_HTTP_request_to_SharePoint')?['body']['MyImageColumn'])['serverRelativeUrl']}

Also make sure there are single quotes around the value expression as well. And add the /$value at the end to retrieve the file content.

Was this reply helpful? Yes No