Build Power Apps with Multiple Dataverse Tables and Relationships Using Copilot

[@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]

Glad it was helpful!

[@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]

This feature is a game changer

[@onothingnesso7170]

Yep. Whoa and wow. What?

[@RezaDorrani]

@@onothingnesso7170 What?

[@temidayolonge4566]

As always. Thank you Reza. Copilot is the game changer indeed

[@ArashAghajani]

The magic of Copilot! Excellent video. Thanks Reza :)

[@RezaDorrani]

Glad you enjoyed it!

[@leemorgan8007]

Another fantastic video Reza, I love your work. Things are really moving on at a pace.

[@RezaDorrani]

Most welcome!

[@oluwatobiyusuf]

Excellent use case. Thank you Reza

[@RezaDorrani]

Most welcome

[@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]

Feature is available in make.preview.powerapps.com in US preview type environment or early release environments

[@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]

@@dylanlievano4770 type is preview not sandbox. Its a special type of env. Check documentation.

[@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]

@@onothingnesso7170 Is ur environment type Preview?

[@rowanreynolds7853]

If i want to change the Entity Relationship Diagram (Data Workspace) at a later date after creating the app, how do i get back to the same view you show at: 01:18 - New Dataverse Table creation experience (Build multiple Dataverse tables and relationships)

[@RezaDorrani]

Currently, there is no option to go back to change. There is a new plan designer option coming which takes this a level up and allows you to change things.

[@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]

Feature is currently available in USA preview type environment

[@SampathJWKCT]

Hi Reza, If wants to create a field in the reservation table called "Support officer" which will be a dropdown list where i can see all office 365 account holder list. How we can do in new tables. I used to do this in SharePoint list easily.

[@RezaDorrani]

Use lookup column to virtual table microsoft entra id

[@sujitdaswant5256]

That what we are exactly looking for it will be very helpful for our current implementation. Keep Posting 🙂

[@RezaDorrani]

I will try my best

[@IBA-g4s]

Just magic excellent Mr Reza thank you so much

[@RezaDorrani]

Most welcome!

[@RyanKuy-t4c]

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]

I would recommend to learn the basics

[@RyanKuy-t4c]

​@@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! 😅

[@slowberries]

Is this available to use in the UK yet?

[@RezaDorrani]

I'm not sure of the release timelines

[@AmmarRamadan]

Perfect Reza, I think soon will be possible to create model driven apps integrated with business process and actions!

[@RezaDorrani]

I foresee that as well

[@TheKermit2110]

What a fantastic demo of this brilliant functionality, thanks Reza. Such a shame my company is too 'cheap' to give us Dataverse 😥

[@RezaDorrani]

Cost benefit analysis. Build something that shows your company the value of Dataverse. Developer environments offer a great starting point.

[@SadekInfos7392]

can copilote generate the app working only with sharepoint data souces or it necessarily suggest dataverse tables at the creation moment

[@RezaDorrani]

Currently, suggestions are for Dataverse only

[@SadekInfos7392]

@@RezaDorrani thanks for your response and for the videos as well

[@Gerberd4936]

Are you able to create an ER model without using copilot for each app you build?

[@RezaDorrani]

I believe this would be the new table creation experience once GA. It should work without copilot as well but not 100% sure.

[@Whuk1]

TNX for the nice video, do you have any idea when this feature is comming live?

[@RezaDorrani]

Check power platform release planner. Currently its available in USA preview type environment.

[@misstahnia]

Great example of the new function. Can we use this function now @Reza Dorrani?

[@RezaDorrani]

Feature is available in make.preview.powerapps.com in US preview type environment or early release environments

[@CloudhoundCoUk]

Very impressive. Thank you.

[@RezaDorrani]

My pleasure

[@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]

I am in US Preview type environment and using make.preview.powerapps.com

[@khaledchebl2710]

Hi, I'm developing an application that includes a simple form with a title field. When the form is submitted, it creates a SharePoint list using that title. The list needs to have a standard structure, meaning every list created should have the same set of columns. Could you assist me with this, or perhaps create a video tutorial for a similar application?

[@RezaDorrani]

I do not have a specific video reference on the mentioned scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@khaledchebl2710]

@@RezaDorrani Thank you

[@hayanmamoun8267]

Hi, Thank you for this video, I tried the same prompt, but instead of creating an ERD for different entities, i got only one table with a column for each entity, what did I miss?

[@RezaDorrani]

Currently, feature is in US Region preview type environments

[@AndreaBoche-AdvancedSolutions]

What version or plan of power apps are you using?

[@RezaDorrani]

Currently feature is in early release. Try learn.microsoft.com/en-us/power-platform/admin/early-release

[@johnlopes1784]

thank you so much

[@RezaDorrani]

You're most welcome!

[@christianberger6390]

Peut on faire relation plusieurs a plusieurs ?

[@RezaDorrani]

This feature currently does not support that

[@MrApahorkar]

Hi , When I import data from salesforce report and use lookup to build relationship between two tables it shows blanks no data , why is that ?

[@RezaDorrani]

I have done no work with importing salesforce data. I suggest posting your issue/query on forums at powerusers.microsoft.com/

[@ryaniwanowski]

Great content, too bad our organization does not have access to full Dataverse in our tenant.

[@RezaDorrani]

Start with a developer environment

[@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]

Whats a table environment? This is a new feature thats currently available in USA preview type environment.

[@muhammadusman7466]

How to go back to table design page for this app?

[@RezaDorrani]

Currently, there is no option to edit existing tables. Coming soon.

[@NathanMoore-z8l]

This functionality looks amazing, i cant figure out how to make it work through?

[@RezaDorrani]

Whats the issue?

[@deepakcitm]

Just awesome 🙌

[@RezaDorrani]

Thanks

[@salrathor1]

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]

Is it a table or gallery? Default to first user or first record in gallery?

[@salrathor1]

@@RezaDorrani it's a table (preview) and i'd like to default to the first user.

[@RezaDorrani]

@@salrathor1 I dont think it currently has an option for that.

[@salrathor1]

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

@@salrathor1 I'm not aware if this is on to-do list.

[@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]

I responded to your comment on that video.

[@christianberger6390]

Passionnant

[@RezaDorrani]

For sure