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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / User in Different Coun...
Power Apps
Unanswered

User in Different Country Not Collecting Correct Date

(0) ShareShare
ReportReport
Posted on by 57

Hello,

 

My App has been published for about a Month now and is being used both by our American team and our India Team. 

The first page where data is entered has a hidden text box that uses the formula

 

 

(Text(Today(), "[$-en-US]mm/dd/yyyy"))

 

 

This along with data entered is sent to a collection which is "reviewed" on the next page and then edited or submitted into a sharepoint list. 

 

This works fine with every user except one. There is one user on our India Team that has entered data about 8 times in the last month and the first 4 times the date should have read 5/7/2020, but read 7/5/2020. The next 4 times the date should have read 5/21/2020, but read 10/15/2021. 

 

I honestly don't even know how to troubleshoot this.  There are probably a total of 20 team members and there is only one problem with the dates. 

 

Any advice anyone could give me would be great. 

Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    152,843 Most Valuable Professional on at
    Re: User in Different Country Not Collecting Correct Date

    Hi @jbaggett ,

    You need the TimeZoneOffset function, which returns the user's difference to UTC. Allowing for this, you can write the value back to the data source correct for the area. 

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • WarrenBelz Profile Picture
    152,843 Most Valuable Professional on at
    Re: User in Different Country Not Collecting Correct Date

    Hi @jbaggett ,

    Just checking if you got the result you were looking for on this thread. Happy to help further if not.

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • WarrenBelz Profile Picture
    152,843 Most Valuable Professional on at
    Re: User in Different Country Not Collecting Correct Date

    Hi @jbaggett ,

    I am following up this post to see if it can be closed if you obtained the result you were looking for.

    Please click Accept as solution if my post helped you solve your issue as this will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

  • jbaggett Profile Picture
    57 on at
    Re: User in Different Country Not Collecting Correct Date

    Hello,

     

    I apologize for the delay. I have been pulled away from this project for a different one at the moment and have no had a chance to test this out BUT the same user has input quite a bit more data since this incident and the dates are all correct. I'm not sure how the original error happened since the date is a hidden field and is automatic. 

     

    Thank you for your response and I think it would be ok if we closed this post. 

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 836 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 231 Super User 2025 Season 2

Last 30 days Overall leaderboard