Category: Apps

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:

Implementation Steps:

1. Navigate to https://make.powerapps.com

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 https://admin.powerplatform.microsoft.com/
• Then Select Environments then Open the Environment
• Click Settings at the Top and Select Features

• 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 

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.

• Login to https://portal.office.com
• Navigate to Admin->Users->Guest Users
• Click on Add a Guest User
• The url redirects to New user – Microsoft Azure
• Click on Invite a User,
• Type the Email Address and click on Invite.

• User got added successfully.

• Navigate to https://make.powerapps.com
• 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.

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

• Login to https://portal.office.com
• 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 https://make.powerapps.com

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