{Power 2020 Tip # 7} Minimum Security role required to run a PowerApp

For ages I have been asked over the same question by clients, partners and community alike. Everyone wishes to start from the minimum required Security role privileges for doing their production system. As part of Power 2020 blog 7, we will see how to utilize this awesome hidden gem from Microsoft and getting the security role for Minimum security role privileges.

You may start by downloading the solution from the Download Center: Common Data Service minimum privilege security role.

Next we will import the downloaded solution by Navigating to Solutions and click on import:

clip_image002

Next select the downloaded zip file from the link mentioned above and import:

clip_image004

Click on Next and finish the solution import process. On the final step, following confirmation screen will appear:

clip_image006

Now let us open the Security role and explore inside the solution:

clip_image008

Whenever you wish to set the minimum security privileges to access an App, you may start from this role.

Hope it helps and Power 365ing as usual!

Any problem in Power Platform or Dynamics 365 – end user, Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

I am here to help, get in touch here: Click here

ABOUT THE AUTHOR:

clip_image010

{Power 2020 Tip# 6} Adding a PowerApp to Microsoft Teams

Certain times we want to empower users to utilize PowerApps right from the Microsoft Teams. With Blog 6 of the series Power 2020, let’s go through how we can achieve this:

Navigate to the Apps section and select Add to Teams option by expanding the Menu under …(three dots)

clip_image002

Click on the Download App button on the right pop-up menu that appears:

clip_image004

A zip file will be downloaded for your App, next Navigate to Microsoft Teams:

clip_image006

Note: You need appropriate privileges to do this. In case you don’t have the right privilege, you will not see the option to Add custom app as described below.

Under Microsoft Teams login, Select Apps and then click on Upload a custom App option:

clip_image008

Here upload the zip file which was exported from Apps area in PowerApps. Once done, The app will be available as below:

clip_image010

In the next step click on the App, In the Popup window click on Add:

clip_image012

Now you can use your App right from Microsoft Teams:

clip_image014

clip_image016

Hope it helps and Power 365ing as usual!

Any problem in CRM – end user,Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

I am here to help, get in touch here: Click here

ABOUT THE AUTHOR:

clip_image018

{Power 2020 Tip# 5} Themes in Canvas Apps

Many times we want to define pre-defined Themes inside Power Platform Canvas Apps. Here is a quick look at Themes feature in Canvas Apps which can help us to change the overall theming of our Canvas Apps which we will cover in Blog 5 of the series Power 2020.

Under the Home tab we have theme option available and can be used to change the pre-set look and feel of Canvas Apps. The table below describes out of box available options and the look and feel of the App:

Theme Screen Appearance
Blue clip_image002
Light clip_image004
Steel clip_image006
Aqua clip_image008

There are variety of options available. Themes can be changed from Home -> Themes

clip_image010

Hope it helps and Power 365ing as usual!

Any problem in CRM – end user,Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

I am here to help, get in touch here: Click here

ABOUT THE AUTHOR:

clip_image012

{Power 2020–Tip #4 } Experimental features in PowerApps

In this post of Power 2020 blog series blog 4, we will go through the Experimental features in PowerApps

Experimental Features:

Optimize embedding appearance

By using this feature, you will align your app to the top left and will change the embedded background colour to white. clip_image002

clip_image004clip_image006

Container Control

Once you enable this feature, you can insert a Container control into your app.

clip_image008clip_image010

 

 

 

Web barcode scanner

Once you enable this feature, you can insert a Web barcode scanner into your app from the Media menu.

clip_image012clip_image014

Components

After turning on this feature, you can create and add components to your app. This means you can create a group of controls like “Header” and use it in multiple screens or multiple places in your app.

clip_image016clip_image018

Enhanced formula bar

The enhanced formula bar provides you a new formula bar experience with speed and usability improvements. This feature gives suggestions to appear in the text area while you type in the formula bar. Also, the property drop-down has now been discoverable category into Action, Data, and Design.

You need to save and refresh your app to see the changes.

clip_image020clip_image022clip_image024

Deprecated Features:

Enable rules

By using this feature, you can create condition and record action in your app. But the “Rule” feature in the canvas app in PowerApps is deprecated now.

clip_image026

clip_image028

Hope it helps and Power 365ing as usual!

Any problem in CRM – end user,Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

I am here to help, get in touch here: Click here

ABOUT THE AUTHOR:

clip_image026[5]

{Power 2020–Tip #3} Overview of Preview features in PowerApps

In this post of Power 2020 blog series blog 3, we will go through the Preview features in PowerApps

Preview Features:

These features are turned on by default.

Delayed Load

By enabling this feature, we can improve our app performance. This means if your app has multiple screens and multiple data sources, your app performance may suffer. So by enabling this feature, you can prevent this issue.

clip_image002

Common Data Service new file and image data types

Once you enable this feature, your app will support image and file datatype from Common Data Service. For this feature work, “Improve data source experience and Common Data Service views” feature must be “On” in your app.

clip_image004

Enable improved data table control selection and Value property

Using this feature, you can improve updated field selection on Data table control in Canvas. By turning on or turning off this feature will not affect your existing data table controls. You can find this setting under the Preview feature section.

When turning on this feature, your Edit fields pane will look like this.

clip_image006clip_image008clip_image010clip_image012

 

Enable enhanced Microsoft SQL Server connector

This feature added to Active Directory authentication in the SQL Server connector. If you turn on this feature, you will promote to select Authentication type in your app. Then you can choose “Azure AD Integrated” from the drop-down.

clip_image014

clip_image016clip_image018

Hope it helps and Power 365ing as usual!

Any problem in CRM – end user,Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

I am here to help, get in touch here: Click here

ABOUT THE AUTHOR:

clip_image026[5]

{Power 2020–Tip #2} Overview of Advanced Settings in PowerApps

Advanced Settings in PowerApps helps you to control Preview Features, Experimental Features, and Deprecated Features. By navigating File > Settings > Advanced Settings you can find all these features in PowerApps.clip_image002

In today’s article, we will discuss few Advanced settings in Power platform.

Advanced Settings:

Data row limit for non-delegable queries

Using this feature, we can set the size of records to be retrieved from server-based connectors. The default number of records is 500. We can store up to a maximum of 2000 records. But only certain connectors will support delegation.clip_image004clip_image006

Improve data source experience and Common Data Service Views

With this feature, the app designer can improve data source and Common Data Source Views in PowerApps studio and can filter data sets as well.clip_image008

clip_image010

If you turn off this feature, you might be not able to find the Data source panel icon over the rightedge of the canvas area.clip_image002[5]clip_image004[5]

Hope it helps and Power 365ing as usual!

Any problem in CRM – end user,Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

I am here to help, get in touch here: Click here

ABOUT THE AUTHOR:

clip_image026[5]

{Power 2020–Tip #1} Overview of Screen Settings in Canvas Apps

In case you are trying to build Canvas Apps to manage some part of your business – one key ask is to look for Screen settings for different orientation and size based on the needs of your organisation. Here is a quick Power tip to change it as per your needs:

You can choose portrait or landscape orientation and screen size (tablet only) by navigating File > App settings > Screen size + orientation.

clip_image001[4]

Orientation Size Preview
Landscape 16:9 (Default) clip_image003[4]
Landscape 3:2 (Surface Pro 3) clip_image005[4]
Landscape 16:10 (Widescreen) clip_image007[4]
Landscape 4:3 (iPad) clip_image009[4]
Landscape Custom clip_image011[4]clip_image013[4]
Portrait 16:9 (Default) clip_image015[4]
Portrait 3:2 (Surface Pro 3) clip_image017[4]
Portrait 16:10 (Widescreen) clip_image019[4]
Portrait 4:3 (iPad) clip_image021[4]
Portrait Custom clip_image023[4]

 

There are some other settings worth the mention:

Scale to fit

By turning on this setting, your app screens resize to fit the available space on the device.

Lock aspect ratio

When Scale to fit setting is turned off, the Lock aspect ratio is automatically disabled. Also, the Width property of all screens is set to Max (App.Width, App.DesignWidth), and their Height property is set to Max (App.Height, App.DesignHeight).

Lock orientation

When you lock the app’s orientation, the app recalls the orientation that you define. Once the app is running on a device for which the screen is in a different orientation, the app displays inaccurately and may show unwanted issues. When you unlock the app’s orientation, it fits the screen orientation of the device on which it’s running.

clip_image024[5]

Hope it helps and Power 365ing as usual!

Any problem in CRM – end user,Microsoft partner or an individual?

Problem Area – Technical, Functional, Training, Development or consulting?

I am here to help, get in touch here: Click here

ABOUT THE AUTHOR:

clip_image026[5]