Skip to main content
Community site session details

Community site session details

Session Id : LaqfG5sYS8Mc5/OaMsEXHf
Power Automate - Using Flows
Unanswered

SharePoint Flows Character Errors for Lists

Like (0) ShareShare
ReportReport
Posted on 26 May 2021 12:07:20 by

In SharePoint OL, when using measurement in a data column, SP generates 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: d046ca5d-0a2d-4607-ac6e-fc0fd825c342 serviceRequestId: 1811cb9f-40b7-0000-b733-9965c9c866ab"

 

What seems to causing this is in the data column, I have this text:  El 63'-6" Floor Plan   When I replace the text to:  El 63'-6 Floor Plan   this is without the " (Quotation Mark) representing inches, it works as designed.  Does anyone have a work around for this?

  • abm abm Profile Picture
    32,506 Most Valuable Professional on 26 May 2021 at 22:17:30
    Re: SharePoint Flows Character Errors for Lists

    Hi @Anonymous 

     

    Please have a look at this article.

     

    Handling apostrophes in a Flow (sharepains.com)

     

    Thanks

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Featured topics

Restore a deleted flow
Loading complete