What is collection & How to manage a collection in PowerApps ?

In the last article we learned about the different controls which exist in PowerApps although there are some more controls which we will discuss going forward before jumping into remaining controls let’s discuss here the most important part Collection.

What is collection?

A collection is used to store data that can be used in your app or we can say a collection is a group of items that are similar. For example, Student data collection where the collection will store student first name, last name and other information about the student.

To see it practically let’s open PowerApps editor and add a new screen and OnStart function create a collection.

Now to create a collection in PowerApps we have  “Collection” function in PowerApp and syntax is as follows 

Collect(Collectionname, items)

So, Student collection can be defined as follow.

Collect(StudentCollection,      {Name:”Rajat”,LastName:”Jaiswal”},   {Name:”Sandeep”,LastName:”Jain”})

OnStartCollectionNew

So, we have created our first collection. To view this in action add any control you want here we are using Gallery control.

AddGalControl

Once you added this control you will find the data properties and we can see our created collection which is “StudentCollection

StudentCollection

Here we can assign  the title and subtitle  properties of the gallery with the property Name  & LastName of our newly StudentCollection.. Just Save the application at this point and reload the app again.

You will find the following screen.

DataWithGallary

We can check our newly created collection by file option as shown below

StudentCollection_001

In this way, we can create a collection. Now, the next question is how to ADD/EDIT/Remove in the collection. So, let’s understand this now.

Add Collection

Just drag-drop textboxes, labels, and a button to add the data to the collection as shown below.  On Add, button onSelect write  below function

addCollection

Now, when you run and click on Add button. You can see the Record appears in your gallery as shown in below figure.

Collection Add

Remove Collection

Now, In the next step, we will delete the record from the collection.

The syntax of this is very simple

Remove (CollectionName,item)

Now, to achieve this add a delete icon in the gallery as shown in below figure.

DeleteCollection

On select of delete icon, we can write  Remove(StudentCollection, This.Item)

Here This.Item is selected item of the gallery to which we need to delete from the collection.

Now,  What if we want to delete the entire collection? then in such case, we have

Clear Collection

The syntax is very simple Clear(CollectionName)

So in our case, we have to write Clear(StudentCollection)

Now, to Edit a particular item in a collection the first this is select the item in the text box which we want to edit and to achieve this we bind the textbox by Gallery’s selected item as shown in below figure.

Selectcollection

Once you have done with this  then on Update button we can write Patch collection function as shown below

PatchSection

So the syntax is very simple

Patch(StudentCollection,Gallery1.SelectedItem, {Name:TextInput4.Text,LastName:TextInput5.Text})

so in this way, we can update the specific item (As shown above we updated only selected item from Gallery).

So, In this session, we understood Collection, add an item in the collection, Remove function to remove a specific item from the collection, Clear Collection to delete entire items from the collection and none other than Patch function to edit the collection.

RJ

Learn How To Start PowerApps Controls

Congratulations, in the last post you have successfully created your first PowerApp.

In this post, we will try to understand different controls available in PowerApps.  Before jumping directly into PowerApps one quick tip wants to share with you that PowerApps is very much inspired by Excel. So, whenever you stuck to any problem which you want to solve than just give a try how you could solve that particular problem in Excel. You will find most of the functions similar to Excel.

Just remember that  screen & its controls have global scope in PowerApps.

PowerApps support various controls which we will discuss shortly but before that would like to share that every control has properties and these properties has 2 types Input properties and output properties. We can update the input properties but not output properties.

with this let’s start controls:

You can use control by clicking  on control’s icon of Insert menu

ControlMenu

Label :- Label is simple a ready only control to show text value. We can change the properties like font, color, position, size etc.. from properties window.

You can write a custom function for any input properties or assign direct value.

Properties

TextBox : When we need input from the user then in such cases we can use Textbox control. For example, asking the name of the person.

Just to make you aware Text property is  Output property of textbox so you can’t assign value. while Default is in the input property to show any value in the textbox.

TextboxDefault_properties

Button: Button control is used to perform any action by clicking on it. You can write custom action using the OnSelect trigger.

Action

HtmlText :  When we have to deal with Html Data then in such cases we can use HTML textbox.

Html_Text_Input

Pen Input: This is one of the interesting control. When you need pen input from Apps like a signature or something that then you can use this control

PenInput

Date Picker : When you want date value then in such case we can use Date Picker control. We have provision to change DateTime format & time Zone from Local to UTC.

DatePicker_Control

DropDown:- Whenever we have multiple options from which we need to select the value then we can use DropDown control. DropDown control has Items properties to bind the dropDown options. If a user selected any Dropdown option then we can get by Selected property of dropdown.

DropDown_Item_Collection

Combobox:- Combobox most likely a DropDown and also provide multi selection option.

Combobox

Rating :- If we want a rating for a specific reason then we can use Rating control.

StartRating

Timer:  By the name, it is clear that it is a timer which starts counting. You can invoke an event on OntimerStart, OnTimerEnd etc..

timer_Control

Toggle: Toggle is just True/False option. So, whenever you want true/false option we can use it.

Toggle_Control

Radio Button:  Radio button is again normal control which you might have used earlier. You have a list of option and you need  to select a specific option then we can use a radio button.

RadioButton

Slider: When we required a predefined range and want a user to select from that particular range then slider is one of the option.

Slider

Apart  from this there some other controls like Form Control , Grid, Attachment etc.. which we will describe soon in our coming post as they need individual attention.

Till then enjoy reading.

The A – Z Guide Of Create the first powerApps

In this last post, we discussed the PowerApps templates. Now, in this post finally, we are going to create our first PowerApp isn’t it exciting?

So, as mentioned earlier login with the authorized credentials and after login you will find following dashboard screen. Here, we need to select a Blank Template as shown below. Here, we have a choice to opt mobile or desktop web. We can choose as per your ease or requirement and then press make this App button.

Dashboard_Blank_app

After clicking the make this app button we get following screen which is basically our playground for App creation or actual editor where we can manage our pages, add new pages, add controls  etc..

Editor_Area

As this is our first app, we are going to make it very simple and create an addition of 2 numbers screen (Although, it seems simple but bit tricky as well.)

For which we will click 3 label controls ,3 textboxes & 1 button and arrange them properly as shown in below figure. Here we can change the control’s default text. color, etc by property pane.

Rough_Screen_of_Sum

Once this part is done, in the next step we need to show the sum of First Number, Second number’s value in 3rd text box when user clicks the Sum button.

One more point which we need to take care is format property of the textbox.

formatPropertytoText

Now, to achieve this we are going to write a function on button click as shown in the below snap.

image

Here, we need to write the code in function’s tab as shown below in screen. if you see here we are using a SUM inbuilt function and using UpdateContext (an internal function) for assigning the addition value of the textboxes to a variable called myAdd.

Sum_Function

Now, once we are done with the above function, in the next step we are going to assign the myAdd variable (who holds the addition of text1 & text2) to our result text box. To achieve this select the textbox in which we need to show summation value & click on the Property window’s function tab.

Here, we have to assign the myAdd variable  as a data’s default value (shown in below figure)

assigning_Default_Value

Once we done with above steps, next item would be to run this App and do a quick testing. To run this App click on run button (Top right corner of the editor) as shown in below figure.

run

We will get the below screen to test our sum logic.

Test_result

That’s great we created and tested our first PowerApps. Now, in next step Save this application. After clicking File menu a new screen (as we are saving this first time)  will appear where we need to provide App name , description of app and icon. After providing this details click on the Save menu .

save_App

So, congratulations we have created our first simple PowerApps and saved successfully.

Save_App_done

We will see later how to publish it which is also very easy step.

In next article we will see more stuff of PowerApps till then enjoy.

RJ

It’s All About (The) PowerApps Tempates

In the last post, we discussed what is PowerApps and an initial point where we can register our self and start working.

We can use either web studio or desktop studio for creating the PowerApps. I generally, prefer web version.

In this article, we will see different inbuilt templates Apps which give us confidence that what the PowerApps can do.

Click on https://powerapps.microsoft.com/en-us/  and log in with your authorized credentials

signin_with_Microsoft_account 

so, After login, we will find below dashboard screen.

Dashboard_Screen

There are several inbuilt PowerApps templates available along with blank Templates. Let’s start few of them to understand the capabilities of PowerApps.

Service Desk:- 

This is simply ticketing system where we can see How many tickets are open? How many are closed? and How many are in progress ? along with ticket details. so, in the organization ticketing system required the can be a good App.

Service_Desk_Template

Assets Tracker:

This template app Keep tracks of the tools and equipment your teams need to do their jobs.

Assests_Tracker

Leave Request :

This template will help the organization’s employee to raise a leave request and manager will approve it.

Leave_Request_Power_Apps 

There are many more other templates available which you can use as an instant recipe.

As it is Microsoft tool so you can easily access Office 365, planner etc. but on the top of it, you can use Camera & Location feature as well.

Accessibility_of_camera_And_Location

Now, in next article, we will see how to start with a new blank App.

step by step powerApps Made Simple – Even Your Kids Can Do It

f you are not family with this awesome thing then surely you might be curious to know what is PowerApps ?, How it works? Where can utilize it? and there are many more questions.

To resolve all these queries we are starting a Zero to Hero series in PowerApps. You will find a series of the blog going forward and we will do deep dive in PowerApps.

What is PowerApps?

You will find a lot of different definition for PowerApps but for me, it is a tool which gives you the power to create your business application which can run on web/mobile/tab with a little writing or without writing code.

PowerApps tool is super easy to use and with the help of this tool, you can create the various business app in which you can use any data source like SQL Server, Excel,  twitter, facebook etc.

Although, PowerApps is basically created for Non-developers but still as a developer you can use it.

In nutshell, we can say it Platform As A Service model. PowerApps has various controls & templates which we can utilize to create our business App.

We can create PowerApps by 2 ways either we can download PowerApps app in Window 10 from Microsoft Store as shown in the figure below.

image

Or just use following URL http://powerapps.microsoft.com

image

Once you downloaded or open the PowerApps first or foremost important is to login into the tool using Microsoft /OutLook/office365 account.

Once you  done with sign up process. you have to provide your valid username & Password to access it further.

In next blog, we will see how to create our first simple Power app.

Keep learning