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 / Date Value in Excel an...
Power Apps
Unanswered

Date Value in Excel and Powerapps are different

(0) ShareShare
ReportReport
Posted on by 372

Hi, 

 

I have this column in excel:

firda59_0-1690263785144.png

 

I want to show the date in my apps. But, it going to be wrong date.

firda59_1-1690263879722.png

 

Does anyone know how to fix it? Thankyou.

Categories:
I have the same question (0)
  • v-mengmli-msft Profile Picture
    on at

    Hi @firda59 ,

     

    The correct result shown in my test means that your statement should be fine, and perhaps you can check which data ThisItem.Target refers to.

    vmengmlimsft_0-1690365119102.png

     

     

    I suggest you create a separate Label control to display it to check if it is the value you need.

     

    Best regards,

    Rimmon Li

  • firda59 Profile Picture
    372 on at

    @v-mengmli-msft 

     

    I dont understand, it still error, the date still different😔

  • v-mengmli-msft Profile Picture
    on at

    Hi @firda59 ,

     

    If you have such data in your data source:01-Jul-77, it is possible that ThisItem indicates the table where the data is located instead of the table where the Target column you want to be located. So you can check the Item property of the Form to check if it is the table where the Target column is located.

    vmengmlimsft_0-1690451557625.png

     

    Best regards,

    Rimmon Li

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