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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Why does Select put ba...
Power Automate
Unanswered

Why does Select put back slashes into json result?

(0) ShareShare
ReportReport
Posted on by 296

Good Morning

 

I'm trying to set up a flow where people registering for an event are added to the event. The flow keeps failing because it doesn't like the schema. 

 

So while the schema in Select is {"address":"@{item()}"} - the output for Select is:

 {
    "emailAddress""{\"address\":\
 
And I don't know where these backslashes come from, it's not as if there's any spaces to replace. And how do I get rid of them?
 
Anybody any idea?
 
Thanks, 
Christine

 

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    68,717 Most Valuable Professional on at

    Can you provide a screenshot? The slashes you are seeing are escape characters that result from JSON being rendered as a string instead of JSON.

  • Amapola188 Profile Picture
    296 on at

    That's good to know!

     

    Amapola188_2-1708980824728.png

    Input into Select looks okay:

    Amapola188_3-1708981660833.png

    Thank you!

  • Pstork1 Profile Picture
    68,717 Most Valuable Professional on at

    The data mapping you are doing in the Select will be seen as a string, not a JSON record.  That's why you are getting escape characters.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard