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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 819 Most Valuable Professional
Michael E. Gernaey 308 Super User 2025 Season 2
MS.Ragavendar 222 Super User 2025 Season 2
