Build your Power App with Dataverse in Microsoft Teams - AMA ft. Gokan Ozcifci

Thank you

Hi, everyone. Welcome back to C Sharp on a live show. I'm your host, Stephen Simon

and we are back with another episode of Ask Me Anything series. After a long time, like after

almost like a couple of weeks, as you know, we have kind of halted all our live shows at C Sharp

Live as all our team members and the community here in India are focused more toward helping

people for uh go with Africa by COVID-19 uh so that's what our focus has been uh for this month

and for upcoming weeks uh but uh i can this this live show was already scheduled and it's been a

while i i met my mate Koken who is the guest of this show today so i was really excited i am

actually excited so welcome back once again who is joining this is episode number 34 for ask me

anything and probably we are well over 250 live shows can you imagine that i i say we stream eight

days in a week the amount of live streams that we have done in in this pandemic is it is a lot i mean

yeah we have done a lot of that apart from that uh a quick announcement before we go ahead and move

uh actually talk about the today's show is uh about the life that we do we're not doing this

month but on mondays we do azure ai show that's on 10 a.m eastern uh tuesday i forgot the banner

to add but on tuesday this product showcase show but on wednesday we have c sharp on the mvp show

where we feature community leaders from the from the c chapter community how do they start their

journey and how do they manage to contribute uh about from their day-to-day uh work life then on

thursdays we have ask me anything show uh streams every thursday at the name eastern kind of changed

you can definitely say that today's wednesday uh on on fridays we do both mindset at 12 am eastern

where my mission was the founder of each up corner who talks about uh you shouldn't be coding uh your

entire life right go ahead and become a leader that's what he talks uh then on uh saturdays we

have rock in the code world with dotnet day hosted by david mccarter who is a 14 times microsoft mvp

he invites people from the entire ecosystem of dotnet he has had mads todgersson scott hunter

Ketan Dolat, Jeremy Lickness. I mean, everyone from the .NET ecosystem and C Sharp

and also Visual Studio, many, many program managers. Definitely go ahead and check that live show too

Plus what we also do is every Saturday at 10 a.m. Eastern

we do C Sharp Corner Town Hall, where we announce all the updates from this week's C Sharp Corner

Plus in that C Sharp Corner Town Hall, you can also go ahead and join in as we drop the link in the comments

you can be a part so uh hi venkit uh hi venkit thanks for joining in hi pickup welcome to the

live show i see many more people joining drop your location in the comments it's always very

interesting from which location you're joining you never know you go and go ahead and make some

friends in from the live chat okay so having said that in today's episode we have google uh uh

hooker is an amazing person he's uh both microsoft regional director and a microsoft mvp uh yeah i

I think that's the intro that I have for him for today, actually

Let's go ahead and invite our guest, actually. Hi, Gokhan. How are you

Welcome to the live show. Hello, Simon. Thank you so much. Well, it was a great introduction, right

One sentence intro. Happy to be back. Happy to be here after some difficult moments

And I'm happy to see you again, my friend. Yeah, that's great for..

Yeah, so one thing to definitely say that. stay safe everyone this time is tough right so as our guest has gone through uh so hi sarum hi

welcome from uh nipal thanks for joining in so goker before uh before we step in to talk about

all this technical stuff how has life been how how are things going on um how's the work uh yeah and

how are you managing these times i had some difficult times to be honest i got the the

the COVID, unfortunately, and I have missed a lot of, I was like in bed for three weeks

I unfortunately missed the MVP summit. I missed the regional director summit

I missed the SharePoint birthday and even missed your event, the Power Platform Summit, unfortunately

I really tried to come and share my knowledge for the community, but I was in bed

I was really struggling and I see a lot of information around India

Please, everyone, everyone who is listening, stay safe, stay home. I know it's not easy because I'm from a country where it is a poor country, Turkey

It's not the United States. It's not the United Kingdom. It's a poor country. And I know that not everyone can stay home

We have the chance to do some IT stuff and we can do some stuff from home

Not everyone has that chance. Some people have to be outside. They have to be in contact with others

so I know it's not easy but please, please, please stay home, stay safe

and wear a mask, that's the thing that I can definitely say to everyone who is listening now

Yeah, yeah, definitely stay safe and I didn't know you were from Turkey because

I have some plans to visit Turkey next year, so maybe next year

this year I'll be your host, I have roots from Turkey, I was born in Belgium

but my name definitely doesn't sound Belgian, Gokunazivsi that's not the most Belgian name you will see

it's most likely Turkish I do regularly go to Turkey so if you ever come to

Turkey I'll be definitely your host and we'll show you the beautiful country

that's great plus Gokul looks like you changed your background like I

really love it what's up there let everyone see oh my goodness

I love that you have a bunch of them right Dragon Ball and Dragon Ball Z

Well, I have a bunch of them as a statue. Instead of having a wallpaper behind me with teams

I'm like, hey, let's invest in expensive toys and showcase that. People will love it

Already, like last time when I did Ask Me Anything, someone from Singapore reached me out through LinkedIn

and said, man, I love what you have in background. Just show me a few pictures

Yeah. That's great. I love your background too. I wish I had those, but never mind

So, Gokhan, so today we're going to talk about, actually, what are we going to talk about? I know it's Power Apps

You always come with some great content with Power Apps on this AMA. But what is the focus for today

Yeah, I know that C Sharp Corner is an extremely developer-minded community

And when I go there, it's like, wow, I'm amazed by the rock stars you guys have

in the development side of the story of Microsoft and every single Ask Me Anything or blog post or anything that you guys have is mainly developer And the major reason why I joined the community the C Sharp community is because I want to

bring some diversity, some other stuff than only development. And today's session is actually everything less development

It's going to be like how you can build a database, a CDS, a dataverse

within Microsoft Teams passing through Power Apps. And in a few clicks, we'll be building our application, reading through data

and even building some relationships between tables and entities into Power Apps

And I'm just going to showcase you that not everything needs development

Like you can build a bunch of applications, a bunch of intelligence

without even a single line of code. I know some people will hate me

because it's the C Sharp community where every developer is here, but my job is to bring diversity

My job is to bring everyone under one big family, which is a C Sharp corner

Wow, this already sounds so exciting, Gokul. We actually had a conference

that had almost like 40 plus sessions on Power Apps, but this is, I think, one of the best intro

for a session I've ever heard. I'm really excited. Database for Microsoft Teams

Anyway, this sounds so exciting. And when you code that, you don't need much of the development background

to go ahead and do all this. That really adds more of the value. So feel free to go ahead and share your screen

And then we are ready to see the magic of Power Apps and Universe

There you go. I will then select my screen and share it

And normally you should now see my screen. Simon, I'll just let you confirm it whenever you see it

Okay. Welcome, everyone. This is going to be the most demo fancy session you will have

Unfortunately, I still have a few slides to show to you, but I promise you it's going to be very fast

Welcome to this session called Build your first Power App with Dataverse in Microsoft Teams

I will show you as I explained how you can build your app without a single line of code

and how you can read that within Dataverse. My name is Gokun Ozifsi

I'm a principal at Neoxi Consultancy, which is my own company, by the way. I'm the CEO, I'm

the marketing people, I'm the executive, I'm everything, because I'm the only guy

working at Neoxi. I'm a national regional director and MVP, and my Twitter handle

is xgokun. So if you have any questions about PowerApp, about Teams

about SharePoint, or even about this session, well, the best way on

reaching me would be through Twitter. send me a direct message and I'll directly try to help you about the artifacts of that session

What is Microsoft Dataverse? That's a new fancy word that we are hearing more and more

We can see from the definition of Microsoft that Dataverse lets you securely store and manage data

being used, consumed, processed by business applications. Those data are actually stored

within a set of tables, rows, columns, call it how you like to call it

But it is basically a spot, a place, a placeholder for you

where you can actually store and manage your data. And that image is extremely powerful

because it shows you the power of the Power Platform. Coming from Power BI, Power Apps

Power Automate, or Power Virtual Agents, any of them can use connectors, portals, AI builder

and the new baby, the common data service what we call today the Dataverse

Well, you saw Common Data Service in Dimage. I already sent a few times CDS, Common Data Service

Well, you need to know that we have to say goodbye to the Common Data Service. That's the old name that we have been using

Today, well, it was called Project DataFlux. Then it went to Oakdale

Well, it was first Oakdale, then DataFlux. And now we call them Dataverse

And Microsoft decided to change entities, fields, option sets, all of them, to tables, columns, and rows, and choices, to fields such as yes and no

And the main reason why they did that is because they want to make that piece within the Power Platform more understandable and actually reaching to a broader audience

They want you as an end user, as a maker, as a power user to use and consume the CDS, the old CDS with the new name, Microsoft Dataverse

Is it a database? It looks like it's a database, like where you can store and manage your data, but it's way more than only a database

It literally looks like it's a database, but I will show you why it's actually more than a database

And there is a great image on the internet by Forward Forever which shows you that actually Microsoft is not new into the game

They had the XCRM from 2005 to 2018. Then they had CDS

Then they had Dataflex, which went Project Oakdale. Now it's like Dataverse

But as you can see, the CRM story at Microsoft is not new

And it's not just only a database because you can do way more

a thousand times more than only what a database, a simple database, can do

And we will see why in a few seconds. Dataverse has an API where you can communicate through other platforms

It has a connector. It has its own security model. It has its logic like the workflows that you can have

You can save your data and mash up with data. But we today are interested in Dataverse for teams

As part of the license, makers, citizen developers, IT pros, even developers can now build any Power App, Power Flows

Power Tool Agents directly within the context of Microsoft Teams. There is a huge difference between Dataverse for Teams and Dataverse

As an example, Dataverse has non-relational storage, which Dataverse for Teams does not

Dataverse has API access where Dataverse for Teams does not, etc., etc

So there is a huge list of functionalities, artifacts that Dataverse for Teams can and cannot do compared to Dataverse

So Dataverse on its own is a huge thing to consider. Dataverse for Teams is smaller, compacter, and you cannot do everything you want to do with that

Here is an example of what you can do and how you can create a table, an entity, a row, and data

Extremely easy. And I will show that to you. And everyone in the organization will be able to do that in a few seconds

Is it one single app to rule them all? Well, we can say that. And yes, we cannot say that

You have to understand that it's a new capability coming to us build on Microsoft Teams

CDS Dataverse already existed and people had to pay for it, but today we get the Teams app

and you can now extend it with Dataverse for Teams. It has some features that you have to understand

such as security, which everything is managed by Azure Active Directory and allowed by conditional access

You need to understand what Azure is and what conditional access means that the storage is stored in the Azure Cloud that there is logic behind that and that you can use calculated columns fields

business rules with business process faults, and that there is integration with

other sources using connectors, Power BI, Dynamic 365, and Power Agents. Yes, it looks like it's a single app to rule them all

but it has a lot of implications, a lot of things to consider before saying that

this one apps rule them all. CDS or Dataverse for Teams, today for Teams has a lot of power

If you have imagination, well, you could do a bunch of stuff with that

But if you go to the extreme, well, maybe then it's not the case anymore

as in any other application. Why should you use Dataverse? A little bit technical stuff before we get into the demo

Well, it's stored in the Cloud and you don't have to worry about where the data is

You don't have to worry about disaster recovery. You don't have to worry about the backups

You don't have to actually take care about the infrastructure, about the storage costs

Well, all of them is managed and easy accessible through the clouds

It is secured. Well, it is secured. First of all, if you want to do this on-premises

well, you need to have a firewall, you need to have multiple storage locations

Well, data is now securely stored so that the users can see and you can even grant access to them

If you use the Dataverse, you can even have specific rules per data

So you could say that data is accessible by Goken and no matter from where it comes

It could come from SharePoint, from Teams, from Azure, from X kind of applications

If my financials are granted on that file, well, I can have access on top of that

So what we have done in the past is we have given access to the sites, to the teams

Now with Dataverse, you can give access to the data. You can access from anywhere, from any connector app, from any platform, your data on Dynamics 365

It has rich metadata types and relationships are used directly within Power Apps, and I will show that to you

You have a bunch of data types that you can use. and you can have some logic and validation with workflows

with business rules, with business process rules on top of that. And if you are really good in Excel, honestly

you will be good in Dataverse as well because it has the same value on top of that

When should you not use Dataverse? This is, I think, the most interesting slide for everyone in this session

Dataverse has a limit of storage, 1 million rows or 2 gigabytes of data

If you plan to have more of that, well, then Dataverse for Teams is not the place to go

Check for integrations. Not every integration is possible and not every connector exists or might be expensive

So before saying that Dataverse for Teams is the one app to rule them all

well, you might check how cost effective it will be. You need to know that everything will be connected to your team

I will show you why, because we have to have a Teams environment for creating more Dataverse for Teams

and the owner of the team will be managing everything. And the Power Platform admin cannot control

the creation of dataverse environments in teams, meaning that if you have 50 team owners

they all can create environments into the dataverse so they can use it with other teams

You can only have like 500 pieces of dataverses for your teams

And today, if you want that limit of 1 million row and 2 gigabytes of data will be disallowed

Well, you have to convert that functionality to a production environment which is today not available

unfortunately, and the change from Teams to production environment will impact the license

The team and users will need a Power App Premium license to access the data version production environment

So it is not that always easy. Well, you have to make an ysis and

understand how far you can go with that. That being said, that's a lot of slides

So let's now move to the demo environment. What I will now do is I will open my Teams environment

So as you can see, I'm in a simple Teams environment where I have like two simple Teams

What I will now do is I will create a brand new Teams theme from scratch

and I will do it in private, I'll call it C sharp corner

dataverse. Just to make clear that it's new and I will create that

So in the backend, Teams will create an M365 group, will create a SharePoint site

will create an Exchange mailbox, will create a mailbox, so I can access the files

the data from that group into my team. Normally, when you want to work with PowerApp

well, what you could do is you could basically come here and select make.powerapps.com

and then from that interface, the admin center from PowerApp, Well, you can create apps

Let's create a simple one. Well, you could go start from here

start from data, and then you could use SharePoint as a connector, or we can create a Canvas app from blank

Herein you can create a name and say like C-sharp corner, first test

You can choose for tablet mode or phone mode. It doesn't really matter for that exercise

but just want to show you that now I'm actually building an app through PowerApp

but it is not connected to any environment. It has no connector

It is not connected to CDS or Dataverse. It's an empty app

Now from here, I can just come and add data given. What you can do is you can search for data

CDS, Dataverse, or connectors. You could easily say, okay, I'm looking for the SharePoint connector

and I will add the SharePoint connector just here. I'm using that token, and then on the right side

He will search for sites, and he will give me the sites where I have access to

And then I have to choose for document library or list, and I will choose the travel request

And what you will see now, I have a connection on my left side

and I have made a connection to my SharePoint. And what people have been doing before is they add a gallery, any of them

and then they connect that gallery to that connector. And now you will see, hey, I was speaking in SharePoint Fest Seattle

and I have now my data coming to Power App. That's what we did before, right

A connector to CDS, a connector to SharePoint. And hey, don't get me wrong

you have a bunch of other connectors. I'm always using SharePoint because I'm a SharePoint guy

but if you want to have OneDrive for Business, if you want to have Microsoft Teams

any other kinds of approvals, well, you can see all of them

Like the list is huge. If I'm not wrong, you have more than 320 connectors to be used and consumed

Only one thing to remember, if you see that diamond, well, that means that's a premium connector and that in some cases you have to pay

The price always is differentiating from connector to connector. Always be sure to check in what you do

Now from Teams I have my team and I want to have a PowerApp which is actually connected to Dataverse where I can use it directly from Microsoft Teams

What you need to do is you need to search for PowerApp. If you go here in bottom

while you have the apps section, while you need to search for PowerApps

and then open that PowerApp for you. I have it here. What you could do is just hit on that

Normally in your environment, if you haven't been using that, Well, it should be installed

You just hit on open and now you will see that I will be in

the Power App Admin Center as I had on the browser just here

Well, what you could do is start a new project, open recent ones

I made a small test just before the session and I can see it from here

Or you can use already existing Dataverse apps within Teams. What we will do is we will start a new one

and now he will give me every team where I have access to

because he needs to create the data verse and link them to the team

So every team will actually be linked to a unique data verse

I will select my team and it says like you're the first person creating an app

It will take some time. Okay, no worries. I will create that. Now it is creating for me an environment

within Microsoft Dataverse where I can store my data and that one will now be linked to my team

We'll have to wait a couple of seconds until it creates the team

There we go. The power app is ready to go. Now, I'm actually going to another screen

where I can actually build my application. I have to give a name

I will give it a name. and now I have my environment with my table and with my rows

But what we will see now is that it's connected to a custom gallery sample

and it's always the same. If you even go here in PowerApp, outside of Microsoft

if you add any data here, well, it will be always connected to some sample of Microsoft

But we don't want to have that, right? We don't want to have that. I can even connect this to a SharePoint list

but hey, we want to use the dataverse. So therefore, you need to create a new table

and I will create a new table. C-sharp corner dataverse table. And now if I create a table

well, that table will be created in my environment in my Microsoft dataverse

And now I can start with the fun side of things. Well, as you probably know, those SharePoint people

well, in every list that you create, well, you had a title, a name

feel, well, we have exactly the same herein. Well, what we can do is you can hit on a plus

and give a name and select a type. And we have a bunch of types that we could do

So let's create our first application. Let's create a ticketing system, right

I want to have an application in Microsoft Teams where I can actually submit some tickets

I could ask for email, which sounds good. Email. And then you have some advanced options

You can search for the lines. No worries. I'll do that. Then let's look

What do we have? We have an auto number because I want to have a unique number for my ticketing

So I will say like ticket number. And let's have a look for the advanced

Oh, I can even have a prefix. So I will make like broken ticket because I love my name

ticket. Then I'd like to have a four-digit number. I can even make five and the maximum value can be

seed value and the maximum length could be maximum 4,000. If I'm not wrong, it's maximum 4,000

I'll make the maximum 4,000 or we can even change this to make it something like that

You can make an automatic number coming to your list. Let's add some more types

I'd like to add some dates. And then I will just give a date into that date

I will create that. And then I will choose for a choice

And this is my preferred one. And we could choose for the Prio. And I could say, like, is it a high Prio

And I can even choose for a color. A high Prio would be red

Let's choose for a medium, trio for a ticket. I will choose on the color and then I will choose low

and I will choose for another color. If you create that, there you have a new column or a new fill will come just here

Then you can just continue, you can just add more and more and let's add a new one here

Do you want to be informed? Yes or no. Then you can have a default value

I'll create that. There we go. I created my table with my fields

with all my metadata, and I can even change the view from here and make it comfortable

I can make a default, no worries. You can add row, you can add the column, show and refresh

If you add just your data, I could say my phone isn't, okay

And I can add an email. I can't add, as you can't see, a ticket number

because that's a read-only field. That's something done by Microsoft itself. The incident date was yesterday

My prio, I select an option. Remember the colors? It's a high, and I want to be informed

I'm just saving that close. and now what you will see that the application

will now switch over from the custom sample for Microsoft and now I will actually have my info here

If you check out the top, well, you see a bunch of options. I can save my application

I can save it and publish it to Teams and I can preview that

If you preview that, well, it is the application as you want to see it

If I add a new record from here, well, it's going to be the same. My phone is not working

I like to be informed. Yes. My email is going to be the same

The pickup number, I can't fill anything into that. The incident date was in June

I'm just getting a number and the Prio is slow. I'll save that

And that data is now stored into my Dataverse. Easy. Without a single line of code

I now have somewhere a container where it has all my data

I have my application, and I can save and publish that to teams

Let's do that. I will publish this to teams, and I will select my general tab from my team

I save and close. Now, if I go to my team, under the general

Well, you see that there is a new tab appearing just here, the C-sharp corner app

If I open that, now I have within Microsoft Teams my app running on Dataverse

My data is stored in Dataverse. and hey, look to this. I got my GOP ticket 0001 and 101 just here

showing you that I have some automation coming with a ticket number. So whenever I have a ticket number

I could call someone and say, hey, I have that ticket. Could you please have a look for that ticket for me

And I can just continue adding new records from here, editing records or deleting some records from here

In a few clicks, I did build my application. But hey, let's continue and let's see

where the limit is. I have my app. I will just open my app from here

And let's hope it will not crash. Getting things ready. And there we go

My application is here. So the bad thing with that is it's taking the whole screen

and it's not that user-friendly because if you want to change this

and add some data and add some objects, Well, it's not that easy

The good thing with the other application is if I delete that, I have the full screen and I can just add anything I want

I can just come here and add the vertical gallery, connect to my connector

I can just come here, add the button, you know, play and build the perfect application if I'd like to

But with the Dataverse side of stuff, you know, it's already pre-filled for you and it's already, you know, full screen

So what you have to do or what you can do is actually continue building on top of Dataverse

What we will do is we will add some new things, as you can see

I like to add a new screen. If you come back here, well, you can add a new screen

I can choose for scenarios. Like I like to have a calendar page

I like to have an email one, and PowerApp will then build things for you

But if you have the layout, well, you could choose for blank ones, empty ones

and I have my one here. and this is the same experience as on the other one without the dataverse

I can add a bunch of stuff. Let's build some navigation first to show you how easy it is

I come under the plus and I can add some shapes. I will add a next arrow just here

Now, I can play around with that arrow. I can just come here to the properties

and I can change a bunch of stuff with the properties. I can even change the color

but there is one that I'm really interested into is on select. So whenever I select that arrow, what should I do

Today, it's on false. And here I can do a bunch of stuff. And one of them that I really like is navigate

I like you to navigate to screen two. Well, you could easily close that and this will work

But if you add a comma, well, you can choose even for the transition mode

it will ask you, hey, you'd like to go on the cover mode

on the right cover, on the fade, on cover. Well, just let's choose Uncover

I will do the same for my screen too. I will add a new shape, which is then the back arrow just here

I will do exactly the same on the OnSelect property and say

navigate to screen screen one. Again, with a comma, I'll choose the fade one

I have no clue what it does, but it's going to be the fade one. If I come back to my screen and open my first screen

and hit on preview, you will see I have my app. Hey, I have like a 27-inch or 35-inch screen

It's like a huge screen, That's the reason why the logo is not here at the bottom right

It's on the center of the screen. That's normal. If I hit on that button

while you will see I'm actually on the second screen, if I hit back, I'm on the first screen

You can build easily an application built on Dataverse with Microsoft Teams

What you could do is you can come here and play around with objects

You can add easily the vertical gallery and then add some connectors

So what I will do is I will come here and search for a connector

Again, I'm using the SharePoint one. You could use anything else, any other data source that you want to

I'm adding a SharePoint, and now it asks me a question. Do you want to have a connection directly to the cloud, which is called cloud services

or are you using an on-premise data gateway, which is like data from on-premises

I'm saying like, hey, I'm connecting directly to the cloud. and now he will take my token which is basically this one the admin at xgoken.tk and it will show

me the teams where I have access to I will easily just take this one and maybe now take the test

and connect to that and now I have a second connector which is connected on teams I will

just come here and select the data source and choose for test and now you will see that there

is one item into that list and I'm seeing that list. If you don't like the layout, well, you can

definitely change layout from the properties pane. You can go for the title. You can even go for blank

which doesn't make any sense, but hey, you can do it. You can choose for the titles of title and even

go for image and gallery. And then you can still work on top of that. What's the difference? Well

Well, here on the first page, well, you got actually modify, delete, and even add a new record

On the second page, well, you have your gallery, but if I hit on preview, well, you can't do anything with that

It's just showing, oh my gosh, I just hit on the wrong button. But basically, you just can see, and it's up to you to build the knowledge behind that for building the edit, the delete, and the add new record button

So my apologies, I was just too fast. I just hit it on the task by planner button

So let's go back to PowerApp, and hopefully it will work. Because I've seen multiple times that if you just hit multiple times on PowerApp here

sometimes it doesn't load. And that's the reason why I said let's hope that the demo gods are with me

So I will just refresh. It looks like it's, yeah. and I did not save my application

Oh my gosh. I'm so, oh my gosh. So it's no worries. We'll just start over again

So I have my app. I will just come here. Normally it has the auto save every two minutes

So I really hope that it has saved the screen If not we just do it again It will take us a few seconds

Come on, please. OK, it's asking the permissions to SharePoint. That's good

That means that it has. There we go. It has the screens. Good

I have my second screen, as I mentioned. Well, you have to build that intelligence around that

You have the edit, delete, and modify button. Cool. So what you can do is you can definitely add more screens

You can add a lot of options from here. You can add shapes

You can add media, like the camera control, and that's the one that I really love

And the camera control. Oh, it's not here. It's on the other one

Okay, cool. But you can add a bunch of other stuff just here and use them

All right. So that being said, you can publish and save this

and if I go back on the main screen here, well, you have that link as see more

If you hit on see more, well, you will see a new screen, which is like we're moving from the home page to the build

and per team that you have access to and where you have created an environment

well, you will see every artifact, which is part of that one. If I come back to my C-sharp corner

well, you will see that I have an app and I have a table. If I hit on see all, well, now we are actually getting a new pane where you can actually see every single detail of your app and your table

Well, you have the all section where you see every single object you have in your environment

You see every single app you have. You can see the chatbots

You can see the cloud flows. And you can see, and which is the most interesting one, your tables

There's my table, the C-sharp corner database table that we have created

And now you can see every column that you have just here

Normally, it's not on custom. Custom means those ones that I did create

If you hit on all, well, that's basically where the power starts

Somewhere at Microsoft, you have a bunch of people working for you

and building the best model in a database way. so they know that this and this and this and this actually columns are extremely valuable for you

and they just build it for you. It's a huge list and you will see how more applications you create

how more and how longer this list will be. You can see relationships and we will create a relationship in a few seconds

and you can even see your views and see how the data would look like

If you just change this to custom, then you will see only the columns that you have created

If you add a new column, well, herein, I can add a new column

and I can make that very simple tokens column. If I look for the data type, oh, my gosh

you have a bunch of more options herein than we have in the Power App

I now have a whole number, time zone, language, currency, floating point number

multi-line text, etc. Many of them are even not available into the PowerApp

There's a huge difference between creating a column within PowerApp or within the designer of PowerApp because you've got much more options here

What I will do, I will just maybe choose for URL. I don't know

done. And please, please, please don't forget to hit that button. I've forgotten a thousand times

and all the work you have done will be actually gone forever. Please, every single time, hit on

save because with Power Apps, it's tricky. There is an auto save and it saves it for you

But here, if you don't hit on save, well, you will lose every single thing that you have done

just here. You can even from the table side add a new table. Well, before that, let me show that to

you. You can even fill in your table with data. If you hit on get data, and please, please, please

I beg your work, because it takes a lot of time to open that screen. The last time it took like

almost more than 30 seconds to open one screen, and I don't know if it's something to me or it's

the dataverse issue, but now I just hit on a button, it doesn't do anything

Well, basically it does. It's still trying to open that page. It's just taking a lot of time

I don't know why. I'll just wait 5, 4, 3, 2, 0.5, 0.4, 0.3

Oh my gosh. It will open, somehow open, but I will be probably somewhere else when it will open that image

Hey, no worries. But basically, you can get data. You can bring from a bunch of connectors data to your table

or you can even yze this in Power BI. If you hit on that, it will download the file

that you can actually import into Power BI. From herein, you can create a new Canvas app

You can create Cloudflow. You can even create environment variable, but you can also create a table

So let's create a table, and I would like to call it table from designer

And then you can give a name. I will give it a name

And then go on to make it simple. So we can remember that

And now I have a table that should be provisioned in a few seconds

And there we go. I have my table just here, right? And within my table, I can create columns

I can say, like, okay, I can have a name, not maybe gender to make things easy

I can choose for a data pipe. Let's choose for choice. Could be

And that's the thing when you do real life demos, default value, yes

Okay, I have that one, there we go. And don't forget to save

And now I have another table with a few columns just here in

Now you can actually build a relationship between those two tables. And you can just easily come to that table and hit on relationship

and add relationship to many to one. And I can just select my table, which is table from designer

which is my second table, and bring relationship into that. Or you can easily come to the column and say, like, add a new column

and choose for the lookup field and then go to the table from designer and add data on top of that

So doesn matter which one you choose let choose this one and I will choose lookup field Just giving around please don use that in a production environment

I'm just using that to remember that I've done this. I'm using for a lookup field

and it's going to be table from designer. There we go, and I'm creating that new column into my environment

I'm going to save that, and now I have a relationship between those two tables

That means literally if I go to my PowerApp, and I will just come to home

and then I will open and edit my C-Sharp Corner app. Oops, I didn't edit it right

I just hit on that. I'm just going to. Oh, that screen from importing, it just showed up

My gosh, I just closed it too fast. After five minutes, that screen just opened it

So I just was too fast and couldn't show you the screen, my bad

So you can easily come back to your application and hit on the gallery and then edit the fields

And then you can add a new field. And then you will see that there is a lookup field

that we just created here in available. If you add that here

well, you will see that lookup field will just be appearing just here. I will just close that

And if I preview that, well, you will see that if I edit that

there should be items, but there is no items. Well, why? Well, the question is because we didn't fill in

the data in the table. So what we will do is we will come back

to our PowerApp under Home and then go to See More. And then under

my team, I have the See All option. And then I will come back to

Table and then come here, Table from Designer, and fill in data into that one

So how you can do is edit data and then add some data

I will add token and then I will add Simon. Just giving random data hearing

I will close that. And now I have some data into my table, right

If I come back to my Power App under Home, and if I open the C Sharp Corner App

I will override that because it was open now. Because co-authoring is not possible with Power App and Teams

so it asked me to override the permissions. I'm giving it a yes. and now if I edit this back and bring the lookup field

just as we did a few seconds ago, I preview that. I'm editing the option

and now if it worked well, I should see Gokun and Simon. And there we go. I have Simon and Gokun

So I was able to build an application based on top of Dataverse

which had a column and fields and a table. We were even able to add a SharePoint connector

and even able to add a second table and even bring data from the other table

just here into my app. All of that with almost no code

Well, you need to know where to click and what to do and maybe to know a few functions here on top of that

But easily, if I publish this to my teams, if I select my tab, which is here

not the second time, one time is good, I can save this. And now if I go under my team and go under general

well, what you will see is I have my lookup field. If I edit this item, I can even choose a responsible

which could be Simon. I can save that. And this one, maybe the responsible could be Gokin

and save that option as well. I have been talking for 40, 45 minutes

without taking even a second of break. And I think that's all what I had to say

It's 47. Like, we have, like, five minutes left for questions. Simon, I will ask you the question

How was the session? Did you learn at least something today? I really loved it, Guggen

And I really enjoy your session. The best part I love with this session, you always come with this improvement that Microsoft has to do it

Like, sometimes it doesn't load. And I do remember in one of our aim, as you did say

the special characters are not acceptable somewhere. I mean, I don't know how much time you spend on working on this Power Apps and all this, but you always come at a point where you do give a feedback to Microsoft that there's still room of improvement in the application

I'm trying to do my best. So I'd like to thank you, to thank you, all the attendees

My main goal is to learn from you, to learn from the community, and to give back the progress I've made by sharing the knowledge

And that's the reason why I always learn, progress, and share. If there are any questions, I'd love to take them, Simon

Yeah, there are definitely a lot of questions. I think a lot of questions

But let's start with the first one. I really like it. Goken equals to Goku

I really love this comment. Goku. Okay, so this one, let's go one by one, right

We still have, I think, five minutes for it. It's how are Dataverse for teams and Dataverse different

Okay. As I mentioned in the beginning, you have the CDS Dataverse

which is extremely powerful where you have a bunch of functionalities and features that you can do

where you can access data. The most important thing, as I mentioned

is permissions. You can give permissions on the data. You could say that data is accessible for Goken

and no matter from where it comes, you can access the data. As a developer, as an IT pro

I don't have to take care about what application I'm using. It's about the data

If I have access to the data, as the data is in the Microsoft Cloud

and I'm coming with my Microsoft credentials, I can access the data from anywhere

In Microsoft and database for teams, well, you need to have access to your team

and everyone in your team can see the data. So there are a bunch of differentiations

and I will share my slide deck with Simon and Simon, you can do better than these

I have a bunch of links that shows you, and I have already only covered the security

but you have the API, you have the data residency, the security

all of that stuff being actually covered with Dataverse. So Dataverse for Teams is a small part from the Dataverse universe

You have to see it like that. Yeah, yeah, I get it. It definitely makes sense

Let's take another question. I think this would be a quick answer. When to use organization and user table

I think this came in when you were talking about creating tables. When to use organization and user table

an organization and user table I don really get the question but I think I understand what you mean When should we create a table I think the question is

when should we create a table in Dataverse? Well, basically when you create an environment

your app, well, you get your first table which you can pre-fill

When should you create a table? When you have a segregation of data

Like if you have the ticketing engine, I've just created in a few seconds

If you have another data, well, please create another table. The only limitation I see today is about the rows

If you have more than 1 million rows or more than 2 gigabytes of data

well, then Dataverse for Teams is not the best option. Then you have to go for Dataverse and work with Dynamics 365

If you go for Dataverse for Teams, you have a limitation in rows and in data

Dataverse for Teams is good for small or medium applications to be used every single day and data is not that important um if

you have like data which and i know some some organizations where the data should remain for

more than seven years because they're like a banking or the financial sector well then data

versus for things might not be the best option yeah yeah it's definitely for an organization

right within the organization that that's how it kind of works that's what the idea is uh and then

I think this question came in when you were talking about the relationship, but we asked, does it support all SQL relationships

I think most of them it should. It should. I don't know how many, because I'm not a SQL guy

but pretty sure all the relationships should be supported as well. Because at the end, it's the same IT core, it's the same environment

so pretty sure it should. Do you see any more comments you want to take

Can you see the comments? Any more questions you want to take? I haven't have a look

Oh, let me have a look. Oh my gosh, so much. Yeah. If you just scroll down

you'll find the latest one. Let's take this one. It says, can I access this table with

API if yes, any request limit? Yes, you can request. If you're using Dataverse and you have

some tables in your Dataverse, you can access that data. Even like the Maxwell's graph

you can access any data from the, That's the whole idea, to have a central location where data is located

where you can build any application. I now showed Power App, but you could even have Windows Mobile

Xamarin applications, Pordova, SharePoint Framework solutions where you can access that data

Are there any request limits? I'm pretty sure they are. What exactly it is, you have to check on what platform you're using

Yes, table data is accessible through API, that's for sure. Great that you mentioned Microsoft Graph

I really love Microsoft Graph Explorer and all that. I think Microsoft has built a really good product

bringing everything together. And yeah, one API works for all. So that's really great

Yeah, go ahead. Honestly, Dataverse today sounds not familiar for everyone because it was really dynamic centric

But now being perfectly integrated with Power App, with Team, it's going to take a broader audience

a lot of people will start consuming it and who says more consumption says how more possibilities

and how more boxes that we have to fix so i really encourage everyone which is in the chat which is

in the live to consume and report feedback to microsoft yeah yeah that's good let's take final

question gogan i won't take much of the time let's take my one it's from patrice and i think this

question kind of makes sense uh uh uh she's asking how to get started with power effects

So if you go on any of those Power Platform, like even if you go to make.powerapps.com

if you log in, well, you have on the bottom side a lot of websites, links on how to get started

Even if you hit on Google or on Bing, what is Microsoft Data Brew is the first thing

that Microsoft is proposing to you is how to get started. And honestly, if you ask me

and if we leave Microsoft on a site, I would say build your first home app

what is the most annoying thing that you have home? Like, oh, maybe it's like invoices

I like to scan invoices because I'm an independent. I'm a consultant

I need to bring that to X, Y, Z. Or train tickets, I need to keep them for my employer

Like simple apps. And try to build a use case around it and build your first app

And try to fail. Honestly, don't be extremely happy with the first results you have

you should always bring the lab higher and higher and higher and use that artifacts we have in-house

And whenever you are actually done with the in-house things, well, then please have a look

on how Microsoft is doing stuff, what you have been doing wrong. And it's only by learning on what you have been doing wrong

that you can actually learn and bring stuff together. So what I would say, read first all the documentation

start with the whole map, and then try to be more professional with professional apps

and then build them in the enterprise. But first thing always, Cristiano Ronaldo didn't become the world's best footballer

just by training, right? He was also playing home. People did invent Microsoft in the garage, right

It was not directly an enterprise. So it's the same ideology. Try first home, then evolve to an enterprise environment

That's great. some really great questions coming up and the comments in the chat

So thank you everyone who has commented and joined the session. Any final thing, Gokan, before we go ahead and wrap this episode of EMA

Thank you so much. A lot of questions. I can still see a few coming

So if you still need answers, please feel free to reach me out on Twitter

I'll be happy to explain that to you. Please stay safe, stay home, and wear a mask

That's all what I want to say. and I really hope that you have learned at least something and please don't hesitate to share what you have learned

because we are a big family. We are C Sharp Corner. Yeah, thank you

Thank you, Gokhan. That was an amazing session. A lot just covered in 45 minutes

and I believe everyone will join and will join this session at PACE

I would definitely learn a lot from it. We're going to put this video on C Sharp Corner too, not just on YouTube

It will be there on C Sharp Corner in next 24 hours. So you can also go ahead and check there

Thank you, Gokhan, once again. and yeah i'll see you in the azure summit right that that would be great so thank you everyone for

joining see you very soon at you