Announcements
Hi,
This's a leave application app. User need to fille in leave date and time, and new created item should be updated in Excel source file as well. What I did now is adding date picker and text input to fill in date and hour and minute, but I don't know how to make this vaule updated in Excel. Can anyone help? Thanks.
Good morning, are you implementing a patch function?
Hi @YanLiang ,
The two data time columns seem to be Text type columns. It would be better to use a date time column in Excel:
In PowerApps, you can enable ISO 8601 date format in settings:
Then in the Edit form, when add the two fields into the form, the controls would be automatically inserted:
Best regards,
@v-jefferni
I don't have this feature setting. I have updated the format in Excel, but still doesn't work.
It's on the menu bar:
and again, you will need to delete and add the connection.
@v-jefferni Hi, I deleted the connection and re-connected but still doesn't work.
The form needs to be re-added as well.
@v-jefferni both form and connection are re-added, ISO 8601 is enable as well. Still doesn't show date time format in the Form.
What format is the column of Excel table now?
@v-jefferni HI， format is showed below.
They seems more like to be Text column than Date and time column, don't they?
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 339 Super User 2026 Season 2
M Bilal Khan 289
Mohsin Ali 228
