Announcements
I am trying to flow an excel sheet into dataverse, but refreshing keeps failing. This seems to happen when the excel table is larger. This is the error I am getting, thanks.
@Anonymous , it seems that you have a date format issue. Make sure that the date(s) column(s) in your excel sheet have valid values.
The dates in my excel sheet seem perfectly fine. In the error it says the first date is 7/22/0221 but its not like that in the excel sheet. Also I have used the same data with less rows and it refreshes fine, I am not sure why that would be an issue.
@Anonymous , are you importing the date column into a number column in Dataverse?
I was trying to convert them into dates in the flow, but I just solved that issue by formatting the dates in excel. Now I have another formatting issue with entities being too long. Do you know how to fix this? Thanks.
@Anonymous , Increase the length from your Dataverse column properties.
Regards,AhmedIf my reply helped you, please give a 👍. And if it has solved your issue, please consider Accept it as the Solution to help other members in the community find it more.
Thank you that worked, but now I am getting this error. It seems to be in the first row and again that date looks correct in my excel sheet.
@Anonymous , Make sure that you Dataverse date column has these properties: (Highlighted in Yellow)
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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 93 Most Valuable Professional
Haque 81
Valantis 49
