Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Error importing multiple choice columns along with single choice columns

I'm trying to import a list from sharepoint to Dataverse, this list has 5 multiple choice fields and two single choice fields, if I run powerquery only with multiple choice columns it works very well, importing all data from each column , the same is true for single-choice columns. my problem starts when I put the Status column (single choice columns) to import along with the multiple choice columns, always when selecting this column along with any multiple choice column generates several errors in the multiple choice columns.


Oportunidades,5b85c33b-17e6-47b7-b1be-560f7310a807,,"Table cr6ae_Oportunidades field cr6ae_habilitacaoeconomicafinanceira is a cr6ae_oportunidades_cr6ae_habilitacaoeconomicafinanceira Choice data type. The value 415060000,415060001,415060002,415060003,415060007 is not a valid value for the cr6ae_habilitacaoeconomicafinanceira choice field."


Remembering that the above error does not occur if I do not import the STATUS column, and the STATUS column does not generate any error if imported without the other multiple choice columns.


NOTE: my STATUS column has 5 options, all of them were replaced by the corresponding numbers from the dataverse table column



Helpful resources

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,587)