PL-900 Microsoft Power Platform – Other Power Platform Topics Part 2

5. 16. Data Loss Prevention (DLP) policies

Now, you will have no doubt notice that we’ve got a lot of data in the power platform. For example, if we go into the data first into the tables, we’ve got things like contacts, so personal data. Then if we go into the connectors and we look at the various connectors, we’ve got things like SharePoint, but also, so we got things like Twitter, I’ll probably have to scroll down an awful lot, twitter, Facebook, that sort of thing. Now what’s to stop somebody going, okay, I’ve got my contact tables, I’m just going to upload them onto Facebook. It doesn’t matter how personal the data is.

Well, this is when if I go back to the power platform admin center, we have some data loss prevention policies, DLP. These policies help prevent company data from being accidentally made public. Now you need some certain rights to correct these. You need for instance, the environment admin or the tenant admin that’s the company admin to create the DLP policies. What it does is it restricts access to connectors. So you can apply this, it can be scorped at the environment level or the tenant level and then all environments or some environments you can select.

So if I click on new policy, first of all, I want to give my policy a name, then I want to have a look at the connectors. So you can see hundreds of connectors. Now, all connectors will by default show up in the non business section. This is for personal use. In other words, there’s nothing here in these connectors which is company specific, company personal data. If there is, then you should assign them into the business section. So for instance, let’s have a look for our data verse or maybe Twitter or something like that. It’s still listed here under the common data service. So what I’m going to do is move this into business.

So now we’ve got one connector which is business and one connector or 436 connectors which are not business, but only one connector that you’d probably use. So what this does is it stops data from being shared with connectors in other groups. So you cannot have a connector which has got sensitive data leading on to a connector for non sensitive data. It would just stop it. Now you may have noticed when I was moving this that it said one or more of the selected connectors can’t be blocked. So there is a third category for blocked. This says don’t use this connector.

So you can’t put into block the power platform connectors or dataverse or approvals or notifications or anything to do with Microsoft 365 Enterprise, so Excel, Online Teams, Groups, Outlook Users, OneDrive Power, Bi or SharePoint. However you can put them into business. And so here we have a common data service which cannot now be used with any of the other connectors.

So in summary, the DLP policy, the data loss prevention policies will prevent a business connector as being defined in a particular policy from being connected to a non business connector as defined in the same policy and blocked connectors cannot be used at all. And you can do this at an environment level or at the organizational tenant level and then cascade downwards as appropriate. Now, there are more than one policies that you can do.

This is not the only policy I could set up. However, if I set up another policy which says that the database is not business so non business connector, it starts to get a bit complicated. You don’t need to go into this complication for this particular course or certification, but I would just select as few policies as possible to have consistencies. So DOP policies will prevent a business connector in one policy from being connected to a nonbusiness connector in the same policy and it will also block other connectors.

6. 17. Privacy and accessibility guidelines

In this video, we’re going to look how the Power Platform supports privacy and accessibility guidelines. I’m going to start with the GDPR. This is the European Union’s General Data Protection Regulation, and it is something that other places such as California are using for their data protection regulations. Power platform supports GDPR. The data is protected.

For instance, data in transmit is secured. It uses something called TLS transport layer security. Version one, two or higher is used to access server endpoints. In other words, how you can actually gain access to the Power platform. I send a request for my web browser and it then uses TLS one, two or higher to provide enhanced security once it reaches the server going back to the browser API access so that’s programming access is supported in the same way.

So for more details about how Microsoft supports GDPR, then have a look at this website. But you won’t be required to know too much detail at all about the GDPR, just need to know that it is secure in terms of privacy. Now, accessibility. I’m just going to have a look at one of the apps that we created as part of this course. And if I click on this button here, we can get a look at the App checker. And one of the things that we can see in the app checker is accessibility.

So this shows us things that we might want to resolve. Errors are issues that make the app hard to use for people who have a disability. There are warnings might be difficult to use for most people who have a disability. And then there are tips to help you improve the experience of users. So things we’re looking at, for instance, missing accessible label. So when an accessible label property contains no text, there may be other things like missing captions, missing helpful control settings when an audio or video control autostart is set to choose.

That could be difficult for people with disability to know what’s happening when the items in the screen aren’t in this proper order, when you tab through them, if they’re not going from top to bottom like I just did there. And if you’re using a pen control, a tip there would remind you to include a separate, more user friendly method of input for people with disabilities. So the app checker allows you to see how your app would best function for people with certain disabilities. So this is how Power Platform supports privacy and accessibility guidelines.

7. 7. Dynamics 365 and Power Platform

In this video, we’re going to have a look at how Dynamics Three Six five apps can accelerate the delivery of power platform business solutions. Now, you can see on the screen one of the marketing pages for Dynamics Three Six five. And you can see the sort of interface that they have looks remarkably similar to all of the power apps and power automate and so forth.

Now the apps include things like Dynamics Three Six five sales, customer service, field service, marketing and power automation. And they use the dataverse to store data. So you could use power platform against data stored in the Dynamic 365 apps using the data verse connector. Now you should note that there is a Dynamics 365 connector, but it is deprecated.

So in other words, it’s not going to be supported in future. Now, why are there some other Dynamics 365 apps? Well, because for Dynamics 365 business Central customer insights and finance and operations, which as you can see is here called the fin and ops and it’s also called Dynamics 365 finance and Dynamics 365 supply chain management, these Dynamics 365 apps don’t use the data first and therefore you should use a different connector for them. So Power platform, you can take information from Dynamics 365 using the data verse connector or frequently the Dynamics 365 for fin and ops connector. Get the data in.

Do perhaps one of your flaws, you can see some of the flaws that don’t are on the screen here, quite a variety of them, and then create an action based on it. And just one more small piece about Dynamics 365. If you want to test against something occurring in Dynamics 365, then the technical name for that is to use a trigger when a business event arrives.

So Dynamics 365, you can use the data that’s already in there or one of the connectors to accelerate your delivery of power platform business solutions. And of course you can also use Dynamics 365 in Power bi. So if I get data and search for dynamics, you can see we have some of the connectors available, but for the majority of them, outside of finance and operations and customer insights and business central, you should use the A database connector.

8. 8, 9. Microsoft 365 and Power Platform

Now in this video, we’re going to have a look at how we can use Power platform with Microsoft 365. Well, first of all, we can use the connectors. So if you have a look at some of the connectors, we can connect to files using Excel, Text, CSV, XML and JSON folder and Parquet. And there’s also the shared SharePoint folder. They’ll connect to files. We can connect to databases using the SQL Server database, the Access database, the SSAs database, and many more. We can also connect to online services such as SharePoint Online List. So unlike the SharePoint folder. This connects to lists Microsoft Exchange online and Dynamics 365 online. We can also connect to other things such as SharePoint lists, as opposed to SharePoint Online Lists and Microsoft Exchange.

So those are some of the connectors in Power Bi. And needless to say, in Power apps you can also have similar connections as well. You may need a gateway if you’re going to a local file, for instance, but the connections are available. Now, with regards to Microsoft Teams, then there are four ways in which you can use Power apps with Microsoft teams. First of all, you can have canvas apps as either a tab app or a personal app. You can embed a model driven app, and you can use Microsoft database for teams to create canvas apps within teams.

And then finally in Microsoft Automate, if I look for Office here, you can see lots of different ways in which Microsoft 365, including Office, can be used with Microsoft Automate. So perhaps you want to share your email attachments to a document library or send approval and follow up by email. And if we have a look for teams, post messages to Microsoft teams when a new task is created in Microsoft Planner, for instance. So there are lots of ways in which you can integrate Power platform into Microsoft 365, and the other way around, especially publishing your Power apps into Microsoft teams.

9. 10, 11. Microsoft Azure, Third-party apps, and Power Platform

Turning to Microsoft Azure. So this is Microsoft cloud based services. There are lots of different ways and obviously there are lots of different services that you can use. Now, this isn’t a course on Azure. If you’re interested in that, you might be interested in the AZ 900 certification or the DP 900 certification just now. There are lots of different services that that can connect in power Bi. For instance, if I get data in, then I can get data in using an Azure SQL database or Synapse Analytics.

So that’s a data warehouse or analysis services or lots of different types of database. So we’ve got Database for Progress QL for instance, among others, we’ve got Blob storage. These are binary large objects, blob or table storage. Cosmos DP is a non relational database, data lake storage, gen two. So this is for unsorted data. When you get washed with huge amounts of data, you need somewhere to store it and then you can organize it later, maybe in an analytics warehouse, maybe using HD Insight, maybe using Databricks.

So you won’t be required to know any of the intricacies of Azure in this particular certification, just know that they exist and basically they stole data. And then finally, let’s have a look at some of the other sorts of third party apps and services. So, we’ve got various databases, of course. We’ve got Oracle database. IMD DB two informics. Nextilla. MySQL pulsegrsql.

These two of course, can also be hosted on Azure, but I suppose maybe even of more interest in the various sorts of databases you can have is for instance, social media. So you can use it with Yamaha or Slack, instagram, you can use it with Twitter as your active directory, with email, with events. So we’ve seen previously in this course that we can look at the 20 most recent posts, for instance, and do something with that. So, Power platform, you can consume Microsoft Azure services and you can consume a whole array of third party apps and services with over 200 connectors to your data.