Power Apps Power Automate Interview Questions

PowerApps allows you to create canvas apps and model-driven apps. Canvas apps start with your user experience, allowing you to create a highly customizable interface by using various UI controls such as labels, text-input boxes, drop-down lists, media, charts, and so on.

Model-driven app development starts with your data model and uses a component-based approach to developing a robust app. Model-driven apps are comprised of components such as entities, views, charts, forms, business processes, and dashboards which together form a great UI.

Common Data Service allows data to be integrated from multiple data sources into a single store that can be used in PowerApps, Power Automate, Power BI, and Power Virtual Agent. Integrating the data from multiple sources into a single store enables an easier app building experience, and a common set of logic to maintain and operate the data.

Common Data Service is an abstraction on top of underlying Azure cloud data management services to make it easier to build business applications.

Yes. Power Apps allows you to create any number of connections, once the connections are created using an account, any number of data sources can be used in a single app.

Data can be submitted using Patch() and Submitform() function. You can do partial data update using Patch() function.

This is a special kind of data source, which is local to the app and is not connected to the cloud service. A collection data is local to the device and cannot be shared across devices for the same user or different users. Collections can be saved and retrieved locally from the device. Collect, ClearCollect, and Clear function can be used to manipulate collections.

To maintain the performance of an app it is important that when working with a large data source we should minimize the amount of data that is brought to the user device for data operation. If we have a SQL database table having millions of records and we want to search for a specific record based on a parameter, we cannot bring the entire records to the app locally and then do the data operation. Bringing such a huge amount of data locally will drastically impact the performance of your app. To overcome this issue PowerApps supports Delegation

Delegation is a mechanism to minimize the amount of data being transferred locally to the device by delegating processing of data to the data source, instead of moving the data to the app for processing locally.

These are the most popular data sources which support delegation:

• Common Data Service
• SharePoint
• SQL Server

You must understand that just using a delegable data source doesn’t ensure that all your queries can be delegated. While using a delegable data source, not all the functions and operations can be delegated. To achieve delegation, it is important that we are using delegable functions with the delegated data sources.

Here is a list of few delegable and non-delegable functions that can be used with a delegable data source:

Delegable functions:

• Filter, Search, LookUp
• Sort, SortByColumns
• Sum, Average, Min and Max

Non-delegable functions:

• First, FirstN, Last, LastN
• Choices, Concat
• Collect, ClearCollect
• CountIf, RemoveIf, UpdateIf
• GroupBy, Ungroup

You can use the Errors function to get the details of any errors. You can avoid a few of the errors before they occur using the DataSourceInfo and Validation function.

Read more

Components are reusable building blocks for canvas apps so that app makers can create custom controls and use them across apps. Components can be exported and imported in different apps across organizations.

Components are useful in building larger apps that have similar control patterns. For example, we can build a navigation control and use it across our app on different screens. Once we update a component, all instances in the app reflect your changes. Components improve performance and help in standardizing the look-and-feel of PowerApps apps in an organization.

A component has input properties that can receive values from the app, and the component can use these internally. Components also have output properties that can provide output values to the app.

You can upload up to 200 MB of media per app in Power Apps. However, the recommended approach is to use blob/media storage services like Azure Storage or Azure Media Service and embed your media URL to the app.

Read more

Use the Set function to set the value of a global variable, which temporarily holds a piece of information, such as the number of times the user has selected a button or the result of data operation.

Use the UpdateContext function to create a context variable, which temporarily holds a piece of information, such as the number of times the user has selected a button or the result of data operation.

An environment is a space to store, manage, and share your organization's business data, apps, and flows. It also serves as a container to separate apps that might have different roles, security requirements, or target audiences. How you choose to use environments depends on your organization and the apps you're trying to build.

Read more

Yes, we can connect to the local network data source in the Power Apps.

PowerApps per-app plan: $10/user/app/month

Allows individual users to run applications (2 custom apps and access 1 custom portal) for a specific business scenario based on the full capabilities of PowerApps

PowerApps per-user plan: $40/user/month

Enables users to run unlimited applications based on the full capabilities of PowerApps.

Through Office 365 and Dynamics 365 user licenses: Price already included

Customizes and extends Microsoft 365 & Dynamics 365 applications

Body 1

Body 1

Body 1

Body 1

Body 1

Body 2

Body 2

Body 2