Question
A company uses Dataverse to store the names of contacts. The company uses a shared Microsoft Excel file to collect the data.
The company requires that the contacts be added to Dataverse automatically every day.
You need to identify which tools are required to create and perform the import.
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Create the import: Dataflow. A dataflow is the only option here that can be authored once and then run on a recurring schedule, which is what "added to Dataverse automatically every day" requires. You create the dataflow in the Power Apps maker portal, point it at the shared Excel file, map the columns to the Contact table, and set a refresh schedule. Import from Excel and the Import Wizard are one-off, manual upload operations, and a data map is only the column-mapping definition used by such an import, so none of them meets the daily automatic requirement.
Perform the import: Power Query. Dataflows are built on and run by the Power Query engine, which connects to the Excel source, applies the transformations and column mappings, and loads the rows into the Dataverse Contact table on each scheduled refresh. Connections and custom connectors only provide authenticated access to a data source rather than doing the extract-transform-load work, and Power Apps is the app-building layer that hosts the maker experience, not what runs the import.
