Hi, I have an issue with an import from Excel to CDS. My import fail because of some blanck culumns.
My CDS destination table has a culumn named Classification and can "A";"B" or "C" (option list). And can be blanck (not an obligation).
If I want to import lines from Excel, I have and error with lines where this value is blank.
How could I avoid this error ?
this is the error message:
thank you in advance,
If you use the data import wizard, these errors won't occur. It will even let you decide what you want to do with blank values, like ignore them.
The data import wizard is found by clicking the gear in the top right of make.powerapps.com then clicking admin center. In the admin center, select your environment and click settings. From the settings page select Data Management then Data Import Wizard. Then click Import Data along the top.
This will start the wizard. Your CDS destination needs to be prepared first (sounds like you already did this) and your excel file needs to be saved as CSV. The rest is pretty easy to follow, let me know if you have any issues!
Please hit the "Accept as Solution" button if my post answered your question! If my post was helpful please consider giving it a "Thumbs Up."
Hi @Kesh ,
Based on the error message that you mentioned, it seems to tell that there is something wrong with the value provided for the Classification field when importing data from Excel to CDS Entity. I think this issue is not related to Blank values.
If you defined the Classification field as "Option Set" type column in your CDS Entity, when you provide value for this column, you could only choose value from the available options -- "A";"B" or "C" or Blank. You could not provide a custom value (not list under the available options) for the Classification field.
Please check if the values from your Excel table you want to provide for the Classification field is within the available options ("A";"B" or "C"). As an alternative solution, you could consider set up normal Text type column to store the values from your Excel table instead of Option Set Type column.
The Super User program for 2022 - Season 2 has kicked off!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.