Hello, I am unable to import more locations using the import file in the resources. I am getting attached error. I have used the resource " Additional Location" file provided under resources.
Solved! Go to Solution.
Hi @HeenaS ,
In this topic you can find multiple possible reasons and their fix that may cause issues when importing data: Solved: Re: Issue with Importing CSV file - 3 rows missing - Power Platform Community (microsoft.com...
Hi @Ignacio-G ,
Depending on your machine language settings, converting to .csv may save the file with semicolons as separators instead of commas. As I can see from your screenshot this is the case for you:
This can be fixed by editing the file in Notepad and replacing all semicolons with commas.
Alternatively you can download the .csv file from the course resources since that is already set up to work.
Hi @HeenaS ,
In this topic you can find multiple possible reasons and their fix that may cause issues when importing data: Solved: Re: Issue with Importing CSV file - 3 rows missing - Power Platform Community (microsoft.com...
Hi @BCBuizer
The link you have provided refers to importing Maintenance Log, rather than to importing Addition Location. I am having the same error as HeenaS.
Could you please shed some light on this please?
Many thanks
Hi both, I saved the file as csv and it worked. Thanks!
Hello everyone!
I have exactly the same problem and I don't think the solution is to change the extension of the file since in this section another way of importing is being given, that is, it is showing how to import a file in excel, in csv it has already been tried in the first part of the video.
Furthermore, when changing the extension from xlsx to csv it does not recognize the different columns, it understands that there is only one column and when importing it what I show in the image happens and I do not think that the solution to this is to go record by record fixing it because then There is no point in importing.
So how can we solve the error that we are getting by following the course when importing an Excel file?
Greetings and thanks
Hi @ElenaAA ,
Can you please try downloading the .csv file from the course resources? The file you are using may have gotten corrupted.
Save as .csv is what was told to do before import it.
This is what I have done before and it does not detect the columns, it detects everything as a single column and comes out like the image I showed before.
Anyway, in the course, in the video you can see how the instructor is importing an excel not a csv.The csv already does it in the first part of the session.
And I downloaded the file again and it still does the same thing.
Any suggestions?
Thank you!
In order to import it, I had to do it as shown in the first part of the session with the other file.
So what happens? Can only csv files be imported into the tables from the other section? Does this section not work?
Greetings!
Dear Community Members, As you may have read, the Power Platform communities are transitioning to a new platform and to access will be set to READ-ONLY mode during the transition. Key DatesTo ensure current learners have adequate support in the final week of the cohort, the Power Up Program Community will transition to READ-ONLY mode starting July 22nd, the platform will transition to READ-ONLY mode until July 28th. Power Apps, Power Automate, and Power Pages communities will be read-only July 16-22, 2024.During this period, members will not be able to start new threads or Kudo, Comment, or Reply to any posts, but will be able to search and review past threads or solutions. On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities. Learners will be able to sign in to the new Power Up Program community experience, starting July 29th. If you registered for community using your learnwithpowerup account, you will not receive an email, but should be able to sign in successfully if you are signed in to My hub. If you need help with your community account, please submit a request at aka.ms/PPCommSupport We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!
Since its inception in 2022, the Power Up Program has evolved based on feedback from learners and Microsoft Partners and customers. Today's Power Up learners can expect to learn the fundamentals of Microsoft Power Platform in the accelerated seven-week, video-based Power Up Maker course. Hear from Principal Program Manager, Dimpi Gandhi to discover the latest enhancements and meet the Microsoft MVPs, Rory Neary and Charlie Phipps, who partnered with the Microsoft Power Up Program to create the Power Up Maker course to guide learners to use the Microsoft Power Platform to develop custom applications, build dazzling report dashboards, or create efficiencies through automation.
The Power Up Program is a free upskilling program where nontechnical people can learn the fundamentals of Microsoft Power Platform. The Power Up Maker course is a seven-week self-paced virtual learning plan that include video-based objectives featuring Power Apps, Power BI and Power Automate. As a member of the Power Up Community, you can grow your skills and build connections. You can post questions to get help with the curriculum and hands-on exercises from experts and peers in the product boards. Check out the Community Information & Feedback board to find help or provide feedback with the community experience, and please take time to post in the Social board to tell us more about yourself. If you're new to the Power Up Program and looking for information to register. You can sign up at PowerUp.Microsoft.com.