Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Pounds £ and Dollars $

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


Any help gratefully received.  Thank you




Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,010)