Import Boolean values from excel

Like (0) Share

Report

Posted on 2 Jan 2024 20:51:31 by ctedesco3307

623

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!

Categories:

Microsoft Dataverse

Tables

Entities

All responses (2)

Answers (1)

Verified answer

ctedesco3307 623 on 03 Jan 2024 at 14:37:05

Like (0)

Report

Re: Import Boolean values from excel

@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.
Devvj 1,127 Super User 2024 Season 1 on 02 Jan 2024 at 21:14:49

Like (0)

Report

Re: Import Boolean values from excel

Hi @ctedesco3307

If im not mistaken the values should be "Yes"/"No" in the excelsheet, 0/1 or y/n wont work i think.