Power Platform Community Forum Thread Details

Hello,

I would like to create a date field in a Power Apps.
This will allow me to update a date in an Excel file.
I would like to be able to see the date when it is already filled in or added.
And I would like the date to be in yyyy-mm-dd format.

Can anyone help me?

Categories:

Connecting to Data

General Questions

Using Apps Using Formulas

AI Builder

Mobile App

Employee Ideas app on Teams

Hi,

To create and manage a date field in Power Apps that updates an Excel file and displays dates in the "yyyy-mm-dd" format, you can use the Date Picker control:

Insert a Date Picker control onto your canvas app.
Customize the display format by using a Label control with Text(DatePicker1.SelectedDate, "yyyy-mm-dd").
To show an existing date, set the Date Picker's DefaultDate property to the date from Excel.
To update a date in Excel, use the Patch function with the appropriate table and column names in the OnSelect event of a button.

For more detailed support, book a consultation call with me here:
Consultation: https://softwarezone365.com/contact-us
PowerApps Blogs: https://softwarezone365.com/power-apps

Should you appreciate my assistance and wish to support my work, you might consider:
Giving this post a Thumbs Up.
If applicable, marking it as the Solution.

Support my work:
PayPal: https://www.paypal.com/donate/?hosted_button_id=DASYHQAEETD2J

Contact directly:
Email: Contact@SoftwareZone365.com
WhatsApp: https://wa.me/+923087478066

Best regards,
Ahmad Raza