Getting Power Platform Dataflows to Load/Sync Data In Dynamics 365 – A How-To Guide

0
212


Author profile picture

@yagnesh-aegisyagnesh aegis

Software and Web Application Developer at Nexsoftsys – Software Development Company

Dataflow can be defined as a collection of tables or data that can be fetched from various sources, cleaned, transformed, and can be loaded in Dynamics 365 or Microsoft Dataverse, or Azure Data Lake Gen2.

Advertisement

To create a Dataflow, login to Power Apps Portal and select the appropriate environment.

https://make.powerapps.com/

Select the down arrow next to Data in the left navigation pane and expand it.

Select Dataflows in the navigation pane and then select New dataflow.

Select Start from blank option.

Advertisement
Advertisement

Provide the name to the data flow and click on Create.

The next screen presents us with all the different data sources supported by Dataflows.

Select Excel as the data source.

Here we will be importing contacts data from excel from OneDrive into Dynamics 365.

Below is the MyContacts.xlsx excel file in the OneDrive.

Advertisement

The file contains 3 contact records as shown below.

Back in the dataflow wizard, Click on Browse OneDrive.

Select the MyContacts.xlsx file and click on Next in the dataflow wizard.

We can see the data loaded from excel.

Click on Transform Data in the dataflow wizard.

Advertisement
Advertisement
Advertisement

Define the first row as header using User first row as headers option.

This transforms the first row as headers.

Click on Next in the Dataflow wizard, map the query as shown below.

Select Load to an existing table in Load settings.

Clicking on Automap maps the

Advertisement
FirstName

,

LastName

column.

Map the email field manually and click on Next.

In the next screen, we can define the refresh settings.

Refresh manually –

Advertisement
Advertisement

Refresh automatically – Here we can define the refresh frequency.

For now, we leave it as Refresh manually and click on Create.

This creates our Dataflow.

We can edit, rename, refresh, check refresh history, delete the dataflow as shown below.

The refresh history shows the details of the run like start time, type, duration, status, and action.

Advertisement

Inside Dynamics 365 Sales App, we can see the contact records created as per the records in the excel file.

Get more information here. – Create and use dataflows in Power Apps

Author profile picture

Read my stories

Software and Web Application Developer at Nexsoftsys – Software Development Company

Tags

Join Hacker Noon

Advertisement
Advertisement

Create your free account to unlock your custom reading experience.



Source link

Advertisement
Advertisement

LEAVE A REPLY

Please enter your comment!
Please enter your name here