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!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard