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'.

(0) ShareShare
ReportReport
Posted on by 9

Hi,

****
SOLVED
After messing around with my Metadata, and changing the values, the flow worked. The reason for the problem was because one of my metadata options had an apostrophe/single quote (') in the name. After removing that apostrophe from that option, the flow ran successfully. 
For example, when you upload a file, you could assign metadata to the file such as Mr Yellow's (which has an apostrophe/single quote). Then when you try to run the flow, it would not work. Once you change the option to Mr Yellows (which has no apostrophe/single quote), the flow runs.
****

This is my flow for automatically renaming PDF files based on metadata in Sharepoint.


The flow works for 3 out of the 5 PDF files in that folder. The other two have errors. The files are all PDF's.

dj1996_1-1660703057585.png


I keep getting this error:
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.
clientRequestId: be10c44d-c539-42df-b65a-a12d9e7cbad0
serviceRequestId: 99bc5ba0-4056-1000-8042-bab818ac4f7

I have no coding/JSON experience whatsoever. Could someone please tell me how to fix it, step-by-step?

Categories:
I have the same question (0)
  • Verified answer
    Mira Ghaly Profile Picture
    11,415 Moderator on at

    @dj1996 

    It looks to me like a data issue.. can you navigate through the items and paste the value for the body on the failed items? It can give a clue to what might the issue be.

     

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 552

#2
Valantis Profile Picture

Valantis 388

#3
11manish Profile Picture

11manish 375

Last 30 days Overall leaderboard