web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / PowerApps pulls random...
Power Apps
Unanswered

PowerApps pulls random date in display form for only one User

(0) ShareShare
ReportReport
Posted on by 91

 

The Image below shows a display field screen shot from ONE specific user (We have 30 others for whom the issue dies not occur).  as you can see the date show is a totally random date and NOT the Parent.Default for the item on display as is shown for everyone else.

 

The dates shown for this user do not and are not anywhere in the items or the system at all.  This causes a significant issue as I have 4 HTML fields in another screen which reference this date field value and which are then used in a workflow to generate a PDF certificate of the activity which is supplier externally to customers and also a third party for verification.  Obviously if the date is wrong then the cert if no use, and we end up having to get someone else to do the pdf then this user does their bit, which adds time and cost to a process for which this APP is designed to remove.

 

Has anyone else seen this or can anyone perhaps shed any light on what may be causing this problem and how to eradicate it.

Power App date field issue.png

Categories:
I have the same question (0)
  • timl Profile Picture
    36,383 Super User 2025 Season 2 on at

    @hyperbob0811 

    This is possibly a localisation issue that's caused by the language setting of the device/browser, particularly if the date is stored as a text value in the underlying data source.

    Can you confirm the data source, and whether the data type of the column is a date field?

    Also, it might be useful to paste the formula that you use to display Test Date. I guess you're formatting that with the Text function?

  • hyperbob0811 Profile Picture
    91 on at

    @timl  here is the formula

     

    Text(DateValue(Parent.Default,"en"),"[$-en-GB]dd / mmmm / yyyy")

     

    This is fine for literally everyone else who uses the app, apart from one person, and its causing a massive issue

  • dw909 Profile Picture
    49 on at

    Did you resolve the issue at all? I have same problem - effectively some of our users have multiple languages in their Chrome Browser:

    dw909_1-1695732667344.png

    With it set like this it ignores all the language protections I've put in place in the app - including a variable which detects the browser language on app startup and if it's not en-GB then it sets their language to be US English.  I've even got additional settings for the form date picker fields.

    Despite this users with Chrome and multiple languages don't just get the date pulled from SharePoint in a different format...but it's actually giving completely random future dates that don't corollate to the shared date, nor even the current date. This is far from ideal because whilst on a case by case basis I can ask people to use workarounds like a different browser or kindly removing languages and resetting chrome, clearly I can't make that commonly understood across a large organisation - and where review dates are being set in the app, it's doing to be overriding with nonsense dates when people submit a form. 

     

    Here's what I have in my App OnStart property:

    If(Language() = "en-GB", Set(varLangFormat, "[$-en-GB]dd/mm/yyyy"), Set(varLangFormat,"[$-en-US]mm/dd/yyyy"));

     

    In DatePicker dropdowns in galleries I have  Language also set to:

    If(Language() = "en-GB", "en-GB", "en-US") 

     

    And in the properties of a Form's date picker DefaultDate for example:

    If(
    MyForm.Mode=FormMode.Edit,
    Text(Today(),varLangFormat),
    Text(Parent.Default,varLangFormat)
    )

     

    The problem has been flagged to me specifically in the Form that's using the above DefaultDate syntax....

     

    Appreciate if anyone has advice how to overcome this. Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard