Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Error displaying dates from an Excel table

(0) ShareShare
ReportReport
Posted on by

I have a gallery and a form connected to an Excel table, but I'm experiencing an issue when trying to display dates added to the Excel table from the form. The form does add the dates to the Excel table, but then in PowerApps, the added dates are not visible. However, dates that I manually enter into the Excel table are visible in the gallery. I couldn't find any difference in format between the dates added from PowerApps and those added manually to the Excel table.


Error Says: is expected to have a valid date and time format in accordance with RFC 3339. ISO 8601 formats are allowed
 

If someone has experienced this error and knows how to solve it, I would appreciate your help.

 

Thanks in advance!
 

Categories:

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard