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
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:
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.
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.
Hi, were you able to resolve this error after the import?
I am encountering the same problem. 7 errors. Attached image.
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
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
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...
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.