cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

User account parse with HTTP Request, user name with comma character may cause error 400-Invalid JSON ??

The SP user account is parsed for us to grab employee ID (custom SP field). This particular user with an apostrophe in the name is returning 'Flow run failed' each time, with error message 400, Invalid JSON. A comma character :

 

"status": 400,
"message": "Invalid JSON. A comma character ',' was expected in scope 'Object'. Every two elements in an array and properties of an object must be separated by commas.\r\nclientRequestId: bd3a38cc-6c65-4e67-a3a6-d02bd6f2e830\r\nserviceRequestId: 7438059f-c0cd-9000-8877-6de234dbe744",
"source": "............./_api/Lists/getbytitle('45')/items",
"errors": [
"-1",
"Microsoft.SharePoint.Client.InvalidClientQueryException"
]

 

image.png

 

How do we go about fixing this or preventing this from happening?

 

Many thanks.

 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: User account parse with HTTP Request, user name with comma character may cause error 400-Invalid JSON ??

Hi @lostgical ,

 

Could you please share a screenshot of the configuration of your flow?

 

Best regards,

Alice       

 

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

 

Highlighted
Advocate II
Advocate II

Re: User account parse with HTTP Request, user name with comma character may cause error 400-Invalid JSON ??

image.png

 

 

And detail of the failed step:

 

image.png

 

{
'__metadata': { 'type': 'SP.Data.45ListItem'},
'Title': '-------Sign-in',
'AttendeeName': 'O'Day, -------',
'Email': '--------------',
'Department': '----------- Executives',
'EmployeeID': '0----',
'EventListID': '--'
}

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Users online (5,956)