Interview Concepts

Canvas App:

Create a App:

• make.powerapps.com
• Apps
• New Apps
• Canvas

Types of controls:

• Input
• Display
• Media
• Icons
• Charts
• Layouts
• Mixed Reality
• AI Builder

Connectors:

• Connector is nothing but Software component.
• Connector can communicate Powerplatform to another application.
• Types of connectors:
• Standard
• Custom
• Premium

Delegation Warning:

• Delegation in Power Apps is the process of retrieving data from a data source on an as-needed basis. 
• Instead of pulling in all records at once, 
• Power Apps retrieves records as requested, 
• which is essential for performance and efficiency when dealing with large data sets.
• By default it will read the data upto 500 Records
• But we can extend up 2000 records.
• in Item property
• list of users Where the title Property (StartWith, EndsWith, Containt)

Delegable vs. Non-Delegable Queries:

• When working with data in Power Apps, 
• Delegable queries are those that the data source can handle on its own, such as filtering records. 
• .
• Non-delegable queries are those that the data source can't handle, and Power Apps has to process them locally. 
• An example of a non-delegable query is the 'Search' function when used against SharePoint.

File ------ App Settings ------ Advance Settings ------- Value (Data row limit for non-delegable queries)

AI Builder:

Variables:

1. Context Variable:                                                                 

        

• Syntex = UpdateContext ( { varname: Reddy } )
• 
  
• Syntex =  Navigate ( Screen2, Screentransition.Fade,{ varnaem:Reddy } )
• 
  
• Initial variable value is blank when app start.
• Context variables are limited to the context of a single screen.
• We can't use or set them outside of this context or screen.
• Context variable can hold any value like string, number,recods & tables.
• This is similar to the parameter which we pass to methods or procedure and this variable can be referenced from only one screen.
• Your can set a context variable when you set the Navigate function to show a screen.
• Number =  {Y:1}                      (number - Intezter)   (string = Reddy = Text)   
• String = {Y: "Reddy"}
• UpdateContext ({Y:1}) 
• UpdateContext ({Y:"Reddy"})
• UpdateContext ({Y:" Enter id of Text box. Text"})

2. Collections:

• Create and set collections by using the ClearCollect function.
• You can use the Collect function instead, but it will effectively require another variable instead of replacing the old one.
• This variable can store table which can be referenced across anywhere in the app
• Syntex = Clear( Collection_Name )
• Syntex = Collect( Collection_Name, TextInput.Text )
• Syntex = ClearCollect( Collection_Name, TextInput.Text )

3. Global variables:

• You can set the value of the Global Variable with the Set Function.
• Syntex = Set ( variable, name )
• This is similar to a global variable in programming language and it can hold a
•  number, 
• text string, 
• Boolean, 
• record, 
• table, etc as a data value

Home -------- View ---------- Varaibles / Collections

Components:  link

• A component is a reusable building blog. It saves lot's of time to developer.
• It is also more perform in terms of performance optimizaction.

Type of components:

1. Component Libraries (Preview)
2. Apps

Create a componet: From Apps

• Canvas (YT - Canvas - Component)
• Click on Component section
• Create component ( cmpMenuBarCanvas)
• Insert vertical Gallery (From layout select Title)
• click on component ( cmpMenuBarCanvas)

Click on MenuItem form Cusotm Properties

Then decrease the gallery & component size                         306 = Size number

To utilize the custom- component (Which you have created)

1. Component Libraries and Apps component?

Component Libraries : Allow customization

• A component library provides a centralized and managed repository of components for reusability.
• In independent component  library you dont't have any global variable or any global collections.
• Everything you are defining here.
• If have any changes in Component Libraries, it will reflect into all components.

Apps: Access App Scope

• If you are defining some collections or Some global variables inside your Canvas app it self.
• Now
• You want to use that perticular Context Variables into in your component library at the time you can use this.

Create a componet: Component Libraries (Preview)

• Apps
• Component Libraries (Preview)     (YT-Components)
• .
• .
•  Publish the component

Behavior Property in Power Apps Component

• Create a component form canvas (cmpPopUP)         high=300 

• Assign the value in Header
• Select component from left navigation (cmpPopUP).
• 
  

 Enable Behavior Property Feature:

• Settings
• Upcomming Feature
• Experimental
• Enhanced component properities (Make it ON)

• Save and publish the component
• Insert Menu ------ Get More Components ------- Select 
• That component  available under Library Component.

Create Reusable Custom Functions using Power Apps Components

• Create a new component ( cmpCalculatedTax)                  ( Size=100 100 )
• Create a custom Properties
• Display Name ( CalculateTax)
• Property Type ( OutPut )
• Data Type ( Number )
• Create a Parameter

• Click on Property (Parameter)
• CalculateTax --------------------- BaseAmount * (5/100)
• .
• .
• Go to canvas app

Difference between Dropdown & CompboBox?

Dropdown :

•  Dropdown.Selected.Text ----------Syntax

How to display a screen based on permission level in canvas apps?

To restrict access in a canvas app using SharePoint: 

1. Create a SharePoint group
2. Select permission levels
3. Add a user to the group

To set permissions and share an app using Power Apps in Teams: 

1. Select Manage permissions in the command bar
2. Under Colleagues with access role, select the permission set
3. Assign a security group to the Colleagues with access role
4. Select Save

To make a button visible based on the current user in Power Apps: 

1. Select the Settings button
2. Type the varIsProjectManager value into the Visible property
3. The button will show when the variable is true

Difference between Canvas Apps & Model Driven Apps?

Canvas Apps:

• Canvas App is a low-code platform for building rich business applications.
• Canvas App for simple apps with a specific purpose.
• Canvas Apps can connect and interact with over 350+ Connectors, empowering users to have more functionalities.
• Logic implementation is app-specific and can be done through,
• Excel-like formula and conditional checks.
• Design of application is more user friendly and larger flexibility for the developer to cater to look and feel requirement.
• Supports version control and changes once done can be reverted at any point through a simple click.
• 
  

Model-Driven-Apps:

• Model-driven app design is an approach that focuses on adding components 
• such as forms, 
• views, 
• charts, and dashboards to tables using an app designer tool.
• Model-Driven Apps can connect and interact with only one data connector that is Data Verse.
• Logic implementation can be done in multiple ways including,
• Business Rules
• Workflows
• Actions
• Plugins
• Does not support version control, changes once done have to be rolled back by subsequent deployment.

Gallery:

• A gallery control in Power Apps can show multiple records from a data source. 
• Each record can contain multiple types of data. 
• For example, 
• you can use a gallery control to show multiple contacts with each item showing contact information.
• Gallery Types:
1. Vertical Gallery
2. Horizontal Gallery
3. Flexible Height Gallery
4. Blank vertical Gallery
5. Blank Horizontal Gallery
6. Blank Flexible Height Gallery

Search: link

• PowerApps search function returns the same columns which are presented in the table from where you searching.
• The table should contain columns which are having a Text or String value. 
• Apart from a Text value, 
• it will not take any other column value like Number, Choice, Picture, Hyperlink, etc.
• Syntax ------- Search ( Table, SearchString, Column1 [, Column2, ... ] )
• 
  
•    Items  =     Search('Event_Registration', SearchBox.Text, "Title")

Sorting:    link

• Power Apps Sort function helps to sort the table depending on the formula the user provides.
• The formula output must be an integer, a Boolean, or a string value. 
• The output cannot be in a table or record.
• Syntax ------- Sort ( Table, Formula [, SortOrder ] )
• 
  
•         Items  = Sort ( emponboarding, Title )
•         Items  = Sort ( emponboarding, Title, Descending )
•         Items  = Sort ( emponboarding, Title, [ "Name1","Name2"] )

distinct:

If Statement: link 

• Powerapps if function specifies whether one or more conditions in a set is true. 
• That means, 
• If the result is found as true, then the corresponding value is returned. 
• If no result is found, then the default value is returned.
• Syntax ------- if ( Condition, ThenResult , DefaultResult )

            Text = If ( 

                                Value(TxtInput.Text) < 30, "Order MANY more!" 

                                Value(TxtInput.Text) < 50, "Order more!", 

                TxtInput.Text )

Substitute:

ForAll Function:  link

• PowerApps ForAll function helps to evaluate the formula and perform actions for all the records in a table. 
• Simply we can say it evaluates some functionality on each row of a particular table/collection or a database.
• In the Powerapps ForAll function, 
• The input and return values both are the same. 
• That means whatever you will apply the input value, it will return the same value.
• Just like a ClearCollection function.
• Powerapps forall patch
• Powerapps forall collection
• Powerapps forall set variable
• Powerapps forall gallery
• Syntax ------- ForAll ( Table, Formula )

filter condition:

filter condition,LookUp

Gallery: link

• Power Apps Gallery is a type of control that can display a set of records from a data source. 
• In the gallery, 
• Each record holds multiple types of data. 
• Also, 
• it can contain other input controls.

Data Table: link

• PowerApps Data Table is a type of control that helps to display a bunch of data in a tabular format. 
• The data table contains a Header for each field that the control displays.

Form:

• In Power Apps, forms are a user interface that people use to interact with data.
• NewForm
• EditForm
• DisplayForm

Different Between Gallery & Data table?

Gallery:

Data Table:

Creating Custom form:

Patch function:

• Patch formula can support submitting the data & updating the data.
• Patch formula can support custom controls.
• OnSelect ------Button

Difference Between Filter, LookUp & Search Cascading Dropdowns?

Custom connectors in PowerApps?     (Need more information)

• Standard Connectors
• Premium Connectors
• Custom Connectors

how to increase powerapps performance?     (Need more information)

• Limit data connections
• Don't add more than 30 connections in one app. 
• Apps prompt new users to sign in to each connector, so every extra connector increases the amount of time that the app needs to start. 
• As an app runs, 
• each connector requires 
• CPU resources, 
• memory, and 
• network bandwidth when the app requests data from that source.
• Limit the number of controls
• Don't add more than 500 controls in one app. 
• Power Apps generates an HTML document object model to render each control. 
• The more controls you add, the more generation time Power Apps needs.

Model Driven apps:

Environment Types: 

1. Default Environment
2. Production Environment
3. Sandbox Environment
4. Trial Environment Managed Solutions

Solutions 

• Managed Solutions
• Un-Managed Solutions

Tables

• Standard
• Managed
• Custom

Columns

• Primary column

Relationships

• One to Many
• Many to Many 
• Many to One ---------- Default Relationships

Views

1. System Views
2. Personal Views
3. Public Views
1. Public view -----------------Default View
2. Advanced find View -----Default View
3.  Assoicates view --------Default View
4. Lookup view --------------Default View
5. Quick find view ----------Default View
                                     
           

Power Automate Flows:

Overview:

• Microsoft Power Automate provides the tools that you can use to improve productivity in your organization by automating repetitive, time-consuming tasks. 
• Power Automate provides a better way to get things done across your organization through cloud flows and robotic process automation (RPA).

Types of PowerAutomate:

• Cloud Flows
• Desktop flows
• Business process flows
• 
  
• Cloud Flow
• Automated flows
• instant flows
• Scheduled flows

Power Automate Connectors: 700

• Outlook
• SharePoint
• Dataverse
• Microsoft Teams
• YouTube
• Twitter
• Dropbox
• Salesforce
• Stripe
• MailChimp
• Jira

Triggers in power automate:

• Triggers  action that will initiate the flow to run.
• How will your flow initiate? 
• Will it run based on a button click, a schedule, or an event occurring in a connector? 
• This starting action is referred to as the trigger. 
• It is always the first step you see in your flow. 
• In cloud flows, 
• there are three different types of triggers:
• Automated or event-driven
• Instant or manual
• Scheduled
• .
• 
  
• Automated or event-driven:
• These run automatically based on an event happening in a connector. E.g.
• Someone submits a response to a form
• A blog is posted 
• A tweet is posted
• You get a new email

• Instant or manual
• Use this as your trigger if you want the flow to run on-demand. 
• So rather than waiting for an event to occur in a cloud service it is initiated by the user. This includes:
• Pressing a button in a Power App
• Talking to your Power Virtual Agent and it calls a flow
• Pressing a button in the Power Automate app or website
• Pressing a button in a Power BI report

Scheduled:

• You would use this if you would like to set a time and frequency for your flow to run on it’s own.
• The triggering action is based on the schedule you specify. 
• You might use this for situations such as:
• Sending a monthly report to someone
• Turning on your smart home devices at the same time everyday
• Scheduling a message to be posted in Teams
• Scheduling a tweet to be posted

Actions in power automate:

• Actions refer to every step in your flow after the trigger. 
• Actions use the connectors. 
• You add actions in the order you want them to run.
• Outlook: Send an email
• Excel Online: Update a row
• MSN Weather: Get current weather
• Microsoft Teams: Post message in a chat or channel
• Adobe PDF Services: Convert Image to PDF
• Twitter: Post a tweet

Variables in power automate:

Try catch block in power automate: link

Action - Send Email Notification:   link

Conditions in Power Automate: link

• If else
• If variations
• Switch-case model
• .
• 
  
• If file exists: 
• Checks if a file exists or not before executing a block of actions. 
• This action can be used to ensure that a file exists before performing other operations on it.
• If image:
• Executes a block of actions if a specific image is found on the screen, or not.

Approval process in Power Automate: link

How to connect another Datasource in Power automate flow:

• Sign in to Power Automate
• Select Data > Connections in the left navigation pane
• Select New connection at the top of the page
• Choose the connection you want to set up from the list of available connections
• Open a flow
• Scroll to the bottom of the Connections panel on the left and select Add Connection
• Select a connection from the drop-down list or select Create a New Connection
• Select OK to add the connection to the flow

PowerApps Concepts :

--------------------------------------

Customizing the forms and gallery controls : Power Apps Gallery Edit Form Tutorial for Beginners - YouTube

formulas in Canvas : Top 10 New Features in Power Apps (2022) | Named Formulas, Table Designer, Error Handling, etc. - YouTube

Using UpdateIf function to update a record Filter, LookUp Function in PowerApps : Patch, Update and UpdateIf functions in Power Apps - YouTube

Loading Spinner

how to increase powerapps performance

Drawbacks of powerapps

Powerapps Limitations

Concurrent Function

Authenticatoin process in Powerapps

What is CoE kit in Power Apps?

Microsoft Power Platform Center of Excellence Kit - Power Platform. The Microsoft Power Platform CoE Starter Kit is a collection of components and tools that are designed to help you get started with developing a strategy for adopting and supporting Microsoft Power Platform, with a focus on Power Apps.

 

 

Model Driven apps

--------------------------------------

·       Overview of Model Driven PowerApps

·       how to map Dataverse table

·       Create views in model driven app

·       Create forms in model driven app

·       Field level security

·       Security Roles

·       Business Rules in model driven app

·       Business Rule for a record (Stages : Draft,Pending Approval,Complete)
Solutions (Every Model driven app has own solution )

·       Environments – Dev,Test
Common data servies – Premium license required

·       Power automate flow to update the Approval status column and send an email to User which is Lookup column table another column.

·       Managed and Unmanaged Solutions in powerapps.

·       Delegations

·       moving an app to new environment

·       Roll based security in canvas

·       Command buttons in Main grid and Main form using javascript and powerfx formula

 

 

 

Dataverse

-----------------------

Overview of Microsoft Dataverse

Diff Type of Table is Dataverse

Create a Table in Dataverse

Views & Forms in Dataverse --à How to create Views|Forms in Dataverse table ?How to show related column in Views? LINK TWO TABLES - YouTube

Relationships in Dataverse --------à Introduction to Microsoft Dataverse in Power Apps | Build Tables & Relationships | Beginners Guide - YouTube

One Account can be assigned multiple projects (One- Many relationship)

Projects can be having multiple users (Many to Many relationship)

Projects have their own projects tasks (One to Many relationship)

 

 

Power Automate Flows

---------------------------------------------------

What are triggers, Actions, Variables, Try catch block,

What are actions Sending email notifications

Conditions in Power Automate

Approval process in Power Automate

How to call one flow to another flow (Parent and Child)

How to connect another Datasource in Power automate flow.

 

 

Security Roles in Dataverse --- system Administration / Basic user priviliges

Dataverse Field Security ----> to hide/show the field for some particular users or teams

Field security with Field security profiles to enable access (Read/Write/Editupdate)

 v2 triggers in power automate

Business Rules :

Textbox value should not be empty - Mandator field

 

 

Types of Power automate flows

1)    Cloud Flows

2)    Desktop flows

3)    Business process flows

 

1)    Cloud Flows :

a.    Automated flows

b.    Instant flows

c.     Scheduled flows

2)    Desktop flows

 

 

Role based security in PowerApps :

1)    Create Azure group in Azure active directory

2)    Copy the ObjectID from the newly created Group.

3)    ClearCollect(AdminUsers,Office365Groups.ListGroupMembers(“885bd0a6-4467-445e-8889-b317afd0556c”).value);
If(User().Email in AdminUsers.mail ,Set(VarAdmin,true), Set(VarAdmin, false))

4)    On Adminscreen button visible property -à use Adminusers collection.

 

Real time Interview questions in my interview

--------------------------------------------------------------------------

 

1)    How to will you maintain security in PowerApps

2)    How will you use REST API in PowerAutomate flows

3)    Delegation warning in PowerApps

4)    How will you integrate SQL server or other datasource with Dataverse.

5)    What are the premium license connectors you used in PowerApps and Power Automate flow.

6)    How to will you use Excel as datasource in Powerapps (required steps)

7)    What are the admin activities performed in Powerapps as of now. Explain in detail.

8)    how you can protect your organization's data using powerapps.

9)    Tell me some default tables in Dataverse and can we edit those tables ?

10)  Types of Tables available in Dataverse and tell me some standard tables used in your project and why used.

11)  If we want get some data from Dataverse and some data from SharePoint in Powerapps, Is  it possible if then tell me the steps.

12)  What is Graph API and where we will use in Powerapps.

13) How to show 20000 records in the powerapps gallery

14) Power pages- what is the use

15) AI models in power apps

16) How will you fix form responsiveness across tablets,mobiles and laptop

 

 

 

Questions from Internet for realtime interview

---------------------------------------------------------------

 

What are the benefits of Power Portal?

Define common data services (Dataverse), and why should we use them?

How is it possible to use media files in the Canvas app?

How different user environments can be created in PowerApps?

 

What could be the most convenient way of using a PowerApps app inside office premises?

You are building a canvas app. With the changes suggested by the client, the app screens keep on increasing.

As a consultant, when can you choose Model-driven apps over Canvas apps?

In a collaborative environment, how can you ensure the versioning of a canvas app when there are regular updates rolled out?

Can you share a canvas app with external business partners and contractors?

What is the purpose of using the SaveData() function?

Can you add responsiveness to the canvas apps?

Is there any specific situation when you can choose a model-driven app over a canvas app?

How can you distribute a canvas app with all the employees in an organization?

You are given a task to include the sentiment analysis feature in your app. How can you do this?

If you have a Plugin and a workflow present on a new form, which will it be executed first?

If you have a Javascript code and a Business Rule present on a new form, which will be executed first?

While working with Power BI you have created 3 charts and 3 dashboards. How can you ensure that the same can be shared with your colleagues?

What are the different license options available when it comes to the Storage aspects of the Microsoft Power Platform?

 

Which three mobile platforms can you run apps built with PowerApps?

What are PowerApps templates?

 

 

What are the types of Power Automate?

What do power automate templates do?

How can I navigate across the PowerApps screens?

Can you automate Approval scenarios in Power Automate?

How can you call Power Automate from the Power Portal?

How can we create reports in Power BI using an on-premise data source?

How can you integrate Power BI inside dynamic 365 CE Model driven apps?

Can you explain about authorization in Power Portal?

How to define menu items in Power portal?

How to connect Dataverse data from Power Portal without using List and Form control.

How to deploy a Power Portal from one environment to another?

How to work with large data in Power Apps?

 

implicitly create

Power Fx