I've got a Sharepoint List which calculates values and is formated for EUR currency. The calculation is the following:
=If(Flat="Flat1";130+(79,77*Days);70+(47,862*Days)+(Towels*22))
In the sharepoint list the calculation is working perfect.
In PowerApps I use the values from the SharePoint list for further calculation. First I sum up all values from the SharePoint list and use a filter to exclude some Values:
Text(Sum(Filter(SPList,Flat.Value<>"Flat2"),Calculated),"####,##")
PowerApp in the browser shows the correct value:
But in the mobile PowerApp on iOS it shows this:
Can you please check!
Cheers,
Sebastian
iOS is very picky about conversions. It needs ALL the details it can in order to perform them properly.
Make sure you are specifying your region code in the conversion functions...like Text. I don't see any in your formulas.
Also consider that you have a Days in your formula. Days is a reserved word in PowerApps. If your formula is not directly referring to something that has a Days column in it, it might be assuming Days as the reserved keyword.
I hope this is helpful for you.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
199 | |
72 | |
51 | |
42 | |
30 |
User | Count |
---|---|
268 | |
121 | |
94 | |
90 | |
81 |