Unanswered

NotFound - The response is not in a JSON format.

(1) Share

Report

Posted on by Community Power Pla...

Hi,

I have a problem with my Flow, i get the following error message: NotFound - The response is not in a JSON format.
See screenshot below:

UHKOfo1

Flow Error

Even though the file does exists in the document library.

7tIwMae

Can someone tell me what i'm doing wrong?

Categories:

General topics

I have the same question (0)

All responses (14)

Answers (1)

v-litu-msft on at

Like (0)

Report

Hi @Anonymous,

Could you please share the screenshot of Flow configuration?

What's the action you are using?

This field should be an identifier of the file? sorry for the reason of language, I am not sure, maybe it should be the ID of file.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

This is the flow configuration,

I'm getting a value from PowerApps which corresponds to a filename in my document library in sharepoint, and then i proceed to delete the file (Slet fil) from the document librarry

Was this reply helpful? Yes No
Verified answer

v-litu-msft on at

Like (14)

Report

Hi @Anonymous,

Because when delete file will send an HTTP request to SharePoint, so the Identifier of the file should encode to URL formate, so you should replace these "/" to "%2F". So you could use the replace() function to process the file path, for example:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Perfect! That did the job.

Thank you alot @v-litu-msft

Was this reply helpful? Yes No
susilacherla12 39 on at

Like (0)

Report

You solved an issue which I am struggling for 20hrs now.

Was this reply helpful? Yes No
balboa4100 2 on at

Like (1)

Report

Thank you! Solved my issue as well.

Can't see how to upload any pics to this forum but I am sharing with you my solution, in case anyone else gets the same issue:

https://riveratec1-my.sharepoint.com/:i:/g/personal/jrivera_riveratec_com/EQvPBZDmAmdMnPSfiuuptM8BSD6jC52o8KsOJ98I3bMWIg?e=OKK9GD

Regards,

Jose Angel Rivera

Was this reply helpful? Yes No
ocmcadams 16 on at

Like (0)

Report

Thank you for this information, I am sure it is going to help, but how do covert it when the file name is dynamic?

Where would you put the command to to replace?

Was this reply helpful? Yes No
ocmcadams 16 on at

Like (0)

Report

Hello, thank you for posting, this is very helpful. I am still having a problem with getting this JSON error. My question is the "compose_2" the actual file name? I don't have a compose, but I have a Create File that I am using. The file name is using dynamic information from a Form submitted.

Was this reply helpful? Yes No
zylantha2 103 on at

Like (2)

Report

Thank you for identifying the issue which is clearly a bug in the implementation of this action as no others require the path to be URL encoded.

Your solution however is incomplete, as it does not provide full encoding of all required characters.

Instead you should use encodeUriComponent() which has full URL encode logic thus:
encodeUriComponent(outputs('Document')?['body/{FullPath}'])

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hello,
I know it's late answer but maybe it will help you anyway.
I think you can put your dynamic path into compose and that compose output put in replace function. Otherwise you can manually replace in action field: '%252f' instead of '/' and '%2b' instead of space ' '.

Was this reply helpful? Yes No