web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps JSON parsing error exp...

Power Apps

Unanswered

JSON parsing error expected string but got number

(0) Share

Report

Report

Posted on by OA-24071858-0

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:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

stum 144 on at

Like (0)

Report
Copy link

Link copied!
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")

Was this reply helpful? Yes No
OA-24071858-0 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No

Join the conversation