Dataverse Dataflows as a sync mechanism

Подписаться 52 тыс.

Просмотров 10 тыс.

50% 1

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
• Documentation - Create and use dataflows in Power Apps | learn.microsoft.com/power-app...
Stay connected
• Twitter / microsoft365dev
• Call attention to your great work by using #PowerAppsCC and #PnPWeekly on Twitter.
Learn more
• Microsoft 365 Unified Sample gallery - aka.ms/m365/samples
• Microsoft 365 Platform Community in RU-vid - aka.ms/m365/videos
• Microsoft 365 Platform Community Blog - aka.ms/m365pnp/blog
• Microsoft 365 Platform Community - aka.ms/m365/community

Наука

Опубликовано:

6 ноя 2022

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 7

@munkybutler1 Год назад

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.

@rahulchitte763 8 дней назад

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

@stevenhampson8657 Год назад

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.

@kyle.garrett Год назад

Super useful. Thanks.

@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?

@zerg1337 Год назад

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?