Unanswered

Import Excel Yes/No to Dataverse Table

(0) Share

Report

Posted on by RJF61

1,265

I have an Excel sheet with a column containing either "Yes" or "No". When importing (to a Yes/No Choice field), it appears this is creating an error. Is there something I need to do to the Excel sheet values?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

steeevid 323 Super User 2024 Season 1 on at

Like (0)

Report

Go to the table you want to import data to, click open in excel
You can then see how data are structured in excel view, for example, Yes/No field are stored as TRUE / FALSE, use this format to translate your data, and then paste them to the excel sheet you just downloaded (the sheet you download here has a dynamic link to dataverse so you can manipulate directly)

Remember to use "publish" button on the right hand side panel to publish your data to dataverse

Was this reply helpful? Yes No
Verified answer

steeevid 323 Super User 2024 Season 1 on at

Like (0)

Report

I just answered this questions with a detailed work through for how to solve it, I don't know what's going on maybe someone just deleted my post

Basically go to the page of your table, click edit in excel, and you can see how Yes No field are stored, they should be "TRUE / FALSE"

Was this reply helpful? Yes No
RJF61 1,265 on at

Like (0)

Report

@Stevieed Thanks for the response. I have changed and all worked fine...Thank You

Was this reply helpful? Yes No