You’re offline. This is a read only version of the page.
Announcements
Share
ReportHi!
I have a flow connected to power apps.
The flow consists of extracting data from excel, going through a json schema and returning a collect to the application.
The problem is in the currency format of the "Purchase Value" field.
While in the Excel spreadsheet I have the value "R$ 11,22", the Json returns the value "1.122,00".
I've already tried changing the format in the app using a standard text format for coins. But it did not work.
I believe I have to fix it in the Json schema itself. But I don't know how to do it.
Does anyone have an idea how to resolve?
My Excel is regional Brazil.
Scheme:
"Provider": {
"type": "string"
🇧🇷
"Purchase Value": {
"type": "string"
🇧🇷
"REQ": {
"type": "string"
Thanks!!! 
Hi @EduardoTranspet ,
The reason is that for flow, there is no currency data type. I suggest you use the float function to convert the currency string back to a number for use.
I think this link will help you a lot:
Best Regards,
Bof
All responses (
Answers (
522
