Answered

Json parses the relative Sharepoint-path for a pdf-upload different from an Office (Word)-document?

(1) Share

Report

Posted on by MB-15071008-0

I'm building a flow to collect answers and uploads from a Microsoft Forms and store them in Dataverse. After the storage in Dataverse is succesfully, I want to delete the file using a HTTP-request.

For now it's just a very simple test form with four questions, just to figure things out. I was very happy to get it to work the first attempt with uploading a pdf-file.

However, when I try to upload a Word-document, instead of the relativeURL Json parses the shareable link rather than the relative Url, which l can't use in the HTTP-request.

Using the same Parse Json scheme on the form output:

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "name": {
                "type": "string"
            },
            "link": {
                "type": "string"
            },
            "id": {
                "type": "string"
            },
            "type": {},
            "size": {
                "type": "integer"
            },
            "referenceId": {
                "type": "string"
            },
            "driveId": {
                "type": "string"
            },
            "status": {
                "type": "integer"
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}

This is the output for a PDF-file, which works for the HTTP-request:

"link": "https://mytennant.sharepoint.com/sites/Group-Test/Shared%20Documents/Apps/Microsoft%20Forms/Untitled%20form/Question/UploadtestWord_%202.pdf"
 
And this is the output for a docx-file:
"link": "https://mytennant.sharepoint.com/sites/Group-Test/_layouts/15/Doc.aspx?sourcedoc=%7B239B2D4E-9712-4562-A910-956D873176D9%7D&file=UploadtestWord_%206.docx&action=default&mobileredirect=true",
 
Can anyone help me retrieving the relative Url to an office365 file on Sharepoint?

Categories:

Business Process Flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Pstork1 67,902 Most Valuable Professional on at

Like (0)

Report

Json parses the relative Sharepoint-path for a pdf-upload different from an Office (Word)-document?

If the file is uploaded in response to a question then the relative path, other than the file name, will always be the same. It will be in your OneDrive for Business. So I normally just store that path as a variable and then Concatenate it with the filename (name field) to get the relative path to the file. That bypasses the problem with Office files entirely.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

BB-18031745-0 35 on at

Like (0)

Report

Json parses the relative Sharepoint-path for a pdf-upload different from an Office (Word)-document?

If you extract the file's guid from the link or from somewhere else in the json, you can use that to access the file in your http request.

With your example you would use https://mytennant.sharepoint.com/_api/web/GetFileById('239B2D4E-9712-4562-A910-956D873176D9')

Was this reply helpful? Yes No
Suggested answer

abm abm 32,561 Most Valuable Professional on at

Like (0)

Report

Json parses the relative Sharepoint-path for a pdf-upload different from an Office (Word)-document?

Hi

You can use a split() expression with delimiter as '/' then user the last() expression to get the last value. Then check for if that contains .pdf that means its a pdf one.

If not PDF the try use the split() with '/' then use concat() expression and use the right index to get the split() results to get the domain name then get Group-Test form the split array and file name. Basically you trying to create the path of the word doc.

Thanks

Was this reply helpful? Yes No
Suggested answer

Pawel_Bernardzik 15 on at

Like (0)

Report

Json parses the relative Sharepoint-path for a pdf-upload different from an Office (Word)-document?

Hi, I think that the issue is that you are using Word Web link instead of the link to the actual Word document. Have you tried to use link in the format:

"https://mytennant.sharepoint.com/sites/Group-Test/Shared%20Documents/WordDocument.docx"?

Was this reply helpful? Yes No