Skip to main content
Community site session details

Community site session details

Session Id : mrWltNRxdc++eVVJNmkzop
Power Apps - Microsoft Dataverse
Answered

Missing columns during mapping when importing data from excel

Like (1) ShareShare
ReportReport
Posted on 15 Dec 2021 20:34:00 by 8

Hi,

I am trying to "Get data from Excel" in the Power Apps website throught the Dataverse/Table page, but some columns are not visible during the mapping sequence. Here the sequence that I do (simplified version, but doesn't work either ways):

  1. Creation of a new Table with Document Number as primary field.
  2. Creation of a new column WBS Element
  3. Click on "Save Table" button
  4. Select "Get data from Excel"
  5. Upload the document
  6. Click on "Map columns" button

Result: In the left columns, the Document Number field is listed but not the WBS Element field, so it cannot be mapped to anything in the Excel file. I choose the "All columns" filter to be sure to not miss anything, but still doesn't show my WBS Element field.

 

Picture of the Table columns and the "map columns" view.

YannLS_1-1639600120763.pngYannLS_0-1639600059844.png

 

Am I missing any steps there or is it actually a bug in the interface?

Categories:
  • raravind Profile Picture
    12 on 27 May 2024 at 10:36:09
    Re: Missing columns during mapping when importing data from excel

    Hello ALL,

    am getting below error while clicking on import.

    Type=Microsoft.Dynamics.Integrator.Exceptions.IntegratorClientException, Msg=Unable to parse import file d2cadc879e974fa1b543e9bd2e8441f8.xlsx Error details PQOnline failure - Type=System.Net.WebException, Msg=The remote server returned an error: (400) Bad Request.

  • raravind Profile Picture
    12 on 27 May 2024 at 07:34:04
    Re: Missing columns during mapping when importing data from excel

    Hi ALL,

    I was able to create table with import data from excel outside my solution. It took default publisher. I then added that table to my solution but unable to update publisher.

    raravind_0-1716795225430.png

    Please suggest how to go forward

  • raravind Profile Picture
    12 on 27 May 2024 at 07:07:39
    Re: Missing columns during mapping when importing data from excel

    Hi ALL,

    I tried to log out and login for multiple times.

    Also excel has data for all coulmns still I dont see them

  • SR-30011133-0 Profile Picture
    on 11 Jan 2024 at 11:02:26
    Re: Missing columns during mapping when importing data from excel

    This fudge worked a treat for me so thank you - the Export failed (my table was empty anyway) but once I returned to the Import, my new table structure was reflected correctly.

     

    It seems a simple solution for Microsoft to refresh whatever data the Import is relying on when a table is amended in any way - critical for such a fundamental function such as a data import you'd have thought.

     

    At least the faux Export trick worked for me, so onwards and upwards...

  • SomeEmployee Profile Picture
    28 on 07 Jan 2024 at 16:12:38
    Re: Missing columns during mapping when importing data from excel

    I've add this problem in the past and had it once again yesterday. 

     

    First time i had it, playing around with creating a dummy row and possibly waiting around for some time worked.

     

    Second time, i threw multiple solutions at the wall, screamed a little bit and it worked...

     

    But yesterday, the issue was more persistent... Finally, exporting the current table with the missing columns in excel and then trying the import from excel again seems to have updated the import with the new columns!

     

    SomeEmployee_0-1704643898110.png

     

    If that doesnt work, perhaps doing the steps above but first marking the missing columns as required.

     

    You'll then be able to change them back to optional.

  • ElroyAirMed Profile Picture
    40 on 29 Jul 2023 at 04:48:43
    Re: Missing columns during mapping when importing data from excel

    Thiis^^^^^!!!!!!

    Microsoft needs to start refunding the license fees. It's not fit for purpose. It's a complete joke.

  • Baudelaire Profile Picture
    106 on 28 Jul 2023 at 18:22:18
    Re: Missing columns during mapping when importing data from excel

    I give up.  I've spent half of the day trying to get this to work.  I could have built 10 SQL Server databases and imported data from dozens of files in the amount of time I spent trying to import TWO columns from Excel into one new Dataverse table.  Columns don't show up, edit data in Excel and pasting 10 rows of data causes over 1000 table updates according to the plug-in.  This is insanity.  Importing data is database management 101, and every tool out there is simple and basically the same in my experience - (1) clean data, (2) identify source, (3) identify target, (4) map columns-->done.  But whoa!  Not this half baked piece of junk.  We have to clear out cache, sign out, reboot, go on holiday, take a sabbatical, etc. and it MIGHT work when you get back.  Microsoft is cramming Dataverse down our throats and selling premium licenses like crazy but they can't afford to get product developers who can make such simple utilities work.  FRUSTRATED.

  • SarahHope Profile Picture
    on 10 Jul 2023 at 12:06:15
    Re: Missing columns during mapping when importing data from excel

    Thank you @stevenhsi 

    I have saved this solution and will give it a try when I can get back to it.

    (-:

  • stevenhsi Profile Picture
    6 on 08 Jul 2023 at 00:18:15
    Re: Missing columns during mapping when importing data from excel

    Although this workaround may work for some people it seems like it doesn't work for others, so I would only consider this a partial solution.

    1. Go to the homescreen in make.powerapps.com

    2. In the second section of the left navigation bar, open Connections. If you can't see it, click on ". . . More" and select it from the flyout.

    3. Look for the Microsoft Dataverse connection and click on the ". . ." next to it.

    4. Select "Delete". It will give you a warning of any flows that use this connection. You can re-add it later.

    5. Once deleted, clear your cache/cookies/browsing data for the powerapps website and/or any other microsoft related website just to be safe.
    6. Open make.powerapps.com and go back to Connections, and add Microsoft Dataverse as a new connection. You can search in the top right for it to save you some scrolling time. Use your usual login and wait for it to reconnect.

    7. Wait a couple minutes.
    8. Go to the table that you want to Import From Excel to and try to do the import procedure again. You might get an error after uploading the file that the mapper is unavailable. This is a good thing, as it means that it is still processing the reconnection that you did in previous steps - if this happens give it a couple more mintues and try again.

    This step by step process worked for me and now the columns that I had added after the first import are now listed as mappable columns. 

    I hope this helps someone else, or at least some variation of it.

  • Community Power Platform Member Profile Picture
    on 09 May 2023 at 06:53:37
    Re: Missing columns during mapping when importing data from excel

    I think it cached on the first import attempt as mentioned by other users hence, it is important to create all the columns before using the import wizard. Subsequent adding or removing or columns is not expected to work.

     

    Abide by the following:

     

    1. Create a new table (with different name)
    2. Create all the columns before using the import wizard
    3. Use the import wizard (do not go back to create additional columns, it is not expected to work e.g., being able to reflect the new columns added)

     

     

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Featured topics

Loading started