Create Dataverse Table Schemas Using Power Automate And Dataverse Web Api (CSV or Excel)
HTML-код
- Опубликовано: 28 июл 2024
- 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 ☕ 
Наука
I SEE DEV PEOPLE 🙏 Great demo again!
This is brilliant
Thank you very much 😍
Great video showing how to create Dataverse schemas
😉 thanks Ralf. Appreciated 👍
beauty
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
Cheers Doug, I hope I’ve covered it in enough detail for it to make sense. Appreciate you taking time out to watch.
@@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. 😆
Great educational content - lots of ways to expand/extend this into other needs. - Thanks for sharing.
Very much appreciated Scott 😍
insightful....
Epic🎉🎉
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
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
ruclips.net/video/gtlklzi6MDg/видео.html