Dataverse Dataflows as a sync mechanism

In this 15-minute citizen developer-focused demo, Eickhel Mendoza relates how Power Apps Dataverse Dataflows – a Power Platform tool is used to connect to services and get information to Dataverse. Learn about connectivity to services, ETL capabilities using Power Query, accessing multiple data sources from one solution, and using a merge query to sync data without duplicates. See creating a Dataflow, taking information from SharePoint, transforming and mapping it, and inserting it in a Dataflows table. This PnP Community demo is taken from the Microsoft Power Platform community call – October 2022, recorded on October 19, 2022.

Demo Presenter
• Eickhel Mendoza (Intelequia Technologies) | @eickhel

Supporting materials

Stay connected
• Call attention to your great work by using #PowerAppsCC and #PnPWeekly on Twitter.

Learn more

[munkybutler]

Hi Eickhel, thanks very much for this video. Instead of querying the dataverse table and creating new queries it is possible to select a key in the 'Map Tables' step. Dataflow will pick up on the key and for all the rows to be imported it will use the key to identify existing rows. The existing rows will be updated instead of duplicate rows being created.

[stevenhampson]

Great content with a really practical example. Finally I can see MS is bring Power BI / Power Query into power apps. I am hoping the dataflow is shared across power bi as well so as to have a single instance.

[rahulchitte]

Very nice and useful! How the complex SharePoint field's data will be synced to Dataverse table?

[rjobaanable]

very nice tutorial. Will this also work when there is just an update in Sharepoint, so no new record but dataverse need to be updated?

[zerg]

Could you show how to migrate relationships - e.g. Parent account of contact and primary contact for account, because Dataflow seems kind of lackluster in that regard?

[burhanshah]

Can we use it on lookup o choice columns ?