DRAG DROP -
You store data about products in two Microsoft Excel worksheets.
The data contains duplicate rows.
You need to consolidate data from the two worksheets into a Microsoft Dataverse custom table.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
 
















 

Suggested Answer: 
    

Step 1: Upload the worksheets to OneDrive
A data source needs to be specified. The data needs to be available.
Step 2: Create a dataflow -
Step 3: Create queries for the worksheets
You can shape your data selection into a form that works best for your table using a Power Query editing experience, similar to the Power Query Editor in Power
BI Desktop.
Step 4: Add conditional columns to perform checks on the data
Step 5: Append the output of the queries
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-and-use-dataflows
 https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query

This question is in PL-100 Microsoft Power Platform App Maker Exam
For getting Microsoft Certified: Power Platform App Maker Associate Certificate





Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft. 
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.