Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Unable to upload new columns to Dataverse table using DataFlow

Thank you for taking the time to read my question.   I'm using an existing Dataflow that loads an Excel sheet into a Dataverse Table. It works great. I have added two new columns to my Excel sheet ...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Syndicate_Admin ,

 

According to the screenshots you provided,I think  your Number type column must have a value "CAY1A"

 

 

As I tested below:

 

You could remove error rows, or use try ...catch... to fix the error:

 

 

For more details about error handling, please refer to:

M Language Error Handling - PowerQuery M | Microsoft Docs

IFERROR in Power Query Using TRY OTHERWISE

 

 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    Hi @Syndicate_Admin 

     

    Thank you so much for your reply. You are Right!!!

     

    The person that made the Excel file I'm trying to upload swapped the column headers... and I didn't realize. 

     

    Thank you so so much.

     

    happy holidays