web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Error importing multip...
Power Apps
Unanswered

Error importing multiple choice columns along with single choice columns

(2) ShareShare
ReportReport
Posted on by 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

 

I have the same question (0)
  • ay26274 Profile Picture
    16 on at
     
    Were you able to find a solution for this issue?
    I realize this is an older post, but I encountered the same problem yesterday and feel stuck.
    I’d really appreciate it if you could share any solution that can be implemented within a single dataflow, rather than needing separate dataflows for Single Choice and Multiple-Choice Columns.

    Thanks so much in Advance!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard