What do we need to build an Enterprise app we are in the age of AI we need powerful built-in AI capabilities and analytics we need Advanced business logic and Eventing buil-in data modeling.
Capabilities allow us to work with any type of data deep integration capabilities with other areas of Microsoft 365 it should be as easy as Excel where I.
Can simply connect to my Enterprise data and with co-pilot's assistance I should be able to build this application quickly all of this with Enterprise grade security and the ability for the.
Platform to scale and data ver is the answer to all of those capabilities from sophisticated security to the ability to build complex.
Limits from a SharePoint perspective we do have the ability to store up to 30 million Rec however you will need to plan for performance you would have come across.
The view threshold limit or the limits in the number of complex type columns that you can create and more datae is a relational database SharePoint is.
Not datae offers a diverse set of Rich data types it comes with robust sec Security Options that can meet your complex security.
Requirements data verse being the data layer of the Power Platform offers a lot of benefits one of the examples is the ability for power app to handle large volumes of data for data verse which.
Offers the highest flexibility from a delegation perspective data ver being solution aware having native backup facility it's already built for mobile.
Posts Related:
- Python Part 14a - Working with numbers Office
- How To Generate Single & Batch QR Codes With Excel Free Download Office
- SQL Server Queries Part 2 - ORDER BY (Sorting in Queries)
Offline we are not limited to the type
Of applications we can build we can build canvas apps model driven apps power Pages business rules and so much more that databas has to.Offer I have a SharePoint list called projects that has different types of columns project title single line of text description multi-line status type Choice start date.
And end date which are date type columns now let's see how we can import this list into a table and data verse by taking the assistance of co-pilot in power apps we have two.
Options to do this one option is we can go to tables and here is the new create with SharePoint list feature if I select.
This I can enter my SharePoint site pick my SharePoint list and go through the process of importing it as a table the other option is if we go to the home screen and start with.
Data we have an option create with SharePoint list here as well it will import the list data into a data ver table but it will also create a canvas app for.
Us I'll pick my SharePoint side I'll pick my list that I would like to import click next copilot starts viewing its.
Magic it provides a preview of my table it recommends a name for my table which I can edit and change it also plugs in a description for us in this case it states that the.
Data is being originated from my SharePoint list and the primary column that it is mapping to is Title Here is title which is a column of type single line of text if I would like.
To make it a required field I can do
That right here and update description it's a multi-line of text [Music].Column status smart enough to know that status was a choice column in my SharePoint list it plugs in the choice values I can add more I can also pick a default choice for any new record that.
Gets created start date and end date both are mapped to date fields once I am ready all I have to do now is Click.
Create app and the process begins and here is canvas power app data is connected to my table called project if I go to edit.
Data here is the table and data verse with the columns column types and all the data coming in from SharePoint and at this point I have a canvas app that shows all my.
Projects I can create new projects I can edit existing projects I can delete a project full crud operations plus this is a fully responsive canvas power app in.
Action now let's level up I also have another list these are the tasks for a project and when a task is created it is mapped to a specific project by using a lookup.
Column experience a task can be assigned to a user assign to is a person type column in SharePoint wherein I can pick users from.
Active directory back to power apps if I go to tables and say create from SharePoint list because I would like to import the next list which is the list of.
Tasks connect to my SharePoint site connect to my task list and click next here is the preview of the table that it would be creating the text columns the choice.
Columns date columns they are being handled fine but when we talk about the lookup column if you notice here currently it does not support the lookup column which.
Creates a relationship between two tables in data ver plus assign to is a person type column in SharePoint it's bringing that data in the form of text so how would I.
Go about mapping this as a lookup column once again that looks up to another table in data verse which is the users's table so to perform the action of importing the data from the tasks table.
Under tables I will head over to import and select import data I'll select SharePoint online list put my SharePoint site URL plugin my.
Credentials click next this will list out all the tables in my SharePoint list I'm looking out for my list called tasks I'll select this shows a preview.
Of the data that it will be importing this also includes all the internal columns in SharePoint I'll click next and now I land in power query where I can perform.
Data Transformations from my task list I am only interested in importing these seven columns so the first step I'll take here is click choose Colum.
Columns remove select all and pick the columns that I would be interested in importing here's project lookup and assigned to is the person type column click.
Okay so this brings in all this information project lookup and assigned to notice they come in the form of a record because they are complex type columns so I need to take additional.
Steps now to get the information out of those columns so for that I will add a column custom column I'll call it project lookup.
Title I'll pick project lookup for the formula and from within this record go and grab the title column information from my lookup list I'll click.
Okay and here is Project lookup title I'll perform similar steps for assign to custom column I'll call this assign to email for.
Formula I'll pick assign two to pick email capital e capital M and then lowercase a i l I'll click okay there I have the email.
Addresses project Lookout and assign to I do not need these columns so I can right click remove right click remove I can even confirm the data types.
So title text du date I'll pick date now I can click next now if I try load this to a new table called.
Tasks these are the source columns these are the columns that it will be creating and these are the data types that I can select I am still not able to create a.
True relationship with my project table and also for my assigned to person type column so in order for me to do that I'll open a separate tab go back to.
Tables I will go and create a new table I'll pick set Advanced properties so I get the standard table creation dialogue experience I'll give my table a.
Name the primary column the display name for that is set to name I'll keep it as is click save and this creates a new table called task name is where I would like to store.
