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

Notifications

Announcements

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dataverse Date only co...
Power Apps
Unanswered

Dataverse Date only column is shown as Datetime in PowerApp

(0) ShareShare
ReportReport
Posted on by Random1232 32

I have a Dataverse column 'ETA' which is Date only.

Random1232_0-1701076614796.png

I'm using this Table in PowerApp. When I add ETA field, it is shown as Datetime instead of Date only.

 

Random1232_1-1701076725144.png

Column was created as Date only from the beginning so there is no question of refresh. I haven't changed column settings after its creation. 

 

How should I convert this to Date only? I have 6 such fields in one screen and 2 screens in total (so 12 Date only fields)

Categories:
Building Power Apps
I have the same question (0)
  • Verified answer
    v-mengmli-msft Profile Picture
    v-mengmli-msft on at

    Hi @Random1232 ,

     

    If you don't want to show them, you can set the Visible of them to false.

    vmengmlimsft_1-1701078038372.png

     

     

     

    Best regards,

    Rimmon

     

  • Random1232 Profile Picture
    Random1232 32 on at

    Thank you for the response!

     

    Yes, I can. But I have manage visibility for 3 components (hour, minute, colon) and change the size for the date field. That's four actions per card.

     

    I know I sound lazy, but this is not the only power app I'll be facing issue. Shouldn't this be an automatic thing? or is there a setting to turn this card to Date Only? 

  • v-mengmli-msft Profile Picture
    v-mengmli-msft on at

    Hi @Random1232 ,

     

    As far as I can tell, this is not an automatic thing.

    The time stored in Dataverse, even if it is of a date-only type, includes the default hours and minutes of 0.

    I'm sure you've discovered this when you're using data sources in PowerApps.

    That's why I'm suggesting you set the Visible property instead of removing Time directly, because even if the type of the time column is a date-only type, the column value must be in "date + time" form. This is different from SP list, so this results in a time being automatically created when the date-only column is added in the form.

     

    Best regards,

    Rimmon

  • Random1232 Profile Picture
    Random1232 32 on at

    Thanks for your help Rimmon! 

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

Welcome to the Power Platform Communities
Season of Giving Solutions is Here!
Explore Copilot Studio Forums, Blogs & Galleries!

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…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

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

Featured topics

Auto-Populate field Power Pages
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
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans