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.
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.
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.
@jgiemza , Increase the length from your Dataverse column properties.
If 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.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.