Announcements
Hi All- I'm trying to import data from excel to my Dataverse table - the table has alot of Yes No choice columns. The excel file is getting rejected because the Y N values in the excel don't load to the boolean choice columns. Any ideas on how to make this work? Thanks in advance!
Hi @ctedesco3307
If im not mistaken the values should be "Yes"/"No" in the excelsheet, 0/1 or y/n wont work i think.
@Devvj - Thanks for the reply! TRUE / FALSE actually was what I needed - I also had some choice values columns in there I needed to replace the choices with the choice values on. Once I did that it loaded successfully. I created 2 dummy rows and did an export to see what the Yes / No values were - that's how I got the TRUE FALSE! (should have just done that from the beginning ... right ....) - 🙂 Thx again.
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 397 Super User 2026 Season 2
Mohsin Ali 354
WarrenBelz 232 Most Valuable Professional
