Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Building Power Apps / Date Value in Excel an...
Power Apps - Building Power Apps
Unanswered

Date Value in Excel and Powerapps are different

(0) ShareShare
ReportReport
Posted on by firda59 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:
Connecting to Data
Dataflows
General Questions
Using Apps Using Formulas
Connectors
  • v-mengmli-msft Profile Picture
    v-mengmli-msft on at
    Re: Date Value in Excel and Powerapps are different

    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

  • firda59 Profile Picture
    firda59 372 on at
    Re: Date Value in Excel and Powerapps are different

    @v-mengmli-msft 

     

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

  • v-mengmli-msft Profile Picture
    v-mengmli-msft on at
    Re: Date Value in Excel and Powerapps are different

    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

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

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans