GM Dynamics & Agentic AI Consulting

A variety of new and highly anticipated features are now available as under-

Trust

• Build apps across multiple tenants with Azure B2B maker
• Improved Canvas App monitoring with Experimental Application Insights Features
• ESLint rules for Power Apps and Dynamics 365
• Creating canvas apps as Dataverse solutions by default

Maker Productivity

• Table designer now in preview in the canvas and model-driven app designers
• Automatically create a Power App from a REST API
• Modern command bar in Canvas
• Install Apps via Power Platform CLI & Install API

Please refer below link for more information –

https://powerapps.microsoft.com/en-us/blog/whats-new-power-apps-august-2022-feature-update/?utm_campaign=Power%20Platform%20Developers%20Weekly&utm_medium=email&utm_source=Revue%20newsletter

The access levels show the level at which a user can interact with rows within a given table. The portion of the circle filled illustrates the levels. The levels are None, User, Business Unit, Parent-Child Business Unit, and Organization. You need to click in the circle to change the level. Each click with change the fill and/or color. Click in the circle until it is the level desired is selected.
● User level (basic): This gives a user access to rows that the user owns or anything shared with the user or team that the user belongs to. You would want to use this setting if you want the user only to access their own rows. You would not want salespeople to be able to delete other sales people’s accounts or leads.
● Business Unit (local): This allows access to the data of other users in a business unit. A business unit has to be setup within Dynamics 365 and can be a hierarchy of a department. Sales managers would want to see all his/her subordinates’ rows
● Parent-Child Business Units (deep): This will give the user access to all the business units they belong to along with any business units that are subordinate to the user’s business unit.
● Organizational (global): This user has access to all the rows in the organization. If you have a Salesperson able to add products from any level of the organization, you would want him to have access to all the organizational products and not just the ones available for his business unit.

Create a trial account to check the Power Pages.

Next page will be as under then you can select as per your preference, or you can skip too. But I selected as I don’t have any experience to see what’s next for me 😊

Next, I have been prompted with, to select a template for my site or else you can select Blank page too to start from scratch.

Let’s proceed to select an existing template as I am a layman. You can preview the template before selecting in Desktop and Mobile mode. If you want to proceed with the template, click on ‘Choose this template’.

After choosing the template it will prompt us to select site name and available web address as per below snapshot.

Once you click on ‘Done’ then it will display a design studio with tools to build my website. You can preview the site clicking on Preview button on right top.

Under Pages tab you can add and modify pages.

Under Styling tab, you can add and modify designs of the page with styling options.

Under Data tab you can add your fresh new table, or you can use existing table from Dataverse.

Under Setup tab you can add your security settings and permissions.

If you have no coding experience then you can use the tools available on design studio or else you can use ‘Edit Code’ on right top to write the code for your site and then sync it to reflect as under,

 After easy modifications and changes now, my site is ready as under,

By Default site is Private which you can configure to make it public using set up tab as under,

Power Automate offers a rich experience when it comes to connecting to other services. With a toolkit of over 780 connectors, cloud flows can interact with the most popular services that are accessible by API.

Using cloud connectors in RPA scenarios was a more complex and time-consuming process as, in many cases, it required loops between cloud and desktop flows. Now Microsoft made available all cloud connectors from within Power Automate desktop’s designer.

Please refer below link for more information –

https://powerautomate.microsoft.com/en-us/blog/preview-of-sharepoint-cloud-actions-in-power-automate-for-desktop-introducing-cloud-connectors-in-desktop-flows/?utm_campaign=Power%20Platform%20Developers%20Weekly&utm_medium=email&utm_source=Revue%20newsletter

A Table is a collection of records with different types of data related to the particular entity.

Table is a kind of container which contains multiple types of data.

Each table corresponds to database table and each column which is also known as attribute within a table represent a column in that table.

What is Metadata?

In Dataverse metadata (data about data) is a collection of tables. Table metadata is what controls the kinds of rows you can create and what kind of actions performed on them.

Standard Vs Custom Tables:

Standard tables are those whose comes up with your dataverse environment whereas Custom tables will create as per the requirement of data.

You can edit the name of the standard tables and their columns as well but can’t be delete it whereas in custom tables you can edit the name of tables and columns, also you can delete your custom table.

Usually with standard tables you can continue your work as you expected with some minor changes of edit the table or column name but if standard table does not match your business requirement then its mandatory to create your own custom tables.

Table Relationships:

In normal database we have multiple types of relationships to connect multiple tables to achieve the desired goal. In Dataverse, we have only two types of relationships:

One-to-Many:

In one-to-many relationship, many table rows are associated with single primary row table in a parent/child relationship. In this relation, one parent can have multiple child with different attributes to achieve the goal.

Many-to-Many:

In many-to-many relationship, many table rows are associated with many other table rows. Those rows that are related with N:N relationships are considered peers. In this relation, many table rows are associate with other table rows to performed actions on them. Many-to-Many relationship is most commonly used relation between tables.

Types of Tables:

In dataverse we have two types of tables exist, you should understand these types of tables of dataverse. Once custom table created then you cannot change its type. We have following two types of tables in dataverse:

User or Team Owned:

In this type actions can be performed on user level or team level. Only users or team can be performed actions on it according to their rights

Organization Owned:

Access to data is controlled on Organization level. In this type any organization user who have rights at organization level can be performed actions on it.