You’re offline. This is a read only version of the page.
4
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
#1
WarrenBelz
791
Most Valuable Professional
#2
MS.Ragavendar
410
#3
mmbr1606
275
Super User 2025 Season 1
Share
Report
All responses (
Answers (
