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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Data validation errors...
Power Apps
Suggested Answer

Data validation errors when importing Excel file

(0) ShareShare
ReportReport
Posted on by therufus 45
I'm having an issue importing data into the dataverse from an Excel spreadsheet.
 
As you can see from the screenshot, it seems that anything that wouldn't be valid if we were using US dates is failing. With that said, every setting in our system, including my browser, is all set to English (Australia). How can I get rid of all validation based on the backwards American dates so that I can import the data?
 

Categories:
Microsoft Dataverse with Power Apps
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 53,978 Moderator on at
     
    So the problem is its backwards, meaning your MM and DD are being seen as DD and MM respectively so right now (ISO issues), so can you verify in dataverse
     
    1. What is the Columns Date setting (local?)
    2. Can you please verify what Language it is for the Database instance?
    3. So the ones that get over 12 (aka months but for you days) will fail as it thinks you are trying to tell it there are 13+ months
    4. Verify what language was used when you built dataverse (which is like #1)  but hopefully you remember :-)
    5. Use a dataflow instead and use a Transform to fix the date instead of a direct Import
     
    So either fix Excel to store them properly (which you can) and is the easiest depending
     
    or verify what you have for the back end one of them is incorrect
     

    If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.

    Thank you!
    Sincerely, Michael Gernaey
  • therufus Profile Picture
    therufus 45 on at
    Hey Michael.
     
    1. Columns date setting is locked to Date and Time. I tried to change it to date only just to test it out, but it doesn't let me update it. This is true for all date columns affected.
    2. By the database, I'm assuming you mean the Microsoft Dataverse I'm trying to import it into. I've looked through every setting in the admin portal and any time language is mentioned, it's set to English (Australia). If you're able to point me to a specific setting, I can check.
    3. I figured that was the problem. My issue is that I can't input this data because it seems to be forced into US mode.
    4. I didn't build the system. I'm merely maintaining it. And the specific people who built it are long gone from our partner who created the instance.
    5. This is a good suggestion, but I still need to create the table to link to the dataflow.
     
    Surely since over 90% of the world don't live in the US, someone has worked out how to use non-US dates when importing an Excel sheet?

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

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 1,055

#2
Valantis Profile Picture

Valantis 666

#2
11manish Profile Picture

11manish 666

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