Unanswered

parsing JSON error

(0) Share

Report

Posted on by PatrickvanderS

Hi,

I am relatively new with Power Automate. I tried to automatically create a new SharePoint site via Power Automate (I literally did what they did here: https://www.c-sharpcorner.com/article/modern-team-site-creation-automation-with-power-automate/#:~:text=Create%20Flow%20to%20automate%20the%20site%20creation&text=Then%20from%20the%20open%20dialog,whenever%20an%20item%20is%20created ) but my flow fails at parsing JSON. The error says: Unexpected character encountered while parsing value: B. Path '', line 0, position 0..

According to the error message this is a new problem. Did anyone see this before and how did you solve it?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report

Hi @PatrickvanderS,

Can you share a screenshot of the output of the Send an HTTP request to SharePoint action? My guess would be that we need to update the json schema for the parse json action.

Can you also share a screenshot of the row of SharePoint list for site requests which the flow fails (with the fields Title, Alias, etc.). Just double check which values you are using the title and alias fields.

Was this reply helpful? Yes No
PatrickvanderS 6 on at

Like (0)

Report

Was this reply helpful? Yes No
PatrickvanderS 6 on at

Like (0)

Report

Thanks for your reply. This is the full output text:

{
  "d": {
    "CreateGroupEx": {
      "__metadata": {
        "type": "Microsoft.SharePoint.Portal.GroupSiteInfo"
      },
      "DocumentsUrl": null,
      "ErrorMessage": null,
      "GroupId": "bc644ca5-f550-42ec-bef2-f9fbc624c435",
      "SiteStatus": 2,
      "SiteUrl": "https://m365x467788.sharepoint.com/sites/Testje"
    }
  }
}

Was this reply helpful? Yes No
PatrickvanderS 6 on at

Like (0)

Report

I added the members to try to add members to the site. So that field is extra.

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

Like (0)

Report
Hoi @PatrickvanderS ,

Based on that output I would say this would be the schema of your parse json action. Are you using the same schema?

{ "type": "object", "properties": { "d": { "type": "object", "properties": { "CreateGroupEx": { "type": "object", "properties": { "__metadata": { "type": "object", "properties": { "type": { "type": "string" } } }, "DocumentsUrl": {}, "ErrorMessage": {}, "GroupId": { "type": "string" }, "SiteStatus": { "type": "integer" }, "SiteUrl": { "type": "string" } } } } } } }

Was this reply helpful? Yes No