Unanswered

Import Boolean values from excel

(0) Share

Report

Posted on by ctedesco3307

690

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 with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Devvj 1,132 Super User 2024 Season 1 on at

Like (0)

Report

Hi @ctedesco3307

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

Was this reply helpful? Yes No
Verified answer

ctedesco3307 690 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No