Power Automate: Create SharePoint Folder - Response not in JSON Format

Question

I am working on a Power Automate flow....and beating my head against a wall as well. It seems so easy, but it is failing with an error "The Response is not in a JSON format"

The intention of the flow is to set up standard folders in some 200 SharePoint sites within my company. In two files on each of these sites, I want to add a Year Folder (i.e. 2022) and a Month Folder (10-Oct). Seems straight forward.

I have a SharePoint list that contains all the SharePoint sites. After manually triggering this flow, it references the SharePoint List (Get Items). Then working down the list of SharePoint site (Apply to Each), Create the new folders. Been researching & tinkering with this for a couple of hours.

The "Directory" is pulled from the SP List as well: for this example assume it is "Share Documents1" thou it does vary slightly around the company...

The naming is all correct....

Here is the Error output. I am at a loss...

I see there are some strange characters in your site address value. :f:/r/ Can you remove that part from the value? — Expiscornovus, Commented Oct 16, 2022 at 10:08
wow....that was exactly it! The rest of the worked fine once I fixed that. I used the "Copy Link" within SharePoint when creating my list of sites and it added those extra characters. THANKS@ — RustyMc, Commented Oct 16, 2022 at 14:00
Great to hear that was it. I have posted it as an answer so you can mark my answer as accepted :) — Expiscornovus, Commented Oct 16, 2022 at 15:53

Expiscornovus · Accepted Answer · 2022-10-16 15:51:56Z

0

I see there are some strange characters in your site address value. :f:/r/ Can you remove that part from the value?

answered Oct 16, 2022 at 15:51

Expiscornovus

1,4971 gold badge4 silver badges8 bronze badges

Add a comment |

RustyMc · Accepted Answer · 2022-10-16 14:39:53Z

0

This error was thrown due to extra characters in the SharePoint Site Address. When using the "Copy Link" feature within SharePoint, it adds extra characters that are not required, in this case they were :f:/r/.

Once removed, the JSON error was resolved and the flow worked perfectly. Lesson learned, inspect the address for additional strings that are not truly required, remove those, test the link to ensure still valid, then utilize the streamlined link.

answered Oct 16, 2022 at 14:39

RustyMc

391 gold badge2 silver badges9 bronze badges

Add a comment |

Collectives™ on Stack Overflow

Power Automate: Create SharePoint Folder - Response not in JSON Format

2 Answers 2

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Related