cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
achubutkin
Frequent Visitor

Import from Excel file (*.xlsx) in model-driven app is not working

I have trying import data from environments and identical solutions. Our tables are absolutely identical. I using Export/Import to/from Excel (*.xlsx). After import, my receiver table still empty and track progress has the next information: 

successes - 0, errors - 0, total processed - 0. 

 

achubutkin_0-1624883375888.png

 

If I using CSV format then all data is imported successfully. Is this a problem with the import from Excel in a model-driven app?

 

 

4 REPLIES 4
BrianS
Super User
Super User

We will need a little more information on how you are importing/exporting from Excel. Generally Excel is not the best place to store data. SharePoint or Dataverse are preferable no-cost options.

Hello, @BrianS Thank you for your answer! 

 

So, step-by-step guide (How to export data and import it back through Excel): 

1. Launch a model-driven app. 

2. Select one or more rows in your default view and then click on the "Export to Excel" button and save the Excel file.

3. Remove all data from your default view (it means your table).

4. Then click on the "Import from Excel" button and select the Excel file with data. Check to correct mapping.

5. Track progress until complete.

 

Expected Result: imported data or error information (in track progress log).

Current Result: no imported data, no error information (in track progress log).

PetarHr
Advocate I
Advocate I

Maybe I'm a bit late to post here, but there are hidden columns in the beginning of the exported excel file. Deleting the information there helped in my case to import the data.

Hi @PetarHr ! Yes, we have already solved this case. The problem was in the hidden columns. Thank you! 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,223)