A company has a list of contacts in a Microsoft Excel file. The company wants to load the contact information into a Microsoft Power Platform solution. You need to recommend a data-loading solution. What should you recommend?
https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-import-export#option-2-import-by-bringing-your-own-source-file you can import your own source file. Answer is C
I was 100% set on C but MS have put this answer in for a reason ... we have no idea of the state of the 'contact information', it could be terrible data for all we know and they are looking for a 'data loading' solution which insinuates to me that there is a bit more to it. I'm going with A.
It's A, the reason is that Contacts is an existing table, so you could not import data from any excel format, so there is an option which gives you the correct structure, and avoid failures when importing
The Import from Excel feature (C) is more appropriate for your needs because it directly facilitates the loading of existing contact information from an Excel file into Microsoft Dataverse or other Power Platform components.
The Excel Template feature (A) is useful for creating a standardized format for data entry, but it is not specifically designed for importing existing data into Microsoft Power Platform.
The Import from Excel feature is specifically designed for importing data from Excel files into Microsoft Dataverse
This feature allows you to map the columns in the Excel file to the fields in your Dataverse
The Excel Template feature is useful for exporting data to Excel in a structured format, not for importing data into a Power Platform solution
The answer is C. When you look at the option from ACCOUNT, for example, you see "Import from Excel". The other is Excel Templates - > Download of Upload Template, but that is for Excel reporting.
To import data using an Excel template, we must first export the data from the Dataverse table to an Excel file.
We then need to update this excel file with the required data and upload it back to Dataverse using the "import from Excel file" feature. So, in the end we still need to upload some Excel file to import the data into the system whether we are using a template data file or an Excel data file. The template file is still an Excel data file.
So, my answer is C - import from excel file.
A or C.
A -> multiple cases all the time again -> a list of contacts only once? (sure to re-occur). the template itself does not import it.
c. is a full solution. the excel is already existing.
but in practice i use A.
I go for C.
C. Import from Excel feature: This is the most efficient and straightforward method for loading data from an Excel file into Power Platform. Power Platform features like Power Apps and flows offer built-in "Import from Excel" options that allow you to easily select the file, map data fields to relevant tables or entities, and trigger the data import.
I would select C and not A because:
1. Template option is just recomended, not mandatory: https://learn.microsoft.com/en-us/power-apps/user/import-data#download-an-excel-template
2. This will also add some extra work to copy the existing data into proper columns of the template
3. You could directly import any CSV file, just do the correct mapping.
Excel data import tamplate is not the same as excel template. More about excel templates https://learn.microsoft.com/en-us/power-platform/admin/analyze-your-data-with-excel-templates
It was asking what tools you will use to import the data, so yes you first using the template but you will import it via ''import from excel', you template fulfill, so C is the good answer
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
nsxz
Highly Voted 2 years, 6 months agoxflair
1 year, 11 months agoIevoote
1 year, 5 months agomeg111111111111
1 year, 10 months agod6ff68f
Most Recent 1 day, 21 hours agoziggy1117
2 weeks, 1 day agodfd1f80
2 weeks, 5 days agoWASSIM2020
3 weeks agoWASSIM2020
1 month, 1 week agowsjones
7 months, 3 weeks agowsjones
7 months, 3 weeks agoMaitreMelanie
7 months, 4 weeks agonqthien041292
9 months agodbc2c96
11 months agoMrEz
11 months, 1 week agoMrEz
11 months, 1 week agomskaki
1 year, 1 month agosatishk4u
1 year, 1 month agoAttendee1
1 year, 3 months agoHiJaak
1 year, 3 months agoIevoote
1 year, 5 months agoIevoote
1 year, 5 months agodlnuser
1 year, 7 months ago