Unable to import CSV file

[FabianaRR]

Hello,

I am on module 16 of the Microsoft Power Up program to build a model-driven up and cannot import .csv files. When I select the option Import .csv the window for importing files does not open. Anyone encountering the same issue and/or ideas to solve it?

Thanks and regards,

Fabiana 

[alexcallaghan91]

Credit to this post: Solved: Re: Issue with importing the maintenance file csv - Power Platform Community (microsoft.com)

The date format in the CSV is in US, but we were shown how to change it to UK. You need to change the date format in Personalisation Settings back to English (United States) and then the import should work. You should have 6 successes and 1 failure, as there's a deliberate error in there as part of the lesson.

Hope this helps!

[FabianaRR]

Thank you for the suggestion, but I am in English (US) already... The problem I face is that the window for importing does not even pop up; I click Import .csv from the menu but no window opens, so I do not even have the option to search for the file. The same happens when I try to import excel...

[Nirav237]

Hi @FabianaRR 

Can you please share some screen shot of the error or issue which you are facing, It will be very helpful.



Regards,
Nirav J Raval

[FabianaRR]

Hi,

The issue is solved. I forgot to actually Play (click the button) the app...

Now the issue is that all 7 records give error...

Thanks for your support.

Regards,

Fabiana

[Javiavan2]

I am encountering the same problem. 7 errors. Attached image.

[TechPrince]

Hi, were you able to resolve this error after the import?

[BCBuizer]

Hi All,

Just a few things to look after when doing this exercise:

1. Import method: As mentioned in the video, there are multiple ways to import data. The one that is being demonstrated is when playing the app. When trying to import via the solutino explorer I ran into an issue where the MaintenanceLogName column gave an error since it is a required field, but it is an autonumber field, meaning a value can´t be provided. Also the mapping had to be done mostly manually. These are all not an issue when importing via the app.

2. File extension: With the course resources there are two similar files available MaintenanceLogs.csv and MaintenanceLogs.xlsx. Use the first one. Although the data looks the same, the files are structured differently which may cause issues.

3. Date formatting: The data in the file is formatted as mm/dd/yyyy, which is the data formatting for English (United States). During and earlier video you may have changed the language settings to English (United Kingdom), which means you have to change this back or else the values are not recognised as valid.

4. LookUp values: Some of the values for the Service Area column may not exist in your Service Areas table which will make the LookUp fail. To prevent this, make sure the following areas are in your Service Areas table: Plumbing, Electrical, Cleaning, Building, Carpentry.

[TechPrince]

How do i achieve the below

To prevent this, make sure the following areas are in your Service Areas table: Plumbing, Electrical, Cleaning, Building, Carpentry.

[BCBuizer]

Hi @TechPrince ,

Simply add the mentioned rows to the Service Areas table, for instance by navigating to the table in the Solution explorer and clicking the +New button at the top ribbon to add any missing rows: