Canvas Apps

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:

1. Canvas
2. Model Driven Apps
3. Portal

• Canvas apps ------------------------------------------ Mobile/tab device
• Model Driven apps --------------------------------- PC/Laptop.
• Portal

Section: 004

What it Canvas Apps?

What it Model-Driven-Apps?

1. Model-Driven-Apps that are build on existing frame works, so,
2. The layout, With munu sets, color of the menu item these are the per determined on the Model-Driven-Apps structure.

Why would you build an Model-Driven-Apps?

•  Internal user of the orginazations that ograin can be accessing your main system like you build from Pc / Laptop Model-Driven-Apps makes more sence.
• There is a lot of  add benefits building a model driven app.

What it Power Automate ?

• Sending an email
• Re-assigned records
• Getting approval
• Transper records
• Soft of calculations

Connectors are allow us to Connect to different together

 

Section: 003

Left Navigation:

        Tree view

        Insert ------------------ (Label, Buttons,Text etc.,)
        Data
        Media
        Advanced Tools

Tree view have list Objects like lables, text lables, ddl, icons, media, gallery etc.,
Tree view have list porperties, 

Middle Pane:

 Right Hand Pane:

• In right hand pane we have properties of object.
• we can adjust object properties like  text name, forn size etc, alingment..,

Formula Bar:

Section: 004

Welcome to section four, and in the section, what we're going to be talking about is how to

build apps from data.

Power Apps has built-in AI (Artificial Intelligence) that allows users to create a data file using things like Excel,

and we have more advanced options like SQL and so forth.

But for the purpose of this lecture we can have, we can actually create an app automatically from Excel.

So what does that actually mean?

let's say, for example, I have an Excel sheet and it has a table, and in that table I've got

headings that his first name, last name, mobile number, business phone number, address and so forth.

So a conventional telephone book list so I can actually create an Excel sheet and then take that Excel

sheet and upload it into power apps and PowerApps or build the application for me.

But what does it build it based on?

It looks at the data file and goes, Okay, you've got a data file.

Yeah, this is a list of information, so it'll create a screen for you to be able to capture new contacts.

It'll create a screen for you to be able to edit, and it'll also create another screen that shows you

a list that enables you to search that three primary functions is search, edit and create.

So by using this feature or function of PowerApps to create an app and start from data means I create

a database.

I create or connected data source and then PowerApps will do the initial build of my application.

So in this section, what we're going to do is we're going to create a really, really simple app and

I want you to follow along with me.

We're going to start off by creating a data source, and once we've created the data source in the next

lecture, after that, we're going to actually let power apps actually build the application for us.

It's a very simple application, but to give you the concept of how building an app and starting from

data actually works on on your screen, now you can see this a little bit of a logical architecture

that talks about the mobile applications of this power apps.

We're going to connect to Office 365 to OneDrive, and then in our OneDrive, we're going to create

an Excel file and then that Excel file is going to be the database for application.

So the context is, well, let me give you a little bit of a business case.

Let's say, for example, I have a bunch of stuff and these staff are going out to a trade show and

they need to collect names and telephone numbers of potential prospects that we

might want to call at a later stage.

So what I want to do is create an excel sheet and then I want to imported into apps and perhaps built

me an app.

And then I can take that app and I can share that app with my staff members so they have a mobile application

to be able to capture those leads from an event.

It's a really, really simple you in just a couple of minutes, we can actually build a fully, fully

scaled, fully functioning application, starting just with and an Excel Excel sheet.

All right.

So I want you to follow along with me in the resources you will see.

There will be a data file so you can create your own data file.

I encourage you to do so.

If you struggle a little bit with the data file, I'll put the data file sample that I create in this

lecture into the next the next lecture, and then you can just follow along with me.

All right, so let's get going.

Section: 005

Screens:

• Layouts
• Scenarios/Templates
• Layouts:
• Blank
• Split-Screen
• Sidebar
• Header and Footer
• Scenarios/Templates:
• Black
• Scrollable
• List 
• Sucess
• Tutorial
• Email
• People
• Meeting
• Calendar
• Portait Print
• Landscape Print

Labels:

Text --------Now()

Text --------Today()

Text --------Text ( Today(), "[ $-en-US]dd/mm/yyyy")-------Language expressions

Text --------Text ( Today(), "[ $-en-IND]dd/mm/yyyy")------Language expressions

Text -------- "Hello, "& User().Fullname------------------------Display current logged in user

Buttons:

• Click to navigate
• Click to set labels
• Click to update properties
• If you want to previous screen using onSelect funtion
• OnSelect ------------ Back ()
• OnSelect ------------ navigate ( HomeScreen)

Onvisible ---Set(results,"") --------------------Creating a variable on screenlevel

Onselect ---Set(results,"Sucess")

Onselect ---Set(results,"")

Text --- "x: "& Plane.X

Text --- "y: "& Plane.Y

    OnStart --- Set(hor,108); Set(ver,441)

OnSelect --- Set(hor, hor + 5)

OnSelect --- Set(ver, hor + 5)

Plane --- x --- hor

Plane --- y --- ver

Text Types:

• Label
• Text Input
• HTML Text
• Rich Text Editor
• Pen Input

Onselect ---  Collect(images,{sketch:Drawing.Image}) --------------Save

Onselect ---  Clear(images); -------------------------------------- Reset

DisplayMode --- If(

                    CountRows(images) = 0,

                    DisplayMode.Disabled,

                    DisplayMode.Edit

                  ) ------- if count value is "0" disable reset button

Global Varaibles:

Onvisible ------------ Set ( results, "") ---------- screen lo edit chayali      ( results = varaible name)

OnSelect ------------ Set ( results, "Sucessfully..!") ---------submit button lo enter chayali

OnSelect ------------  Set ( results, "Failure") ----------------reset button lo enter chayali

Text ------------------ "variable name enter chayali"

Input Types:

• Dropdown
• Combo
• Data Picker
• List Box
• Check Box
• Radio

If you want to change the text value into a color we need to use "ColorVaue" keyvalue.

Defaults ---- ListBox1.Selected.Value

Defaults ---- concat(ListBox1.Selected,Value, ", ")

Defaults ---- concat(ListBox1.Selected,Name, ", ") ----------------Get the data from SP list.

Check Box
Oncheck ----- Set (Time, Now())
OnUncheck ----- Set (Time, Blank())   

Section: 006

Input Types:

• Toggle
• Slider
• Rating

Default ----- toggle.value ------------------------------------------------------- Try in textinput lo

        

Default -----If (toggle.valu = true,  "Price : $75.00","Price : $100.00")

Input Types:

• Container
• Timer   (Need to refer again)
• Address (Need to refer again)

Forms Creation:

Images:

Audio: (Need to refer again)

Icons:

         Add, Cancel, Edit, Check, Search, Filter, Soft, Reload, Trash, Save

Add Picture:

 Navigate function:

OnSelect ---Navigate(Accounts,ScreenTransition.Cover)
  OnSelect -----Navigate(Contacts,ScreenTransition.CoverRight)

Section: 007

Collect:

• Stored into a temporary storage (Cart).
• I don't want to save the data imediately. once user click on the submit then only i want to save the data in storage device.
• Types of collec:
1. Collect
2. Clear
3. ClearCollect

OnSelect / Select: Properties

Select:

Here we are click on one button. It will execute multiple buttions.

 Refresh ( Excel Sheet)

Text ------------------- "Tel : " &  ThisItem."Mobile Number" ----------------------Tel : 8553322492

Text ------------------- "Email :" & ThisItem."Email Address" ----------------------Email : @gmai.com

Section: 008

Data Sources: Link

Telesign ----------------------------------SMS

Twilio -------------------------------------SMS

Freshdesk --------------------------------Helpdesk

51 lession -------------------- (Need to refer) Media

Collect:

• Temporarily Store data.   

Try this one & see the result in view tab. (the order in not format)

Variables:

Number Var:

Section: 009

Power FX:

• Microsoft Power FX is the low code language for expressing logic across the Microsoft Power Platform.

If :

• Show / Hide
• Set color
• Set mode
• Set font Size

Maths functions:

 

the Fill property will change the background color of the text label and not the text.

Section: 010

Filter Function:

Filter ( datasouece, expression)

List Name: 

AccountTab (AccountID, Company Name, Email Address, Phone numner)

ContactsTab (ContactID, AccountID, FirstName, LastName, EmailAddress, Mobile number)

• First we need to create a one Excelsheet.
• In both Excelsheet the common column (AccountsID) should be created.

• Go to make.powerapps.com
• Select the connections / select the Excelsheet / select tab.
• Text ----- ThisItem.Firstname &" "& ThisItem.Lastname

Using a dropdown to filter data:

Items ----------- ["Silver","Gold","Platinum"]

Search: 

Search ( data, Searchstring,column )

Edit Record:

• Show a list of accounts
• On Select of an account, navigate to edit screen
• Edit record
• Navigate to Sucess Screen
• Click OK to return to companies list.

Delete Record:

Remove (Datasource, ItemToDelete)

Mappting currnt user:

User():

Operators:

• And  - &&                                                                (Number --------String)
• Or    -  ||
• Not

IsBlank

App Object:

• Set global vaiables when you app start.
• Creat a varaible in app level.
• OnStart ------------- Set ( gst, 0.10)                           (0.10 it means 10%)
•  . . . Run OnStart
• Textinput ---------
• Textinput ---------Default -------- price.Text * gst
• How to convert number to text
• 
  
• price.Text * gst
• Text ( price.Text * gst, "[$-en-US]$00.00" )

Global variable 

Math Operations:

Delegation Warning:

• By default it will read the data upto 500 Records
• But we can extend up 2000 records.

Calendar Functions:

• Items ----- Calendar.MonthsLong() ---------DDL
• Items ----- Calendar.MonthsShort()
• Items ----- Calendar.WeekdaysLong()
• Items ----- Calendar.WeekdaysShort()
• Items ----- Clock.AmPmLong()
• Items ----- Clock.AmPmShort()
• Now() ---------Text
• Today()

ColorFade properties:

Concatenate:

• Join 2 or more strings to form a new string concatenate (sting1, sting2 .., )

CountRows():

• Count the number of rows in a table or collection.

Working with dates:

• DateAdd (date, number of the days to add)
• DateDiff ( Start date, End date)

Click to call : Function

• Please a call from the app.

Download:

• Download ( "Web address" ).