Datta Sai By Canvas Apps
Class:001
SBI Form Registration:
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)
1. Types of forms in PowerApps?
- New form
- Edit form
- 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?
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,
OnSelect --- NewForm(Form1);Navigate(TimeSheet_Add,ScreenTransition.Cover)
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 ---
EditForm(Form2);
Navigate(
TimeSheet_update,
ScreenTransition.Cover,
{updateitem: Gallery6.Selected}
)
OnSelect --RemoveIf('08_Time_Sheet',ResourcesName=Gallery6.Selected.ResourcesName)
Class:017
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 --- 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?
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:
- download sqlserver
- install with next button configure user name
- download sqlserver management studio
- install
Authentication:
- sqlserver having two types of authentications.
- sqlserver authentications
- windows authentications (System user can able to access the sqlserver)
Create user:
- Security
- click on new user
- 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.
Validations:
Icon --- If(!IsBlank(Textinput.Text), Icon.Check, Icon.Cancel)
Color -- If(!IsNumeric(Textinput.Text), Color.Green, Color.Red)
Color -- If(!IsNumeric(Textinput.Text), Color.Green, Color.Red)
GroupBy:
Choices:
AIBuilder:
Comments
Post a Comment