Apps, PowerApps

Set table ownership

As we all know there are 3 different types of tables in Powerapps

  1. Standard Tables – These are OOB tables included in Power platform for each environment. E.g., Business Units, Accounts, Contact. These tables can be customized. Custom tables imported as part of managed solution into specific environment are also Standard tables. These tables can be customized if the Customizable property is set to true.
  2. Managed Tables – These are tables imported as part of managed solution into specific environment. These tables cannot be customized as their Customizable property is set to false.
  3. Custom Tables – These are tables created in the environment directly with custom names. These tables can be customized further. Tables imported as part of unmanaged solution into specific environment are also custom tables. These tables can be customized if the Customizable property is set to true.

Customizing the tables depends on access privilege the user has on the respective table as well.

Table Ownership:

Table ownership is the ownership of records created under this table.

We have User or Team owned / Organization owned types which can be assigned for new tables while creation.

  • User or Team: Data belongs to a user or a team. Actions that can be performed on these rows can be controlled on a user level.
  • Organization: Data belongs to the organization. Access to the data is controlled at the organization level.

Additional table ownership,

  • None: System tables that don’t have any owner, e.g., Privilege table.
  • Business Unit. System tables are business owned. e.g., Business Unit, Calendar, Team, and Security Role tables.

These ownerships cannot be assigned by the user when creating new users.

How to assign table ownership?

Navigate to Table ->Properties->Advanced

Choose the Record ownership drop down as per the screen shot below:

Apps, Dynamics 365, PowerApps

Associate a business unit with an Azure AD security group

It is now possible to use Azure AD security group to map your business unit for streamlining your user administration and role assignment.

Create an Azure AD security group for each business unit and assign the respective business unit security role to each group team.

  1. Create a user in Microsoft Azure AD
  2. Login to Navigate to Admin->Teams&groups->Security tab
  3. Click on Add a Group, Give a group name and description.
  4. Click on Create Group
  5. The group is now created.
  • Navigate to
  • Choose the environment->Settings->Users+Permissions->teams
  • Click on Create team.
  • Add Team Name, Business Unit, Administrator
  • Choose Team type as AAD Security group
  • Search for the team’s name we created
  • Choose the membership type from the options – Members and Guests, Members,Owners,Guest
  • Click on Next
  • Choose from Security Role that needs to be assigned to this team

Now, all users who belong to this security group will have access to this Business Unit with assigned security role.

Apps, PowerApps

How to Enable Search in Address Finder Field in Canvas PowerApps 

Implementation Steps:

1. Navigate to

2. Create a new Table Canvas PowerApps

3. Add Address Finder Controller from Insert

4. Preview the App

5. If will ask you to enable FULL Map access.

Let’s see how we can achieve this.

  • Navigate to Map and address services –FULL option
  • . Turn it ON and Agree Terms and Click Enable

6. Now Click Save.

7. Once Done.. Navigate to your tablet Canvas app and Refresh the Screen

8. Add the Address Control again

9. Preview the App

10. Enter the Value in the Text Box you will get the Address loaded 

Apps, PowerApps

How to Share Canvas App with Guest Users?

In this blog I will show step by step instructions on how to share canvas app with Guest Users.

Guest users can use their own Power Apps per User license to access a Canvas App in another tenant as a guest.

  • User got added successfully.
  • Navigate to
  • Click on the Canvas App that you want to share with Guest User.
  • Click on 3 dots->and choose share
  • Add Security Role and Share.
  • Now share the App URL to the guest user and he should be able to access the App.
  • The Guest User can access the App from his tenant and license Plan successfully.
Apps, PowerApps

How to add custom themes and logo in PowerApps/Dataverse/MSCRM

In this blog, I will detail the steps on how to change the custom themes and logo in PoweApps.

  • Login to
  • Navigate to Settings->Org Settings.
  • Click on Organization Profile Tab and navigate to custom themes.

Click on Default Theme.

Enable the settings – Prevent Users from overriding their theme.

Click on Save.

Navigate to logos and upload the image ( < 10KB size).

Login to

Observe that the Logo appears in place of PowerApps in the header.