Datta Sai By Canvas Apps

Class:001


1. What type of services support in Power platform?
  • Paas
    • Platform as a Service for environmental purposes.
  • Saas 
    • Software as a Service for
      • We have different types of Software services are there.
        • Power Apps
        • Power automate
        • Power virtual agent
        • Power BI
 


2. What type of environment is in Power apps?
  • Development
  • Sandbox
  • Trail
  • Production
3. Why Power platform?
  • Power Platform is a low code in technology.
  • Power Platform can support all type of moduules.
  • Power Platform can support all kind of environment. 
    • (Sales,Healthcare, Markating, CRM, Social media, banking insurance,Ioe, Mobile comparatibility, Desktopcomparatibility, Tab comparability)
  • Power Platform is  support as a adminstation.
  • Power Platform is  support as a development.
  • Power Platform is  support as a database.
  • Power Platform is a browser based enable technology.
  • Power Platform can support all types of integrations. 
    • (Communication between the source and destination)(Connections)


4. Microsoft PowerApps?
  • PowerApps is a software to build custom business applications without the knowledge of app development or custom coding.
  • It is included in most Office365 subscription plans just like
    • OneDrive
    • Planner and others.
  • Using Microsoft Azure, the platform as a service offering and build-on development tools that target non-technical users can create, manage and share business apps on iOS, Android, and windows devices.
Advantages of using Power Apps Forms:
  • Part of the cloud deployment approach  (Constant Updates).
  • Part of a family of tools (Flow & Power BI) that add automation and visualization.
  • 350 + Connectors.
  • Modern look and feel.
  • Very mobile friendly.
  • Design and usage intended for end users.
  • If you were comfortable with Excel and Access formulas, you'll be right at home with powerapps.
  • Literally seconds to tweak layout, fields and deploy.
5.What is the building block for Powerapp ?
  • Power Apps
  • Power Apps Studio
  • Office 365 details
Create a app in powerapps?
  • 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
6. What is Canvas app?
  • Canvas app can support multiple data connections.
  • Canvas app can support External data souerce ( SharePoint, Sql Server, SAP, MainFrame).
  • Canvas app can support user design flexbility.
  • Canvas app can support versioning.
  • When we want to communicate with multiple data connections external datasource wer are going to create the Canvas App.
7. What is Model Driven app?
  • Model Driven App can support only one data connection.
  • Model Driven App can support only Dataverse.
  • Model Driven App can support component based app when we want communicate only one data connection like Dataverse.
  • We are going to create the Model Driven Apps.
  • .
  • .
  • Model Driven apps is part of Microsoft Dynamic CRM.
Class:002

1. Why you are goning to power flatform?
2. Why required power flatform required in this project?
3. Why you are using canvas app?
4. How to start the project ?
5. What is the probles? how to provide the solution for this?

6. What is share point?
  • SharePoint is content management system.
  • SharePoint is Collections of Sites and sub-Sites Collection.
  • SharePoint is collection of list and document library.
  • SharePoint is a contect management system.
  • SharePoint is one of the external data source for powerplatform.
    • Types of sites:
      • Team site
        • Team site can support all type of Projects (modules) like.,
            • Insurance module
            • Health care module
            • Banking module etc.,
      • Communication site
        • Communication site can support 
          • social media module
          • news & Comment moduele
          • Marrage portal module
          • facebook module
7. What is SharePoint List?
  • SharePoint list is nothing but table.
  • Tables is nothing but rows & columns
  • We have different type of columns are available.
    • Standard Column
    • Custom Column
7. Standard Column?
  • Standard Column can support when we want to create a list.
  • Default some columns are created.
    • Title
    • ID
    • Created
    • Created By
    • Modified
    • Modified By
7. Custom Column?
  • Custom Column are nothing but based on the requirement we are create the custom columns



Default mode is - Edit mode (View & New)

Site Name: Namibia
List Name:  Particular Of Owners

Class:003

All type of datatypes in SharePoint list?
Type of validation in SharePoint list?

Validation concepts in Power Apps
    Range validation
    Required files validation
    Captcha validation
    
1. Why i need to choose the power apps?
  • Power apps can support look and fell functionality.
  • Power apps can support integration from one technology to another technology without any custom code.
  • Power apps can support user defined flexibility.
  • secutiry wise.
2. How many ways to submit the data into SharePoint list using Power Apps?

Submit form:
  • Submit form can support only Edit form.
  • Submit form can support to submit the data from Power app data to SharePoint list.
  • Submit form formula can support only submit the data.
  • Submit form formula can support only edit form controls.
  • Submit form formula can't support custom controls.
    • OnSelect  --- Submitform(form) ;
Patch function: * * * * *
  • Patch formula can support submitting the data & updating the data.
  • Patch formula can support custom controls.




Rectangular
in edit form
Button----Auto Disable On Select (On select button)
Passport registration online (User registration)

Class:004



1. Types of forms in PowerApps?
  1. New form
  2. Edit form
  3. View form
1. What is notify?
  • Notify is nothing but displaying the banner message at the top of the screen. we have different types of attributes/formulas.
    • NotificationType. Error
    • NotificationType. Success
    • NotificationType. warning
    • NotificationType. information

notify("display message", attribute)
notify("Data saved sucessfully", NotifucationType. Success, 50)-----------it will display in 50 milli seconds

To convert string to integer use:
value('Text_number'.text)

2. How to reset the control in the power app?
  • using reset we can refresh the power app controls. 
  • Reset ( controlname )   Before notify function


3. When we are using reset control?
            when we use the patch function

Employee onboarding form details:
                    FirstName, LastName, Email, DoB, Address, Country, Designation, Salary

Class:005

1. What is lookup?
  • lookup is nothing but column datatype.
  • lookup is nothing but getting data from another list.
  • lookup column is re-usability.
  • lookup column data scope is site level.
Country -------------(India, Usa, UK, Austrilia)
State----------------- State, Country
Vehical Loan--------  

2. What is the Site column?
  • Site Column is re-usability.
  • Site Column scope is site level.
  • Site Column can support multiple list and documents.
  • Whenever we want required common columns one or more list and document libraies we are going to create the site column.
        • site settings
          • Site column  (Web Designer Gallery)
          • create
3. What is the difference between list column & Site column & lookup column?

4.What is Navigate?
  • Navigate formula is nothing but move the one screen to another screen.
  • navigate(Screen_name)
    • Navigate formula artibutes.
      • navigate.cover --------------(Screen will move left to right)
      • navigate.coverright --------(Screen will move right to left)
      • navigate.none ---------------(Normal position)





SBI Form Registration:
AccountNumber, SwiftNumber, BranchCode, Country, MobileNumber,

Class:006
1. SharePoint document library:
  • SharePoint has different types of libraries.
    • Shared document library.
    • Picture library.
    • site asset
    • wiki page
    • report library
2. What is the difference between list and document library?
  • List can't support folder creation.
  • list can't check in and check out properties.

    • Document library can support folder creation.
    • Document library can support check in and checkout properties.
3. Permissions in SharePoint?
  • Full Control
  • Contribute
  • Desing
  • Edit
  • Read
    • Inheritance permission
    • Unick level permission

  • Default group in SharePoint:

    • Practic Site Members
    • Practic Site Owners
    • Practic Site Visitors
3. Types of varaible in power apps?      * * * * *
  • Power app having 2 types of Varaibles
    • Local Variable
      • local variable can support with in the screen using with "updatecotext".
      • UpdateContext( {Ename: "Reddy Sekhar"} )
      • UpdateContext( {Enum: "21101989 "} )

    • Global Varaible
      • global variable can support multiple screen using "Set function".
      • set ( {Ename, "Reddy Sekhar"})
Varaible Example:

Class:007 

1. What is datatable?
  • Datatable is nothing but rows and columns.
  • Datatable having header.
  • Datatable can support to show the large data from any type of database.
2.What is Gallery? (Control)
  • gallery having different type
    • vertical gallery
    • horizantal gallery
    • blank vertical gallery
    • blank horizantal gallery
      • gallery doesnot have any header
      • gallery having pre-defined components-----title, subtitle, images





Mobile store:
Title,Details, Price, OfferDetails, MobilePic 
         
Class:008

1. How to datatable Binding in powerapps?


2. How to implement the CURD operations from sharepoint list gallery?

    CURD Operations:
    Create
    Update
    Read
    Delete

OnSelect ---- Navigate(TimeSheetOperators,ScreenTransition.Cover)

OnSelect ---  NewForm(Form1);Navigate(TimeSheet_Add,ScreenTransition.Cover)

OnSelect ---
            EditForm(Form2);
                Navigate(
                TimeSheet_update,
                ScreenTransition.Cover,
                {updateitem: Gallery6.Selected}
               )

OnSelect --RemoveIf('08_Time_Sheet',ResourcesName=Gallery6.Selected.ResourcesName)

OnSelect ---SubmitForm(Form1);
                       Notify("timesheet updated sucessfully",NotificationType.Success,100);
                            Navigate(Home,ScreenTransition.UnCover);

OnSelect ---
SubmitForm(Form2);Notify("Data submitted sucessfully",NotificationType.Success,100);Navigate(Home)

Data table:         having a Header
gallery control:  it does't have any header, we need to customise the Header

Time sheet:
ResourcesName, ManagerName, Hours, Comments, ProjectDescriptions

Class:009

Collection is nothing but temporary memory.
Collection is nothing a group of items.
Collection is nothing but array.
Collection is nothing but rows & columns.
Collection is nothing but internal memory of powerplatform.
  • Collect
  • ClearCollect
  • Clear
1. What is Collect?
  • Collect is nothing but adding the new records into a datasource.
  • Collect( Employinfo, { Enum:12345, Ename:"Reddy", Sal:25000} , )
2. What is ClearCollect?
  • ClearCollect is nothing but remove the records and again adding the records.
3. What is Clear?
  • Clear function can support to clear the existing the data.

OnSelect --- Collect(employee,{Enum:1,Ename:"Reddysekhar",Esal:25000})
OnSelect --- ClearCollect(employee,{Enum:1,Ename:"Reddysekhar",Esal:25000})
OnSelect --- Clear(employee)

EmployeeOperations:
ENumber, EName, Salary
Class:010


1. How to convert SharePoint list into collection?
  • Collect( SPdata,Share_Point_List_Name) 
  • OnStart property on App level ------Onstart---Collect( spdata, list)

2. How to add the records using collection  input controls?




2. How to add multiple value in item level?
3. Add Column?
  • Add column it will not effect to the datasource.
  • Just adding temparvery.

Itmes Property
    






4. Drop Column?
Itmes level










5. Show Column?
   Itmes level  ------ ShowColumns (Employinfo, "Ename","Enumber")

Filter: * * * * *
  • filter is one of the delagable formula in powerapps.
  • filter is  a find the multiple records based on the conditon.
  • filter will display records multiple database is datatable.
    • filter (dataSourceName, Condition)
Itmes level  ------

Lookup:
  • lookup is one of the delagable formula in powerapps.
  • lookup is find the first record of the datasource based on the condition.
  • lookup will display the only recored return type is text.
    • lookup(dataSourceName, Condition, Column_Name)
  • janalakshmi db team seniaro 
Default

Search:
  • Search is one of the delagable formula in powerapps.
  • Search will find the multiple records based on column indexing
  • Search will display datatype is datatable.
    • Search(dataSourceName, inputvalue, Column_Name)
  • Initialy it will display all data, from the data you can search what you want.













Region Country and State:
CarPurchase:
Company,CarName,Colorm,DistanceToTravel,Incurance.
Class:011

Cascading Dropdown:
  • Cascading Dropdown is nothing but populete the data from one dropdown list to another dropdown list.
1. How to remove duplicate records  using CascadingDropdown list?

(Based on the region we remove the duplicate records)

Distinct('5000SalesRecords','Region')

Filter('5000 Records', Region=Dropdown.SelectedText.value)

        Distinct ( SPList, Region)         (Based on the region we remove the duplicate records)
        Filter ( SPList, Region=Dropdown1.SelectedText.Value)

2. Cascading dropdown + Filter formula
       
Multiple Filters:
Filter ( SPList, And
                ( Region=Dropdown1.SelectedText.value, 
                                Country=Dropdown2.SelectedText.val)) 
covid cases senerios (Region,Country,State wise pasents)

Functions StartWith, EndsWith, In:

StartWith: (Display the results First letter)

Filter ('SPLIst', StartsWith(Title, Textinput.Text))

EndsWith: (Display the results Last letter)
Filter (SPLIst, EndsWith(Title, Textinput.Text))

In Operater: (Display the results between the word)
Filter (SPLIst, Textinput.Text In Title)

Filter (SPLIst, Title=TextInput1.Text)

Class:012

Condational Statement:
  • Condational Statement is nothing but if condition.
  • Condition is true, true block will be executed.
  • Condition is false, else block will be executed.
    • If (Condition, trueblock, elseblock)
  • .
  • if ( 2+3=5, Icon.Bus, Icon.Airplane) ( icon property)
  • if ( 4+5=9, color.green, color.red) (color property)

    • If ( Dropdown, SelectedText.value="True",true,false)       (Visible property)
    • ["True","False"]                                                                         (Items property)


  • Disable mode
  • if (IsBlank (Textinput.Text), DisplayMode.Disable, DisplayMode.Edit)     (DisplayMode property)
Login page with SharePoint site:

If (CountRows
        (Filter('New User',
            And(UserName=TextInput.Text,Password=TextInput.Text))))=1







Class:014 & 15

SQL Server:
  • sqlserver is a relational database.
  • sqlserver secure database and core database collection of databas.
    • database is nothing but collection of rows and columns.
Installation:
  1. download sqlserver
  2. install with next button configure user name
  3. download sqlserver management studio
  4. install
Authentication:
  • sqlserver having two types of authentications.
    • sqlserver authentications
    • windows authentications                (System user can able to access the sqlserver)
Create user:
  1. Security
  2. click on new user
  3. enter user details
1. How to communicate powerapp to sqlserver?
  • sqlserver is      on-prem
  • Powerapp is    cloud
    • Required to access sqlserver download a gateway from website.
    • Install given name.



item -----selectitem

Class:015

Pagenation concepts:
  • Pagenation is nothing but devide the data into a different pages.
  • When you working on large data (morethan 2000 itesm) avaid the delegation warnings, we are implement the pagenation.

1. What is the difference between if & switch?

switch condiction:
  • switch is nothing but multiple case statement.
  • switch is nothing but choice.
  • switch is nothing difference block and break condiction.
  • switch having default statement.



Class:016

Validations:

Icon --- If(!IsBlank(Textinput.Text), Icon.Check, Icon.Cancel)
Color -- If(!IsNumeric(Textinput.Text), Color.Green, Color.Red)


Class:017

GroupBy:
Choices:
AIBuilder:












































Comments

Post a Comment

Popular posts from this blog

Model Driven Apps

Image
Class:001 What are Model Driven Apps? Model Driven Apps are not pixel perfect apps like canvas app. (In canvas app we have full control about the app, like properties, font, color, screens .) (In Model Driven app are back by the data, based on that data we will create this Apps.) These data strored in dataverse/ CDS. (Common Data Services) Model Driven Apps focuses on adding components such as  forms, view,charts etc.., to using tables using an app desinger tool . Benefits of Model Driven Apps: Apps are responsive automatically. User experience is consistent accross all model driven apps. Layouts are pre defined. Migrating apps between development, UAT and production is relatively easy using solutions. Detaverse supports a strong and flexible data model. Security wise Data model wise it will be flexible. integration with office 356 integration with Canvas app (preview) Extensible with code. Create a Environment: we can easily move our customizations from  one environment to an...
Read more

My Intorduction

Hello XXXXXXXX, Thanks for giving this opportunity. I am having 3 Years of experience as a Power Apps Developer. For that last 1 years I have been working in IBM Company as a Power Apps Developer.  In that position, I have worked on various Technologies like, Canvas app Model Driven Apps Power automate SharePoint online (office 365) Coming to my roles and responsibilities: Creating and Maintained Canvas app & Model Driven apps. In Canvas apps  i have been worked on Power Apps Customizations forms, Used the functionalities like, Submit Form Patch Function Filter  Function Lookup  Function Search Function Working on Collection ( Collect , Clearcollect & Clear ) Validations working on  Gallery's  ( Vertical Gallery , Horizontal Gallery ) working on Variables  (Local & Global) Creating a Components (Re-usable block) Dropdown &ComboBox In Moden-Driven-App Creating Environment Working on Dataverse Creating Solutions Creating Tables Creat...
Read more

Canvas Apps

Image
Section: 001   ----Creta a Environment       (Admin Center  link ) MIcrosoft Power Platform: Power BI  --------------------------------------- ( Business Analytics ) Power Apps  ----------------------------------- ( Application Development) Power Automate  ---------------------------- ( Process Automattion ) Power Virtual Agents  ----------------------- ( Intelligent Virtual Agents) Power Apps: Canvas Model Driven Apps Portal Canvas apps ------------------------------------------ Mobile/tab device Model Driven apps --------------------------------- PC/Laptop. Portal Section: 004 What it Canvas Apps? What it Model-Driven- Apps? Model-Driven-Apps that are build on existing frame works, so, The layout, With munu sets, color of the menu item these are the per determined on the Model-Driven-Apps structur e. Why would you build an  Model-Driven- Apps?  Internal user of the orginazations that ograin can be accessing your mai...
Read more