{"id":88,"date":"2018-05-30T03:08:11","date_gmt":"2018-05-30T10:08:11","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/"},"modified":"2018-05-30T03:08:11","modified_gmt":"2018-05-30T10:08:11","slug":"gdpr-admin-powershell-cmdlets","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/","title":{"rendered":"PowerShell Cmdlets for PowerApps and Flow creators and administrators"},"content":{"rendered":"Many of you have been asking for access to PowerApps and Flow control through PowerShell. This week we have released an extended version of the <a href=\"https:\/\/docs.microsoft.com\/en-us\/powerapps\/administrator\/powerapps-powershell\">PowerApps PowerShell script functions<\/a> (cmdlets) that provide admin access to resources on their instance of PowerApps, Flow, and the Business Application Platform in the PowerShell environment.\n<h1>Updates<\/h1>\n<!-- \/wp:heading --> <!-- wp:list -->\n<ul>\n<li><strong>2019-01-07<\/strong>: Cmdlets are now available on the PowerShell gallery as two separate modules: Administrator (<a href=\"https:\/\/www.powershellgallery.com\/packages\/Microsoft.PowerApps.Administration.PowerShell\/2.0.1\">link<\/a>) and Maker (<a href=\"https:\/\/www.powershellgallery.com\/packages\/Microsoft.PowerApps.PowerShell\/1.0.1\">link<\/a>).<\/li>\n<li><strong>2019-04-29:<\/strong> Updated cmdlet names<\/li>\n<\/ul>\n<!-- \/wp:list --> <!-- wp:heading -->\n<h1>Cmdlets<\/h1>\n<!-- \/wp:heading --> <!-- wp:paragraph -->\n<a href=\"https:\/\/msdn.microsoft.com\/en-us\/library\/ms714395(v=vs.85).aspx\">Cmdlets<\/a>\u00a0are functions written in PowerShell script language that execute commands in the Windows PowerShell environment. Running these PowerApps cmdlets will allow you to interact with your Business Application Platform without having to go through the admin portal in a web browser. You can combine these cmdlets with other PowerShell functions to write complex scripts that can optimize your workflow. Note that you can still use the cmdlets if you\u2019re not an admin on the tenant, but you will be limited to the resources you own. Cmdlets that start with the word \u2018Admin\u2019 are designed to be used by an administrative user account.\n\n<!-- \/wp:paragraph --> <!-- wp:heading -->\n<h1>Installation<\/h1>\n<ol>\n<li>Run PowerShell as an administrator\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone size-medium wp-image-1039\" height=\"300\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/01\/powershell-run-as-admin-175x300.png\" style=\"font-size: 1rem\" width=\"175\"\/><\/li>\n<li>Execute the following import commands:\n<pre style=\"color: #333333;background-color: #efefef;border: 1px solid #e6e6e6\"><span style=\"color: #333333;background-color: #efefef\">Install-Module -Name Microsoft.PowerApps.Administration.PowerShell\nInstall-Module -Name Microsoft.PowerApps.PowerShell -AllowClobber\n<\/span><\/pre>\n<\/li>\n<li>If you are prompted to accept the change to InstallationPolicy value of the repository, accept [A] Yes to all modules by typing in &#8216;A&#8217; and hitting enter for each module.\n<img loading=\"lazy\" decoding=\"async\" alt=\"\" class=\"alignnone wp-image-1054 size-full\" height=\"353\" src=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2018\/05\/Step-3.png\" width=\"990\"\/><\/li>\n<li>Before accessing any of the commands, you have the option to provide your credentials using the following command. These credentials are refreshed for up to ~8 hours before you&#8217;re required to sign in again to continue using the cmdlets.\n<pre style=\"color: #333333;background-color: #efefef;border: 1px solid #e6e6e6\"># This call opens prompt to collect credentials (AAD account &amp; password) used by the commands\nAdd-PowerAppsAccount<\/pre>\n<pre style=\"color: #333333;background-color: #efefef;border: 1px solid #e6e6e6\"># Here is how you can pass in credentials (avoiding opening a prompt)\n$pass = ConvertTo-SecureString \"password\" -AsPlainText -Force\nAdd-PowerAppsAccount -Username foo@bar.com -Password $pass<\/pre>\n<\/li>\n<\/ol>\n<h2>Prerequisite<\/h2>\n<h3>App creators<\/h3>\nUsers with a valid PowerApps license can perform the operations in these cmdlets, but they will only have access to the resources (for example, apps, flows, etc.) that have been created or shared with them.\n<h3>Administrators<\/h3>\nTo perform the administration operations in the admin cmdlets, you&#8217;ll need the following:\n<ul>\n<li>A paid PowerApps Plan 2 license or a PowerApps Plan 2 trial license. You can sign-up for a 30-day trial license at <a href=\"https:\/\/web.powerapps.com\/trial\">https:\/\/web.powerapps.com\/trial<\/a>. Trial licenses can be renewed if they&#8217;ve expired.<\/li>\n<li><a href=\"https:\/\/support.office.com\/article\/assign-admin-roles-in-office-365-for-business-eac4d046-1afd-4f1a-85fc-8219c79e1504\">Office 365 Global Administrator<\/a> or <a href=\"https:\/\/docs.microsoft.com\/azure\/active-directory\/active-directory-assign-admin-roles-azure-portal\">Azure Active Directory Global Administrator<\/a> permissions if you need to search through another user\u2019s resources. (Note that Environment Admins only have access to those environments and environment resources for which they have permissions.)<\/li>\n<\/ul>\n\u00a0\n<h2>Cmdlet list<\/h2>\n<h3>Maker Cmdlets<\/h3>\n<table style=\"font-size: 12px\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"60%\"><strong>Purpose<\/strong><\/td>\n<td valign=\"top\" width=\"40%\"><strong>Cmdlet<\/strong><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read environments<\/td>\n<td valign=\"top\" width=\"40%\">Get-PowerAppEnvironment\nGet-FlowEnvironment<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete a canvas app<\/td>\n<td valign=\"top\" width=\"40%\">Get-PowerApp (Previously Get-App)\nRemove-PowerApp\nPublish-PowerApp\nSet-PowerAppDisplayName\nGet-PowerAppVersion\nRestore-PowerAppVersion<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete canvas app permissions<\/td>\n<td valign=\"top\" width=\"40%\">Get-PowerAppRoleAssignment\nSet-PowerAppRoleAssignment\nRemove-PowerAppRoleAssignment<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete a flow<\/td>\n<td valign=\"top\" width=\"40%\">Get-Flow\nGet-FlowRun\nEnable-Flow\nDisable-Flow\nRemove-Flow<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete flow permissions<\/td>\n<td valign=\"top\" width=\"40%\">Get-FlowOwnerRole\nSet-FlowOwnerRole\nRemove-FlowOwnerRole<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read and respond to flow approvals<\/td>\n<td valign=\"top\" width=\"40%\">Get-FlowApprovalRequest\nGet-FlowApproval\nRespondTo-FlowApprovalRequest<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read and delete connections<\/td>\n<td valign=\"top\" width=\"40%\">Get-PowerAppConnection\nRemove-PowerAppConnection<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete connection permissions<\/td>\n<td valign=\"top\" width=\"40%\">Get-PowerAppConnectionRoleAssignment\nSet-PowerAppConnectionRoleAssignment\nRemove-PowerAppConnectionRoleAssignment<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read and delete a connector<\/td>\n<td valign=\"top\" width=\"40%\">Get-PowerAppConnector\nRemove-PowerAppConnector<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete custom connector permissions<\/td>\n<td valign=\"top\" width=\"40%\">Get-ConnectorRoleAssignment\nSet-PowerAppConnectorRoleAssignment\nRemove-PowerAppConnectorRoleAssignment<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\u00a0\n<h3>Admin Cmdlets<\/h3>\n\u00a0\n\nRead, update, and delete environments and Common Data Service databases\n<table style=\"font-size: 12px;height: 1148px\" width=\"604\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete environments and Common Data Service databases<\/td>\n<td valign=\"top\" width=\"40%\">New-AdminPowerAppEnvironment\nSet-AdminPowerAppEnvironmentDisplayName\nGet-AdminPowerAppEnvironment\nRemove-AdminPowerAppEnvironment\nNew-AdminPowerAppCdsDatabase\nGet-AdminPowerAppCdsDatabaseLanguages\nGet-AdminPowerAppCdsDatabaseCurrencies\nGet-AdminPowerAppEnvironmentLocations\nRemove-LegacyCDSDatabase <strong>*New*<\/strong><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete environment permissions (does not work in environment with CDS for Apps database)<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminPowerAppEnvironmentRoleAssignment\nSet-AdminPowerAppEnvironmentRoleAssignment\nRemove-AdminPowerAppEnvironmentRoleAssignment<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read and remove canvas apps<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminPowerApp\nRemove-AdminPowerApp\nGet-AdminPowerAppConnectionReferences<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete canvas app permissions<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminPowerAppRoleAssignment\nSet-AdminPowerAppRoleAssignment\nRemove-AdminPowerAppRoleAssignment\nSet-AdminPowerAppOwner<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete Flows, Owner Roles, and Approvals<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminFlow\nEnable-AdminFlow\nDisable-AdminFlow\nRemove-AdminFlow\nGet-AdminFlowOwnerRole\nSet-AdminFlowOwnerRole\nRemove-AdminFlowOwnerRole\nRemove-AdminFlowApprovals<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read and delete connections<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminPowerAppConnection\nRemove-AdminPowerAppConnection<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete connection permissions<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminPowerAppConnectionRoleAssignment\nSet-AdminPowerAppConnectionRoleAssignment\nRemove-AdminPowerAppConnectionRoleAssignment<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read and delete custom connectors<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminPowerAppConnector\nRemove-AdminPowerAppConnector<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read, update, and delete custom connector permissions<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminPowerAppConnectorRoleAssignment\nSet-AdminPowerAppConnectorRoleAssignment\nRemove-AdminPowerAppConnectorRoleAssignment<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Set canvas app as hero<\/td>\n<td valign=\"top\" width=\"40%\">Set-AdminPowerAppAsHero\nClear-AdminPowerAppAsHero<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Set canvas app as featured<\/td>\n<td valign=\"top\" width=\"40%\">Set-AdminPowerAppAsFeatured\nClear-AdminPowerAppAsFeatured<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Set canvas app to bypass api consent<\/td>\n<td valign=\"top\" width=\"40%\">Set-AdminPowerAppApisToBypassConsent\nClear-AdminPowerAppApisToBypassConsent<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read a user&#8217;s PowerApps user settings, user-app settings, and notifications<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminPowerAppsUserDetails<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Returns a list of app connection references<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminPowerAppConnectionReferences<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Read &amp; delete a user&#8217;s Microsoft Flow settings, which are not visible to user, but that support flow execution<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminFlowUserDetails\nRemove-AdminFlowUserDetails<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"60%\">Create, read, update &amp; delete data loss prevention policies for your organization<\/td>\n<td valign=\"top\" width=\"40%\">Get-AdminDlpPolicy\nAdd-AdminDlpPolicy\nRemove-AdminDlpPolicy\nSet-AdminDlpPolicy\nAdd-ConnectorToBusinessDataGroup\nRemove-ConnectorFromBusinessDataGroup<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\u00a0\n<h2>Tips<\/h2>\n<ul>\n<li>Use Get-Help \u2018CmdletName\u2019 to get a list of examples.<a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/f1bcaf8c-d5aa-4d44-88af-fe1c6d8a6ddd.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"364\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/f1bcaf8c-d5aa-4d44-88af-fe1c6d8a6ddd.png\" style=\"border: 0px currentcolor\" title=\"image\" width=\"760\"\/> <\/a><\/li>\n<li>To cycle through the possible options for input tags, click on the tab key after typing out the dash (-) character, after the cmdlet name.<\/li>\n<\/ul>\n\u00a0\n<h2>Operation examples<\/h2>\nBelow are some common scenarios that show how to use new and existing PowerApps cmdlets.\n\n\u00a0\n<h3>Environments Commands<\/h3>\nUse these commands to get details on and update environments in your tenant.\n\n\u00a0\n<h4>Display a list of all environments<\/h4>\n<code>Get-AdminEnvironment<\/code>\n\nThis returns a list of each environment across your tenant, with details of each (e.g., environment name (guid), display name, location, creator, etc).\n\n\u00a0\n<h4>Display details of your default environment<\/h4>\n<code>Get-AdminEnvironment \u2013Default<\/code>\n\nReturns the details for only the default environment of the tenant.\n\n\u00a0\n<h4>Display details of a specific environment<\/h4>\n<code>Get-AdminEnvironment \u2013EnvironmentName \u2018<em>EnvironmentName<\/em>\u2019<\/code>\n<em>Note: The EnvironmentName field is a unique identifier, which is different from the DisplayName (see first and second fields in the output in the following image).<\/em>\n<strong><a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/825bd39b-fe21-4138-918a-77c84d1996dd.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"298\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/825bd39b-fe21-4138-918a-77c84d1996dd.png\" style=\"border: 0px currentcolor\" title=\"image\" width=\"760\"\/> <\/a> <\/strong>\n\n\u00a0\n<h3>PowerApps Commands<\/h3>\nThese operations are used to read and modify PowerApps data in your tenant.\n<h4>Display a list of all PowerApps<\/h4>\n<code>Get-AdminPowerApp<\/code>\n\nReturns a list of all PowerApps across the tenant, with details of each (e.g., application name (guid), display name, creator, etc).\n<h2><\/h2>\n<h4>Display a list of all PowerApps that match the input display name<\/h4>\n<code>Get-AdminPowerApp '<em>DisplayName'<\/em><\/code>\n\nReturns a list of all the PowerApps in your tenant that match the display name.\n<h6><em>Note: Use quotation characters (&#8221;) around input values that contain spaces.<\/em><\/h6>\n\u00a0\n<h4>Feature an application<\/h4>\n<code>Set-AdminPowerAppAsFeatured \u2013AppName '<em>AppName'<\/em><\/code>\n\nFeatured applications are grouped and pushed to the top of the list in the PowerApps mobile player.\n\n<em>Note: Like environments, the AppName field is a unique identifier, which is different from the DisplayName. If you want to perform operations based on the display name, some functions will let you use the pipeline (see next function).<\/em>\n\n\u00a0\n<h4>Make an application a Hero app, using the pipeline<\/h4>\n<code>Get-AdminPowerApp 'DisplayName' | Set-AdminPowerAppAsHero<\/code>\n\nA Hero app will appear at the top of the list in the PowerApps mobile player. There can only be one Hero app.\n\nThe pipeline (represented as the \u2018|\u2019 character between two cmdlets) takes the output of the first cmdlet and passes it as the input value of the second, assuming the function has been written to accommodate the pipeline feature.\n\n<em>Note: an app must already be a featured app before it is changed to a hero.<\/em>\n\n\u00a0\n\n\u00a0\n\n\u00a0\n<h4>Display the number of apps each user owns<\/h4>\n<code>Get-AdminPowerApp | Select \u2013ExpandProperty Owner | Select \u2013ExpandProperty displayname | Group<\/code>\n\nYou can combine native PowerShell functions with the PowerApps cmdlets to manipulate data even further. Here we use the Select function to isolate the Owner attribute (an object) from the Get-AdminApp object. We then isolate the name of the owner object by pipelining that output into another Select function. Finally, passing the second Select function output into the Group function returns a nice table that includes a count of each owner\u2019s number of apps.\n\n<a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/897567c6-8f4a-4d0c-9454-560a861ff968.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"152\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/897567c6-8f4a-4d0c-9454-560a861ff968.png\" style=\"border: 0px currentcolor\" title=\"image\" width=\"760\"\/> <\/a>\n\n\u00a0\n<h4>Display the number of apps in each environment<\/h4>\n<code>Get-AdminPowerApp | Select -ExpandProperty EnvironmentName | Group | %{ New-Object -TypeName PSObject -Property @{ DisplayName = (Get-AdminPowerAppEnvironment -EnvironmentName $_.Name | Select -ExpandProperty displayName); Count = $_.Count } }<\/code>\n<a href=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/c018e96f-150e-459a-9fe7-cc1d4bbaffee.png\"><img loading=\"lazy\" decoding=\"async\" alt=\"image\" border=\"0\" height=\"196\" src=\"https:\/\/pwrappscdn.azureedge.net\/mediahandler\/blog\/media\/PowerApps\/blog\/c018e96f-150e-459a-9fe7-cc1d4bbaffee.png\" style=\"border: 0px currentcolor\" title=\"image\" width=\"760\"\/> <\/a>\n\n\u00a0\n<h4>Download PowerApps user details<\/h4>\n<code>Get-AdminPowerAppsUserDetails -OutputFilePath '.\\adminUserDetails.txt' \u2013UserPrincipalName \u2018admin@bappartners.onmicrosoft.com\u2019<\/code>\n\nThe above command will store the PowerApps user details (basic usage information about the input user via their user principal name) in the specified text file. It will create a new file if there is no existing file with that name, and overwrite the text file if it already exists.\n\n\u00a0\n<h4>Set logged in user as the owner of a PowerApp<\/h4>\n<code>Set-AdminPowerAppOwner \u2013AppName '<em>AppName'<\/em>\u00a0-AppOwner $Global:currentSession.userId \u2013EnvironmentName '<em>EnvironmentName'<\/em><\/code>\n\nChanges the owner role of a PowerApp to the current user, and replaces the original owner as a \u201ccan view\u201d role type.\n\n<em>Note: The AppName and EnvironmentName fields are the unique identifiers (guids), not the display names.<\/em>\n\n\u00a0\n<h3>Flow Commands<\/h3>\nUse these commands to view and modify data related to Microsoft Flow.\n\n\u00a0\n<h4>Display all Flows<\/h4>\n<code>Get-AdminFlow<\/code>\n\nReturns a list of all flows in the tenant.\n\n\u00a0\n<h4>Display Flow Owner Role details<\/h4>\n<code>Get-AdminFlowOwnerRole \u2013EnvironmentName '<em>EnvironmentName'<\/em>\u00a0\u2013FlowName \u2018<em>FlowName<\/em>\u2019<\/code>\n\nReturns the owner details of the specified Flow.\n\n<em>Note: Like Environments and PowerApps, FlowName is the unique identifier (guid), which is different from the display name of the Flow.<\/em>\n\n\u00a0\n<h4>Display Flow user details<\/h4>\n<code>Get-AdminFlowUserDetails \u2013UserId $Global:currentSession.userId<\/code>\n\nReturns the user details regarding Flow usage. In this example we\u2019re using the user Id of the current logged in user of the PowerShell session as input.\n\n\u00a0\n<h4>Remove Flow user details<\/h4>\n<code>Remove-AdminFlowUserDetails \u2013UserId '<em>UserId'<\/em><\/code>\n\nDeletes the details on a Flow user completely from the Microsoft database. All Flows the input user owns must be deleted before the Flow user details can be purged.\n\n<em>Note: The UserId field is the Object ID of the user\u2019s Azure Active Directory record, which can be found in the Azure Portal ( <a href=\"https:\/\/portal.azure.com\">https:\/\/portal.azure.com<\/a>) under <strong>Azure Active Directory &gt; Users &gt; Profile &gt; Object ID<\/strong>. Must be an admin to access this data from here.<\/em>\n\n\u00a0\n<h4>Export all Flows to a CSV file<\/h4>\n<code>Get-AdminFlow | Export-Csv -Path '.\\FlowExport.csv'<\/code>\n\nThis command exports all the Flows in your tenant into a tabular view .csv file.\n\n\u00a0\n<h3>Api Connection Commands<\/h3>\nView and manage API connections in your tenant.\n\n\u00a0\n<h4>Display all native Connections in your default environment<\/h4>\n<code>Get-AdminPowerAppEnvironment -Default | Get-AdminConnection<\/code>\n\nDisplays a list of all Api Connections you have in the default environment. Native connections are found under the <strong>Data &gt; Connections<\/strong> tab in the maker portal.\n\n\u00a0\n<h4>Display all Custom connectors in the tenant<\/h4>\n<code>Get-AdminPowerAppConnector<\/code>\n\nReturns a list of all custom connector details in the tenant.\n\n\u00a0\n<h3>Data Loss Prevention (DLP) Policy Commands<\/h3>\nThese cmdlets will control the DLP policies on your tenant.\n\n\u00a0\n<h4>Display all Policies<\/h4>\n<code>Get-AdminDlpPolicy<\/code>\n\nReturns a list of all the Policies.\n\n\u00a0\n<h4>Display a filtered list of policies<\/h4>\n<code>Get-AdminDlpPolicy '<em>DisplayName'<\/em><\/code>\n\nUses the display name to filter the policies\n\n\u00a0\n<h4>Display all \u2018Business data only\u2019 Api connectors in a policy<\/h4>\n<code>Get-AdminDlpPolicy '<em>PolicyName'<\/em>\u00a0| Select \u2013ExpandProperty BusinessDataGroup<\/code>\n\nLists the Api connections that are in the Business data only (or BusinessDataGroup field) in an input policy.\n\n\u00a0\n<h4>Add a Connector to the \u2018Business data only\u2019 group<\/h4>\n<code>Add-ConnectorToBusinessDataGroup -PolicyName 'PolicyName' \u2013ConnectorName 'ConnectorName'<\/code>\n\nAdds a connector to the \u2018Business data only\u2019 group in a given DLP policy. See the list of connectors by DisplayName and ConnectorName (used as input) <a href=\"https:\/\/blogcode.blob.core.windows.net\/admin-powershell-cmdlets\/AllConnectors.xlsx?se=2030-05-18T07%3A00%3A00Z&amp;sp=rl&amp;sv=2017-07-29&amp;sr=c&amp;sig=930uxNoHeI7Qmra7%2BauUk6UdoEMGLYCCUrQaFU1NQHM%3D\">here<\/a>.","protected":false},"excerpt":{"rendered":"<p>In our effort to comply with GDPR, we have released PowerShell script functions (cmdlets) that make it easier for admins to manage data and resources on their instance of PowerApps, Flow, and other\u2026<\/p>\n","protected":false},"author":103,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-apps-category":[1540,1635,1675],"power-apps-tag":[1529],"coauthors":[2136],"class_list":["post-88","power-apps","type-power-apps","status-publish","hentry","power-apps-category-alm","power-apps-category-learning","power-apps-category-admin-features","power-apps-tag-admin"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PowerShell Cmdlets for PowerApps and Flow creators and administrators - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PowerShell Cmdlets for PowerApps and Flow creators and administrators - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"In our effort to comply with GDPR, we have released PowerShell script functions (cmdlets) that make it easier for admins to manage data and resources on their instance of PowerApps, Flow, and other\u2026\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/01\/powershell-run-as-admin-175x300.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"7 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Denise Moran\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/\",\"name\":\"PowerShell Cmdlets for PowerApps and Flow creators and administrators - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/01\/powershell-run-as-admin-175x300.png\",\"datePublished\":\"2018-05-30T10:08:11+00:00\",\"dateModified\":\"2018-05-30T10:08:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/#primaryimage\",\"url\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/01\/powershell-run-as-admin-175x300.png\",\"contentUrl\":\"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/01\/powershell-run-as-admin-175x300.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Apps\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"PowerShell Cmdlets for PowerApps and Flow creators and administrators\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PowerShell Cmdlets for PowerApps and Flow creators and administrators - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/","og_locale":"en_US","og_type":"article","og_title":"PowerShell Cmdlets for PowerApps and Flow creators and administrators - Microsoft Power Platform Blog","og_description":"In our effort to comply with GDPR, we have released PowerShell script functions (cmdlets) that make it easier for admins to manage data and resources on their instance of PowerApps, Flow, and other\u2026","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/01\/powershell-run-as-admin-175x300.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 min read","Written by":"Denise Moran"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/","name":"PowerShell Cmdlets for PowerApps and Flow creators and administrators - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/#primaryimage"},"thumbnailUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/01\/powershell-run-as-admin-175x300.png","datePublished":"2018-05-30T10:08:11+00:00","dateModified":"2018-05-30T10:08:11+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/#primaryimage","url":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/01\/powershell-run-as-admin-175x300.png","contentUrl":"https:\/\/powerappsblogmedia.azureedge.net\/powerappsblog\/2019\/01\/powershell-run-as-admin-175x300.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/gdpr-admin-powershell-cmdlets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Apps","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/"},{"@type":"ListItem","position":3,"name":"PowerShell Cmdlets for PowerApps and Flow creators and administrators"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/88"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-apps"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/103"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=88"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/88\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=88"}],"wp:term":[{"taxonomy":"power-apps-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-category?post=88"},{"taxonomy":"power-apps-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-tag?post=88"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=88"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}