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 Apps / JSON parsing error exp...
Power Apps
Unanswered

JSON parsing error expected string but got number

(0) ShareShare
ReportReport
Posted on by

Hello, I have a problem with a column from my SQL Table.

 

I use money as data type in SQL but when i want to show this column in powerapps through the SQL connector a message appears and says JSON parsing error, expected string but got number

I tried to collect my SQL table in a powerapps collection but my money data type column show "?"

None of my rows bring the correct data, only appear a "?" . Is there a solution that does not involve modifying my SQL table?

 

Thanks!

Captura de pantalla 2024-03-13 164759.png
Categories:
I have the same question (0)
  • stum Profile Picture
    144 on at

    Hi,

     

    Power Apps uses Currency as data type. If you are getting that error, you can try this by creating a formula field:

    Text(Value(Fieldname),"[$-en-US],$#,###.00")

     

  • OA-24071858-0 Profile Picture
    on at

    i tried it but didn't solve the problem. I think the problem is between powerapps and my sql table. I will try to change the data type in sql.

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 Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard