Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
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?

  • Verified answer
    Mira Ghaly Profile Picture
    11,409 Super User 2025 Season 1 on at
    Re: Invalid JSON. A comma character ',' was expected in scope 'Object'.

    @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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,651 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow