I have an app that allows reporting data to be displayed from and added to a SharePoint list. It includes several fields where the data is financial. I am in UK and want to display currency in pounds, symbol £
I was using
and it seemed to be working everywhere.
Not having used the app myself for some time, I revisited it this week and found all the currency fields displaying with $, not £
Some of the fields I solved the problem by switching to using
but other fields displayed nothing if I used that statement. For those fields I reverted to using
They display OK again but with $, not £
I have checked all the settings on both SharePoint and in the Power App and can see no difference between the fields that work correctly and those that don't. The data is coming from different columns but the same list to different fields but the same form.
Can anyone recommend a bomb proof formatting statement or suggest what might be different about these fields or data?
I am used to regional differences popping up and having to be fixed in about six different places to work for all users in all environments on all devices. But I haven't before seen regional differences between two, apparently identical fields on one form, in one application, on one device, in one environment