web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Invalid JSON. A comma ...
Power Automate
Answered

Invalid JSON. A comma character ',' was expected in scope 'Object' Error

(0) ShareShare
ReportReport
Posted on by 27

Hi people

 

I am trying to build a flow that creates a List with items

There is a column of type Choice , with a custom format defined in the Flow

 

I have a variable called "CustomFormatStatus" of type "String" defined like this:

 

{
 "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
 "elmType": "div",
 "attributes": {
 "class": "=if(@currentField == 'Approved', 'sp-field-severity--good', if(@currentField == 'Not Selected', 'sp-field-severity--warning', if(@currentField == 'Not Approved', 'sp-field-severity--blocked', 'sp-field-severity--blocked'))) + ' ms-fontColor-neutralSecondary'"
 },
 "children": [
 {
 "elmType": "span",
 "style": {
 "display": "inline-block",
 "padding": "0 4px"
 },
 "attributes": {
 "iconName": "=if(@currentField == 'Done', 'CheckMark', if(@currentField == 'In progress', 'Forward', if(@currentField == 'In review', 'Error', if(@currentField == 'Has issues', 'Warning', 'ErrorBadge'))))"
 }
 },
 {
 "elmType": "span",
 "txtContent": "@currentField"
 }
 ]
}

 

Then below I have inserted this JSON in the HTTP Request like this:

 

Pedrogr90_0-1611773412695.png

 

And then when i run the flow , i get the following error:

Pedrogr90_1-1611773541470.png

 

I have tested the JSON in a test list and the formatting is applied correctly when the value changes, so i cannot really figure out what the problem is here.

 

Thank you in advance.

Categories:
I have the same question (1)
  • Pstork1 Profile Picture
    69,172 Most Valuable Professional on at

    I'm not sure that it matters, but I noticed that in some places you used double quotes and in others you used single quotes.  Flow tends to be fairly touchy about the use of double quotes in JSON.  Change FieldTypeKind and Choices to single quotes and try again.

  • Verified answer
    Pedrogr90 Profile Picture
    27 on at

    Solution:

     

    Seems that if you have double quotes, then in order for the single quotes inside to be recognized as such, I had to put a \ just before the single quote

     

    Source : https://techcommunity.microsoft.com/t5/sharepoint/json-column-formatting-with-flow/m-p/1491794

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 639

#2
Valantis Profile Picture

Valantis 392

#3
11manish Profile Picture

11manish 350

Last 30 days Overall leaderboard