Тёмный

Build Power Apps with Multiple Dataverse Tables and Relationships Using Copilot 

Reza Dorrani
Подписаться 129 тыс.
Просмотров 13 тыс.
50% 1

Get started with building Power Apps by using Copilot to assist in creating multiple Microsoft Dataverse tables and relationships via a new GUI-like experience. Start by describing your app needs to Copilot, and it will build a multi-table structure from natural language input or from Excel or SharePoint data. Create table relationships in an entity relationship diagram (ERD) like GUI, and Copilot will then build a Power App with a screen for each table in your defined multi-table data workspace.
Learn how to use Copilot to create and update Dataverse tables, describe your app's use case in natural language, and watch as Copilot transforms it into a complete Power App. This tutorial in Power Apps covers the concepts of how Copilot will be available throughout your app-building journey, from creating tables to building and editing apps, to writing and explaining formulas, to using Copilot answer control, and more.
Makers will be able to create tables from scratch using various data sources including Excel files, SharePoint lists, or conversation with the assistance of copilot in the new data model visual editor. Multiple tables can be created at the same time with relationships set up leveraging smart inference capability of copilot. Created tables and relationships will be visualized in ERD (entity relationship diagram) view to help makers better understand the data model. Makers can also invoke copilot inline to create new tables, update schema, or seek for suggestions to improve their data model.
#powerapps #copilot #powerplatform #dataverse
⬇️ Download Power App showcased in video:
Exclusive for Channel Members (Silver 🥈 & Gold 🥇 Club)
Find the download link in the Community Tab for Members.
To become a member, click here: ru-vid.comjoin
Table of Contents:
00:00 - Introduction to building Power Apps from Multiple Tables and Relationships with Copilot
00:47 - Build Power Apps with Copilot (Use everyday words to describe your app needs)
01:18 - New Dataverse Table creation experience (Build multiple Dataverse tables and relationships)
02:06 - Entity Relationship Diagram experience for Dataverse Tables
02:45 - Update Dataverse Table schema with copilot
04:43 - Create Dataverse Table from excel data
05:46 - Create Dataverse Table from SharePoint List data
06:34 - Create Power App from Multiple Dataverse tables including relationships
08:14 - Power Apps Dataverse CRUD operations
11:15 - Power Apps Copilot code comments to Power Fx formulas
11:46 - Use Power Apps Copilot for text formatting and conditional formatting of data
12:41 - Copilot explaining Power Apps formulas
13:08 - Power Apps Copilot Answer control

Наука

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

 

17 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 66   
@georgegualda4262
@georgegualda4262 Месяц назад
This is an excellent video. The improvements that Copilot adds to the development of PowerApps is incredible, and it's just the beginning. Thanks for always bringing the latest information to us in a comprehensive manner. Please keep up the EXCELLENT work you do.
@RezaDorrani
@RezaDorrani Месяц назад
Glad it was helpful!
@dougydoe
@dougydoe Месяц назад
All I can say is Whao, Whao!!! The ERD particularly is really incredible as that is one area of challenge when it comes to building truly scalable Apps. They've really made and are still making app building manageable with the injections of Copilot's assistance. throughout. Thanks for show casing this brilliantly. Looking forward to using these features in projects soon. 😃😃
@RezaDorrani
@RezaDorrani Месяц назад
This feature is a game changer
@onothingnesso7170
@onothingnesso7170 Месяц назад
Yep. Whoa and wow. What?
@RezaDorrani
@RezaDorrani Месяц назад
@@onothingnesso7170 What?
@temidayolonge4566
@temidayolonge4566 Месяц назад
As always. Thank you Reza. Copilot is the game changer indeed
@ArashAghajani
@ArashAghajani Месяц назад
The magic of Copilot! Excellent video. Thanks Reza :)
@RezaDorrani
@RezaDorrani Месяц назад
Glad you enjoyed it!
@leemorgan8007
@leemorgan8007 Месяц назад
Another fantastic video Reza, I love your work. Things are really moving on at a pace.
@RezaDorrani
@RezaDorrani Месяц назад
Most welcome!
@CloudhoundCoUk
@CloudhoundCoUk Месяц назад
Very impressive. Thank you.
@RezaDorrani
@RezaDorrani Месяц назад
My pleasure
@sujitdaswant5256
@sujitdaswant5256 Месяц назад
That what we are exactly looking for it will be very helpful for our current implementation. Keep Posting 🙂
@RezaDorrani
@RezaDorrani Месяц назад
I will try my best
@oluwatobiyusuf
@oluwatobiyusuf 29 дней назад
Excellent use case. Thank you Reza
@RezaDorrani
@RezaDorrani 29 дней назад
Most welcome
@JHicham
@JHicham Месяц назад
Just magic excellent Mr Reza thank you so much
@RezaDorrani
@RezaDorrani Месяц назад
Most welcome!
@johnlopes1784
@johnlopes1784 Месяц назад
thank you so much
@RezaDorrani
@RezaDorrani Месяц назад
You're most welcome!
@AmmarRamadan
@AmmarRamadan Месяц назад
Perfect Reza, I think soon will be possible to create model driven apps integrated with business process and actions!
@RezaDorrani
@RezaDorrani Месяц назад
I foresee that as well
@deepakcitm
@deepakcitm Месяц назад
Just awesome 🙌
@RezaDorrani
@RezaDorrani Месяц назад
Thanks
@user-oc2qc7fd5n
@user-oc2qc7fd5n 8 дней назад
Wow! That's awesome! I had no idea Copilot was this useful in app development. Since I'm new to the Power Platform and need to learn these tools for my company to build an app, should I rely on Copilot, or should I learn the basics of Power Fx? Please let me know. Thanks!
@RezaDorrani
@RezaDorrani 8 дней назад
I would recommend to learn the basics
@user-oc2qc7fd5n
@user-oc2qc7fd5n 7 дней назад
​@@RezaDorrani Thanks! Actually, I tried to learn this app for a month before stumbling upon your channel. After watching this video, I tried to recreate our company's existing app for managing trucks, which was built on raw PHP and MySQL. After a few hours of using PowerApps with Copilot, I almost finished the most complex data relationships. I don't like the default user interface that the AI generated; I want it to be more unique, like an admin dashboard instead of the default one. But the functionality, especially the CRUD operations, is almost the same as our current system. I would like to explore more and hopefully finish and customized the app this month! 😅
@koelienoelie
@koelienoelie Месяц назад
TNX for the nice video, do you have any idea when this feature is comming live?
@RezaDorrani
@RezaDorrani Месяц назад
Check power platform release planner. Currently its available in USA preview type environment.
@williamm8460
@williamm8460 Месяц назад
Does this feature need to be activated somewhere, as I've tried using the same prompt, and it doesn't produce the same screen? It also only produced one table, Hotel Reservations, as opposed to the video's example which includes the three others.
@RezaDorrani
@RezaDorrani Месяц назад
Feature is currently available in USA preview type environment
@misstahnia
@misstahnia Месяц назад
Great example of the new function. Can we use this function now @Reza Dorrani?
@RezaDorrani
@RezaDorrani Месяц назад
Feature is available in make.preview.powerapps.com in US preview type environment or early release environments
@jamessolan5264
@jamessolan5264 Месяц назад
Awesome! how do we get hold of this feature?! - I've still only got access to single table co-pilot app creation so far. The ERD interface to create tables looks ideal!
@RezaDorrani
@RezaDorrani Месяц назад
Feature is available in make.preview.powerapps.com in US preview type environment or early release environments
@dylanlievano4770
@dylanlievano4770 Месяц назад
@@RezaDorrani I tried it but it is not working I have my environment in the US and the type is a sandbox, is it possible to do this in this kind of environment?
@RezaDorrani
@RezaDorrani Месяц назад
@@dylanlievano4770 type is preview not sandbox. Its a special type of env. Check documentation.
@onothingnesso7170
@onothingnesso7170 Месяц назад
I can get to the environment but nothing resembling that happens. Even with exact same prompt. No flow editing environment. I apologize for my ignorance. This is very intriguing. Could solve many problems so quickly.
@RezaDorrani
@RezaDorrani Месяц назад
@@onothingnesso7170 Is ur environment type Preview?
@juliaAmitabha
@juliaAmitabha Месяц назад
Thanks Reza. This is not available in my cdx tenant. Did you have to enable any settings or are you using this on the MVP plan or on the early access programme? Basically how can i get access to this please? Want to use it for a Hackathon that we are hosting early next week
@RezaDorrani
@RezaDorrani Месяц назад
I am in US Preview type environment and using make.preview.powerapps.com
@Gerberd4936
@Gerberd4936 День назад
Are you able to create an ER model without using copilot for each app you build?
@RezaDorrani
@RezaDorrani День назад
I believe this would be the new table creation experience once GA. It should work without copilot as well but not 100% sure.
@onothingnesso7170
@onothingnesso7170 Месяц назад
When I follow the steps initially, no table environment pops up like that, just the column config screen. Do I need a certain copilot subscription? I have power app premium…
@RezaDorrani
@RezaDorrani Месяц назад
Whats a table environment? This is a new feature thats currently available in USA preview type environment.
@AndreaBoche-AdvancedSolutions
@AndreaBoche-AdvancedSolutions Месяц назад
What version or plan of power apps are you using?
@RezaDorrani
@RezaDorrani Месяц назад
Currently feature is in early release. Try learn.microsoft.com/en-us/power-platform/admin/early-release
@SadekInfos7392
@SadekInfos7392 19 дней назад
can copilote generate the app working only with sharepoint data souces or it necessarily suggest dataverse tables at the creation moment
@RezaDorrani
@RezaDorrani 19 дней назад
Currently, suggestions are for Dataverse only
@SadekInfos7392
@SadekInfos7392 19 дней назад
@@RezaDorrani thanks for your response and for the videos as well
@NathanMoore-z8l
@NathanMoore-z8l 27 дней назад
This functionality looks amazing, i cant figure out how to make it work through?
@RezaDorrani
@RezaDorrani 27 дней назад
Whats the issue?
@koynabettawar1211
@koynabettawar1211 Месяц назад
Hi reza, In the multiselect checkbox in powerapps video, in which you have explained how to replace a combobox by a checkbox. I want to also know that how did you applied a function to submit button for saving that checkbox values in a SharePoint, I know you saved a values to a collection then that collction will save a values in a SharePoint list . Can you plz explain how did you save that collection in a SharePoint list, it will be very helpful if you will explain that🙏
@RezaDorrani
@RezaDorrani Месяц назад
I responded to your comment on that video.
@ryaniwanowski
@ryaniwanowski Месяц назад
Great content, too bad our organization does not have access to full Dataverse in our tenant.
@RezaDorrani
@RezaDorrani Месяц назад
Start with a developer environment
@salrathor1
@salrathor1 14 дней назад
Hi Reza, or anyone else who can help, is there a way to default the table to select the first item in the table? I'm linking a table to an edit form and when the app loads the edit form is blank, i want it to default to the first user as it looks nicer. I can't seem to find an option.
@RezaDorrani
@RezaDorrani 14 дней назад
Is it a table or gallery? Default to first user or first record in gallery?
@salrathor1
@salrathor1 14 дней назад
@@RezaDorrani it's a table (preview) and i'd like to default to the first user.
@RezaDorrani
@RezaDorrani 14 дней назад
@@salrathor1 I dont think it currently has an option for that.
@salrathor1
@salrathor1 14 дней назад
@@RezaDorrani I thought so, I couldn't find an option. I have a table with an edit form, when I submit the edit form it deselects from the table. It's not a good User experience. Any idea if this is on the to-do list?
@RezaDorrani
@RezaDorrani 14 дней назад
@@salrathor1 I'm not aware if this is on to-do list.
Далее
DAD LEFT HIS OLD SOCKS ON THE COUCH…😱😂
00:24
Named Formulas & User Defined Functions in Power Apps
13:41
10X Your Excel Skills with Copilot
12:51
Просмотров 270 тыс.
Microsoft Dataverse Overview
1:12:11
Просмотров 36 тыс.
Creating Multi-Step Forms in Power Apps | Tutorial
14:42
Я УКРАЛ ТЕЛЕФОН В МИЛАНЕ
9:18
Просмотров 119 тыс.