Create Dataverse Table Schemas Using Power Automate And Dataverse Web Api (CSV or Excel)

Рет қаралды 1,842

Күн бұрын

Discover how to effortlessly generate table schemas on demand, streamline your data management, and enhance your Power Automate flows. Whether you're preparing for a data import or aiming to understand the intricacies of your solution's data capture, this tutorial is your gateway to mastering Dataverse. I'll walk you through a live demonstration of the flow, unravel the concept of tables in solutions, and show you how to obtain the solution GUID with ease. Plus, you'll learn to generate entity / table definition schemas automatically using a cloud flow. Dive into the construction of the flow, explore querying the Dataverse Web API, and learn to create an Excel file output with unparalleled efficiency.
00:00 Intro
00:35 Overview of Flow
02:13 Look at the CoE Solution Tables
03:03 Generate the Schemas from a Flow Run
03:41 Explore the Schema
05:22 How was the flow built
06:32 Construct URL for Web API
09:07 Explore 2nd Web API for Table Properties
10:10 How to create the CSV with Select
12:04 Generate an Excel File
Got an idea? Or video request? Drop me a note here forms.office.com/r/4EqE7VHVfH 👍
Populate Excel Fast • Create Excel File and ...
Download the CoE Table Schema www.damobird365.com/wp-conten...
Want to buy me a coffee www.buymeacoffee.com/DamoBird365 ☕

Пікірлер: 15

@michal4561 7 күн бұрын

beauty

@temidayolonge4566 3 ай бұрын

This is brilliant

@DamoBird365 3 ай бұрын

Thank you very much 😍

4 ай бұрын

I SEE DEV PEOPLE 🙏 Great demo again!

@RalfHeid 3 ай бұрын

Great video showing how to create Dataverse schemas

@DamoBird365 3 ай бұрын

😉 thanks Ralf. Appreciated 👍

@MSFT_ScottSewell 4 ай бұрын

Great educational content - lots of ways to expand/extend this into other needs. - Thanks for sharing.

@DamoBird365 4 ай бұрын

Very much appreciated Scott 😍

@dougydoe 3 ай бұрын

Great video packed with great concepts. I have to watch this, probably a few times for a better understanding but a real eye opener as to what is possible. Thanks for sharing as always

@DamoBird365 3 ай бұрын

Cheers Doug, I hope I’ve covered it in enough detail for it to make sense. Appreciate you taking time out to watch.

@dougydoe 3 ай бұрын

@@DamoBird365 Yeah you have. I want to take my Flow development to the next level so videos like these will help with that. Your videos on Data Operation connectors and Array manipulations have been immensely valuable in helping me build more efficient Flows so I always looking to watching your videos. 😆

@Nipunj9 4 ай бұрын

insightful....

@inspectorlife85 3 ай бұрын

Epic🎉🎉

@barbaravickie2261 4 ай бұрын

Hello , thanks for the lovely Video , i have a doubt, is it possible to Automate i mean recurrence flow to send data from Power BI table to Sharepoint list , multiple columns (mostly only date , text , number ). I tried but i m struck with java script i m getting error , is there any video on that , please

@DamoBird365 3 ай бұрын

This is the only video I have for exporting power bi data to excel 👉 Create Excel File and Add Rows Fast | Graph API | Office Scripts | Power BI | Power Automate kzfaq.info/get/bejne/ndqcns-rzpyxdJs.html