cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaishanker
Regular Visitor

Problem Regarding CSV Import

I am unable to import csv file into a table to create an entity. The platform shows that it has successfully completed it, but the table is empty. Also when I tried using Azure blob to import the csv files, the container was considered a csv file and all the directories were listed as rows of a csv file.

7 REPLIES 7
jacknutkins
Regular Visitor

Hi jaishanker, 

 

Are you using the standard data import functionality via Advacned Settings -> Data Management? Dataflows? Or something else?

 

We'd need to see the output to provide further insight, and this will depend on the approach you took to import.

 

Are you trying to create an entity via the import itself, which is possible, or does the target table already exist?

 

Thanks,

 

J

I tried the standard methodology via advanced settings but that failed as well. I tried to import the CSV file directly, without the target table and no data was imported.

jacknutkins
Regular Visitor

If you've used the standard import functionality then there should be a log of the import - does this indicate that you've successfully imported a number of rows, or were there errors present? There might be a number of different errors but this is where to start. 

 

You can access this from the same area in Advanced Settings -> Data Management -> Imports 

Is there any other way to upload a csv file. My main purpose is to run an AI builder model but i cant do it unless my data is imported

Prakash4691
Super User
Super User

Hi @jaishanker ,

 

You can try import csv using OOB import feature.

 

There you have to select target table or record types to import data. If not you can create new table.

 

Then you can map fields according to the right data type.

 

 

Regards,

Prakash

If you are using classic settings import utility, be aware that different formats work differently. try xls format saved in xml spreadsheet 2003 format. It works best.

 

Hi @jaishanker

You can also try the (fairly new) Power Apps Office add-in. I find it works quite nicely: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-excel-addin

Hope this helps...

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,839)