cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
AKB_2K Helper I
Helper I

SharePoint Multi-Choice People field giving JSON error

Hello,

 

I have created a flow to send approval email on creation of new sharepoint item. In my SharePoint list there is "Person or Group" field with "Allow multiple selections:" marked as "Yes".  I have a created following JSON schema to read the value from the SharePoint item.

{
    "type": "object",
    "properties": {
        "Claims": {
            "type": "string"
        },
        "DisplayName": {
            "type": "string"
        },
        "Email": {
            "type": "string"
        },
        "Picture": {
            "type": "string"
        },
        "Department": {
            "type": "string"
        },
        "JobTitle": {
            "type": "string"
        },
		"@odata.type": {
			"type": "string"
		}
    }
}

My input field is as follows

111.png

 

But even if the JSON schema is valid, I am getting following error when saving the flow 

112.png

 

Can someone help correct this.

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
AKB_2K Helper I
Helper I

Re: SharePoint Multi-Choice People field giving JSON error

I removed the extra fields and modified the JSON to just extract DisplayName and Email field. Code copied below. Now it is working fine. Guess it was because of some of the extra fields and values present or not present in them.

 

{
  "type": "object",
  "properties": {
    "DisplayName": {
      "type": "string"
    },
    "Email": {
      "type": "string"
    }
  }
}

View solution in original post

3 REPLIES 3
Super User
Super User

Re: SharePoint Multi-Choice People field giving JSON error

Hi @AKB_2K ,

 

Please see the below link.

 

https://powerusers.microsoft.com/t5/Building-Flows/Validation-Fails-when-field-has-Symbol/td-p/20588

 

If you may have find this useful then please accept this as solution.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Community Support
Community Support

Re: SharePoint Multi-Choice People field giving JSON error

Hi @AKB_2K ,

 

Could you share the details of the Flow configuration and tell us the properties you need to get?

What kind of requirements do you want to achieve through such a Flow?

 

I did a test here, created a Person type field named User and allowed multiple selections, please refer to the following Schema:

{
    "type": "object",
    "properties": {
        "@@odata.type": {
            "type": "string"
        },
        "Claims": {
            "type": "string"
        },
        "DisplayName": {
            "type": "string"
        },
        "Email": {
            "type": "string"
        },
        "Picture": {
            "type": "string"
        },
        "Department": {
            "type": "string"
        },
        "JobTitle": {
            "type": "string"
        }
    }
}

33.PNG

For more details on the use of Parse JSON, please refer to the following blog:

http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
AKB_2K Helper I
Helper I

Re: SharePoint Multi-Choice People field giving JSON error

I removed the extra fields and modified the JSON to just extract DisplayName and Email field. Code copied below. Now it is working fine. Guess it was because of some of the extra fields and values present or not present in them.

 

{
  "type": "object",
  "properties": {
    "DisplayName": {
      "type": "string"
    },
    "Email": {
      "type": "string"
    }
  }
}

View solution in original post

Helpful resources

Announcements
firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!

firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Community Summit North America

The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Users online (8,093)