I changed it to Text(Parent.Default,"[$-en-GB]dd/mm/yyyy","en-GB") and still got 5/2/2018, which I changed to another date to see what it would do, and the date in sharePoint wasn't the same. Hmmm no joy.
Sorry was a typo on my end with the 3 y's I did actually change it to 4
OK, I give up. In any case what I do in my work is not to use date or date/time columns at all and use either:
A) A text column where I place yyyy-mm-dd or yyyy-mm-dd hh:mm
B) An integer column where I place year*10000+month*100+day
I then parse back and forth in PowerApps. This resolves any time zone, server time, locale issues but is obviously a little more work, but not much.
Has anyone managed to resolve this? I have tried all of this and NOTHING WORKS.
Despite regional settings in Office, SharePoint and browsers all set to UK, the picker is still displaying in US format. It's confusing for my users.
Is there any way to remove the picker display text?
the following blog post has helped users in past threads with datetime picker display issues. I will include it below. If this does not solve your query, please let me know and I will investigate further.
The formula below works for me, showing dates in UK format, that would otherwise show in US format.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand