Microsoft PowerApps Basics | Bharath Chennu | Skillshare

Playback Speed


  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x

Microsoft PowerApps Basics

teacher avatar Bharath Chennu, Consulting & Training

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Watch this class and thousands more

Get unlimited access to every class
Taught by industry leaders & working professionals
Topics include illustration, design, photography, and more

Lessons in This Class

25 Lessons (6h 32m)
    • 1. Introduction

      1:36
    • 2. What is PowerApps?

      7:29
    • 3. PowerApps Environment Explained

      11:36
    • 4. Create your first PowerApp from Excel

      6:42
    • 5. Create a Submit Form in PowerApps

      7:07
    • 6. Display Data using Gallery Control and Data Table Control

      2:47
    • 7. Create an app from SharePoint List

      5:58
    • 8. Customise SharePoint list form with PowerApps

      18:45
    • 9. Send emails using PowerApps Connectors

      13:37
    • 10. Open PowerApps in your mobile Phone

      4:18
    • 11. Types of Variables in PowerApps

      5:55
    • 12. Demo: Local and Global Variables

      17:32
    • 13. Demo: Collections

      40:21
    • 14. Design a powerapps gallery

      17:02
    • 15. Search, Filter and Lookup

      18:11
    • 16. Demo: Multiple Filters

      16:28
    • 17. Patch and its uses

      25:21
    • 18. Patch Complex fields

      33:02
    • 19. Multi Screen Patching

      21:05
    • 20. Add PowerApps to Teams

      3:36
    • 21. Call Power Automate from PowerApps

      18:38
    • 22. Split, First, Last and Replace functions

      4:52
    • 23. Get version history of List Items or Documents

      55:01
    • 24. Dataverse with PowerApps

      12:58
    • 25. Validations

      21:57
  • --
  • Beginner level
  • Intermediate level
  • Advanced level
  • All levels
  • Beg/Int level
  • Int/Adv level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

165

Students

--

Projects

About This Class

Microsoft Power Apps is part of Office 365 Ecosystem developed for designing applications in less time with aim as "Low Code Fast Development". 

Many Fortune 500 companies using PowerApps to achieve the solutions for their Intranet Portals and few mobile requirements.

Meet Your Teacher

Teacher Profile Image

Bharath Chennu

Consulting & Training

Teacher

Hello, I'm a Microsoft Certified Software Consultant with 10+ Years in Microsoft technologies SharePoint, PowerApps, MS Flow, Azure and .NET.

See full profile

Class Ratings

Expectations Met?
  • Exceeded!
    0%
  • Yes
    0%
  • Somewhat
    0%
  • Not really
    0%
Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update.

Why Join Skillshare?

Take award-winning Skillshare Original Classes

Each class has short lessons, hands-on projects

Your membership supports Skillshare teachers

Learn From Anywhere

Take classes on the go with the Skillshare app. Stream or download to watch on the plane, the subway, or wherever you learn best.

Transcripts

1. Introduction: Hello everyone. This is your instructor for this course or class about Power Apps. Whiteboard apps, or EPS, is developed by Microsoft to help their customers create apps using low code and fast development. So what will you learn in this class? You can design a PowerApp from different data sources, say XL, our SharePoint list. And also you can design a Canvas app. You can connect with different connectors and create an app. You can easily integrate Between four, Automate and Power Apps and also SharePoint. After completion of this course, you will able to design for EP and integrate that in to SharePoint portals. You can build apps for mobile and tablet. You will easily integrate data between SharePoint and for EPS, as well as Excel and many other external connectors. Okay, desk, Let's start the class on Power Apps. Thank you. 2. What is PowerApps?: Welcome to my Power Apps class, our course, whatever. This Power Apps is developed by Microsoft. So this is a local, fast development platform. This is mainly the combination of PowerPoint and Excel. Okay, we can see like this, because this Power Apps contains the expressions are drag-and-drop controls similar to PowerPoint and Excel. Okay, so here we can create a mobile layout app on a tablet layout or animals monitor layout apps. So you just lake response you can customize here, extend, build in whatever fashion Vineet with this Power Apps. We can easily integrate Excel, SharePoint and many other data sources with these power-ups. Okay? So here, in this at least centrally in the past two years, despite many people and many companies are adopting these Power Apps because of four reasons. Because we can engage customers and employees and optimize operations and transform the products. Okay? So Microsoft Power Platform is a part of Office 365, and this Power Apps is part of Microsoft Power Platform along with others per BA, Microsoft Flow, which is known as power made. And also apart from these, we have Power Virtual Agents in the Microsoft Power Platform. Okay? So know, in this course class, you will focus mainly on the canvas apps. Using Power Apps, we can create two types of EPS. One is canvas apps and model-driven apps. So in this canvas apps can create amps from 200 plus sources. And we heal Many going to see Lake 150 plus connectors from the external software, say lake Dropbox and acinar, and Gmail, and LinkedIn, etc. Okay. This is the You want to crack these Power Apps, go to make dot powerapps.com. And you can get one month three trail to use this bar EPS. But if you want to use this Power Apps for more than three months, go to Developer Program Office C64 dollar per program and sign up there. And you will get Office E3 subscription, then you can easily use this Power Apps for more than three months. Okay? Now you are seeing the landing page of the Power Apps. On the right side you can see home loan apps create data flows solutions. Okay? So here we can create an app. In many ways, lake from the scratch, from the data. Hardly are already available with the already available templates here. And we can create us with phone layout or tablet. Luke has a already told you before. So if you want to create this app, a simple bar AB, we can start from data, get amines. We can a collection of items in it, or a SharePoint list. We need to just pick up the source. Generally SharePoint developers will pick the SharePoint lists. And if you are in Excel, develop but to pick up from the Excel. So once we pick up the data source, it will create three screens. And you can see all the screens. And you can also see here the sections. This T view on the left side and on the top, you can add controls on the read set the properties. I will explain these alleles in the next classes. So the main building blocks for despite reps are controls, properties, formulas, okay? So first controls, controls means list like textbooks as date, big, list box, and many other advanced controls. And coming to the properties for every control, there will be some property right. So he'd also similarly, for every control, there are many properties which we can access from the top, drop-down or on the right side. So we can also have advanced properties here for a control. And if you want more information about these controls, go to Microsoft Docs and come into the formulas. We can write some Excel lake functions, say function of parameter, our parameter. Okay? So these formulas can also be available in the Microsoft Docs. And these some behavioral formulas here are navigate, enable, disable any data into its variables and collections. And coming to the formulas you can see DID is if foreign law space area where we can write these functions and they'd call the parameters inside each, every whatever. Here. Okay, we just need to drag and drop. I will explain these in their classes. And for farmers reference Google, Microsoft dogs and null. Let's see how we can start and restart. So we need to our own Blia raped. So good to make dot powerapps.com. And you start this creating apps. And once again, I will come to this class, our course on Power Apps. 3. PowerApps Environment Explained: This class, I'm going to explain the structure of Power Apps. Okay? So open your Office 365 icon with Office.com here. And on the left side you can see Paul reps here. Click this and open any app you already created, or I created a few apps here, so I'm opening the app. So here from a SharePoint is 0 and click, I'm selecting this. And of course set appendix. You can select or click Open here, or you can go to apps on the left side, and you can select the app. And on the top you can see all the options available here. To retain app, to preview an app, let kids play, and to share an app with your colleagues. And if you want to shape this app to the other entertainment, you can export this by clicking Export Package. And so you can see the settings and you can see monitor and analytics here. And you can also see the details of the SAP. See the app actually convince details. And every rep will have a blink here, okay? And also NFAT. This we must remember always. Okay, and also we can see which version is live here. So here for me the version one is leave here. So Power Apps, if you modify anything, it will maintains the versions. Okay? So this is one good point we can learn from here. And also the, there will be connections in the power grip. Suppose if you are using this power-up along with SharePoint, it will show the connections from the SharePoint. And suppose if your connection sees from the Excel, it will show the actual year, okay? If E and here in the flow. So it will show any flows are related to these preps. The flows means Microsoft Power Automate. Okay, so now let's go to the actual insight of this Pareto. Click Edit. And the store reps to do is getting loaded now. So in this when, once this Power App Studio is loaded, I will show you here all the structure, how it is there. So no, you are seeing this a mobile layout here. Okay. So there are two layouts in Power Apps, money is available and tablet layout. Now, whatever you are seeing is. A layout. Okay, so now let's check each and everything. So on the left-hand side, if you see this is a preview. So here in the preview it will evoke all the hierarchy of the components. For a simple or a sofa stone is an app, okay? So this is the first one. And the second one will be the screens, okay? In the screen again. So suppose this is a screen. Now for me, this is the screen name is Bro screen so that I can browse the data here. Inside this grows screen, you can see many elements, say image element label to label one gallery, rectangle. All these textbooks is so all listings will be available. Okay? So first we need to remember that on the hierarchy will be like this. Say app, screen form. And again, and after the farm will have text boxes. Checkboxes are any, some input controls, galleries like that, okay? And for every element in this PowerApp, say here, there is a check box here. Select this. And if you want to know the properties of this checkbox, you can see on the right side here the properties to change the text, the default, the display mode, all this visible. You can check all the properties on the right side here, you can change the color, background, color, border, everything for this element, decile a place for all the input elements. So, and also, as we know that we will have an event for every control C example in JavaScript, we will have onClick. So for this option, for these checkboxes, we can also have events like this on the left side top here if you see these other properties and also some of the same events kind of thing on select on chick. Everything will be available here, okay? And on the top if you see there is a function here, okay? Here you can write the functional formulas here. Related to the Power Apps. You can drag this formula is very big. If it is simple thing, you just keep it like this. And you can also format this coding here. And you can also remove, remove formatting. Okay? And apart from these, if you want to insert any controls, just click on the whole set here. Okay? And you can see if you want to insert a new screen in the form. And the end application, you can select the new screen. You can see all the new screens here. And if you want to set the label year click label. And the label comes here like this. And leg this button, text inputs, input controls here. All these things will be available year itself. And if you want to insert any gallery here you can see data table. And you can also insert a chart here. You can see these things. All things will be available here. And apart from this, for every, there will be some data source. And if you want to see what are the data sources really tricky spot it. You can go to the left side here. And you can see, select the storage icon. And you can see here, presently there is even a data source. It's name is mumbles list from the SharePoint. If you want to add one more Data Service. You can also select here flushed conductors, okay? See SharePoint. And we can add multiple data sources. And in the simple power rep, we can add more than one, okay? And if you have more media congruence, we can upload it here. And here. Somebody to answer tools, lake monitors, everything will be available on the left side. Okay. So if you want to preview this app, just click on the year, the arrow symbol F5. And you can see this preview of the, okay. This is the browse screen. And if you click this, it will go to the individual item details. This is a detail screen we can see. And if you click this pin icon will change to edit screen. Get these three things centrally we will create for a simple power-up. Okay? And also here you can see some icons next to the scope. This is the App checker. If you suppose see here, select this and you hear equal to. And you can notice in the red color cross mark, which is like it's showing the error. And also here it's showing error. So all the errors will be a chicken away clicking this app checker here. Okay? So, and also we can undo redo, just like in Microsoft Word here also we can undo, redo everything. Okay? So I'm clicking undo now. See, you know, it's the editor has gone, it come, it came goods previous state. So like this, we can make use of all listings. And if you want to save this app click File, and it is an option to save here, save, okay? And we can publish this. Okay? Like this. We can check the simple things. Okay? So here we can also share this click Share on the left side. You will get a new tab here. And this app can be shared with colleagues. Suppose if they want to share this with my colleague Harish, just type here is name and make him as a co-owner and share. Again, now, he will get an e-mail and he will be the winner for this app. Okay. This is the a brief overview, a vote, all the sections in PowerApps. And how to save here, how to preview, how to get the details of a PowerApp. Okay, how to, how to get all the controls and INSEAD that controls on the form. We have seen all listings and this will be the basics things we, you one, learn R so that you can design a good rep here. Okay? So hope you understand this class if you have any comments just mentioned. Okay. Thank you for watching this class. 4. Create your first PowerApp from Excel: In this class I'm going to explain you about how to create a simple Power App application using Excel as a data source. For that, we need to create an Excel sheet in OneDrive here we have a, if you are using any license, Lake Office E3 subscription, you can get here OneDrive for business. Okay? So click this OneDrive for Business and create a new Excel sheet here, Excel workbook. And you can create the Excel data here. With some employee data. Yes. Okay. Employee name. Yeah, you can mention name, employee designation. Here you can view skills. Okay. And here you can also mention like joining date of the employee, shining debt. We can free up some space. Okay, So these are the four columns. Let's fill the data here. And employee name is Bernard, employee designation is manager's skills point. Joining date tenth, FEB 21. Okay. So you mentioned like the name Krishna. His name is developers and skills here, sequencer, running deities. 23rd, March 2020. Again mentioned like this. Now you have created a data. Okay? So now let's convert this data in the table here. The select all the data. And on the top what to inset here and select Table here and click Okay. Now, our Excel data is not a true table here. If you go to Table, listen here, and you can change the name of the table name and name it as EMP. The MPT. We'll shortcut employee table. We can now save this workbook Excel book and name it as Employee Info. And save it and close this file. Since the Office 365 seamlessly integrated with all the components available here, the Power Apps. And you go to Power Apps. You can easily access this Excel sheet. Okay? So now in the Power Apps, if you go to the homepage or the landing page or the webs of this Power Apps. You can notice here, start from data. You can start from data. You can select Excel Online. Okay? So if you, if you set up the Excel Online, it will create a connector. Here. A connection between Power Apps and OneDrive here you can notice here, okay, so I have selected this wondering connection. And from the OneDrive it is showing the following available Excel workbooks. Here out of Excel workbook name is Employee Info. And when I click that, I can see the employee table which we have created, the Excel, set up this and connect. And now it's taking us to the Power Apps Studio. And basically it will create a three screens. Okay? Here, it's created a mobile app, okay? We can see here. And it created bro Screen1 details screen one, edit screen one. Now let's preview this app fast by clicking F5. Or you can click this forward arrow. Click this. And now you can see the simple has, has been created nicely here. And you can such if you want to search with the developers day EV. And it is showing developers. And you can also go to individual record here by our item here, by clicking this arrow, you can see the sampler designation, dollar per employee name Krishna joining date, skills, everything. And if you want to believe this, you can delete here. If you want to edit this, you can edit here. And you can name. If you want to change, you can change to hurry. So and click. Okay. So now it's getting updated here. Okay, So now you can see here the name is subjected. The simple app has been created by just selecting the data source. And if you also can delete this data, click Delete. It will go, it got deleted, and now you can see only one item. So this is how a simple thing we can create. Read. We can update, we can delete all the four crud operations. Crud operations, create, read, update, delete. Created easily with this Power Apps. So despite RFCs, like Microsoft seats, low code, faster development. So it's clearly, we can see these operations are easily performed by these integrations. Okay? If you want to create a new record, click Plus symbol here, and you can give an entry here. Okay, So this is how you can create a simple Power App using Excel as a data source. Thanks for watching this class. 5. Create a Submit Form in PowerApps: In this class, let's see how to create a PowerApp from scratch. Okay, For that, we need to go to office.com and click your Power Apps. Here on the left side. Click Create, select Canvas app from blank here. Okay, Here you can take tablet or phone. I'm taking tablet here. Okay. So and giving the name my first app, click Create. And known. This studio is loading here, power Apps Studio. Here. Once we add this, this is a Canvas, okay? You can do if you want here, like this. And GMO. Okay? Now, let's add one data source to eat at data. So here let's connect OneDrive and I will use the Excel Online. So Exelon lane. So in the Excel Online, in the previous classes, we have created one table. So OneDrive for Business select here, wondering and employee in for rate. So select that and set up the employee table. Cannot use unique column from Excel table insect auto-generated ID into Excel table. Okay, let's click Connect. Once you've done this, you click insert on the top, go to Forms and click Edit. Ok. So because we are creating a nap from scratch, So we must use forms here. Okay? So this forms it is asking to connect to data. So we can, on the right-hand side, data source nominees there. So we need to do employee table here, assign the employee table. And now two subfields. So what fields you want to show? Okay? So here we can add fields. What are the fields we have? Employee name, employee designation, skills, joining data. I'm not adding ad. Okay, now you can see here all the three fields came here and in the columns. And I can select the layout. There is vertical layout. So it can give horizontal layout here. What tickle, and then the columns I want show only one. Now you can see employee name, employee designation, skilled select this. Okay. So now let's see the preview. Hit Control S and it is asking to save in the Cloud. Okay, save exceeding now into Office 365. And go back again and now see the preview by clicking F5 here. So no item could displace it because this form properties or need to check first go to the left side tree view and go to form, set up the phone. And he had the default model. The form is edit. But we need new here so that new fields will be visible. Okay, the default mode of the form is CNG to new. Okay, now let's go to 50 and see the preview. Now you can see here, okay, Now let's add one small button here to insert the data. So go here and get the button. See it Lake submit. Okay. So in the submit, just like I told before, there will be events. Just like in JavaScript, data will be an event for the button. Here also for the buttons there will be some events like on select. So if anybody clicks it, it is considered as an unselect. So here what we need to do when you do submit the form. So you're straight one small formula. Submit submit form of form one. Okay? So this will help us in submitting the form. And after submitting the form, we need to reset the form, okay? So that these values will become blank. So right, that visit, visit formal form one. Okay, So now let's save it and go here. Now you can see here it's not. Okay, let's submit few values. Okay, I'm writing here the name Here. Test, tin, testers, skills, selenium, and clicking Submit. And it is, something is happening here. And form also clear. Now, let's go to OneDrive and check the Excel sheet, whether this data came into our Excel sheet or not, this data and set it or not. Okay. Now you can see here, it's not kin. So yes, small-scale. See Vishnu desktop, Selenium. Okay, This is all you need to do is small. You can create a small app in Power Apps. Thank you for watching. 6. Display Data using Gallery Control and Data Table Control: In the last lesson, we have seen how to submit data so that it will insert into the Excel sheet. Okay, So now let's see how to show their data from the Excel sheet with the different controls here. So the controls which will be useful for displaying data, Gallery control and data table here on the right side you can see, okay, so let's add one new screen, blank screen here. And add these controls to add data table here. So it's asking us to do the data suits you the employee table as data source here. And give you the fields. I'm adding the fields employee name and blow designation skills at you can see now the two records visible now here. Okay. The two records which are available in the axial treat are displaying here. This we have done through data table. Now let's see how to display these data with Gallery control. Okay, for that ad Gallery control. To the screen. Here, go to the right side and here galleries, if you didn't the galleries, blank, vertical, horizontal, flexible. And so many things are there here. Just select one. What tickle here and you got here the gallery control. So this is a gallery control. So this, this also needs one data source. So here also glared skew as employee table. And now it's showing that data. Yes. Okay. So it is having the layout, image, title, and subtitle like this here if you want on your table and subgradient, you set up this, you can get only data lends up creatively. This, the F01 is data table here, the below a nice Gallery control. Okay, this is how we can display the data from my data sorts in there. Power Apps screen. Okay. 7. Create an app from SharePoint List: In this lesson, I'm going to show you how to integrate SharePoint list to the Power Apps. Okay, so here the SharePoint list will act as a data source to create an application in Power Apps. Okay, so now I'm going to my SharePoint site collection, which is available with the Office subscription. So here I'm going to create a small list here, going to site contents. And I'm clicking new here, and I clicking list here. Okay? Here I can take blank list, our issue character or whatever. Okay, so here already there are some templates. We can, we can make use of the templates hurdles. We can create the blank list here. Click blank list. And here we can name the list. Okay? So my list name will be medicines. Okay, So I'm creating now. So if I create a new list in SharePoint, it is showing a default column with title and we need to add the other columns. So in the other columns I'm creating one by one column here. So the title will be the medicine name of the medicine. New treatment trips means like Deb mentioned, which will treat. So clicks it. Or just to mention treatment here. And I will do expiry date here, okay? For this is my list in SharePoint and I will let you list items. I'm giving here Madison names. This is assembled atom so you can add whatever things. So I like this argument to list items in the SharePoint. No, good to Power Apps. And the Power Apps. Let's add this list as a data source. Okay? See here, start from data is we have an option here. So I'm selecting that SharePoint here because we need to create from the SharePoint list. I'm clicking SharePoint. So it's asking now the recent sites, it is showing that connection here with the SharePoint. And if you don't have the Connection, click new connection and create the connection or the SharePoint. Okay? So I'm selecting the already available connection here and it showing the recent sites. Okay? My say our site is practice SharePoint. So click this and our list name is medicines. Let's see. Okay, medicines and the silica Medicines List and connect. Click. Once you click Connect, you will notice that the app is getting generated. See here, automatically the app is created with the three screens. One is browse screen detail screen and the screen, It's just like what we have done before. We take cell here. And you can go, you can preview it by clicking F5. And you can see the filtering with this such items. But you can also see editing Here, Okay? And you can cancel this. You can delete if you want. You can refresh, we can solve. We can add a new item here. If you want of reading, you can do like all the crud operations, create, read, update, delete. Okay? So this is how if you want to create an application from SharePoint list. 8. Customise SharePoint list form with PowerApps: In this lesson, I'm going to show you how to customize SharePoint new list form with Power Apps. For that, we need to create a list in the SharePoint. Go to SharePoint and create a simple list here. So while you are creating a new ListItem and the SharePoint, you will get a small window on the right side, right? So we will customize certain window here now. So further, we need to have one list here. So I'm going to cite contents and I'm clicking New Year, new list. So I'm naming it as electronics. So create. And after cleaning the list, we need to add some columns. Let's add some columns and to the list by default, you can. Okay, now let the state, it'll be like a electronic product ID. And in this Add Column, let say like product name. Save it. And next one is we can add this product name, and also we can add a year. What is a product cost? Okay? So also we can add from which country this manufactured. Okay? So here I'm adding city. So here I'm adding a digital single line of text trunking. So here again, country, I will give okay, Spirit. And finally began, had some kind of C readings kind of things. Okay, so I'm taking this as a number column and then taking the readings. And click Save, right? So my columns now our title, product name and product cost, city, country, ratings. Okay, so if I click New here, you can see right-hand side window is coming. Here. I need to do the entries for all these fields, right? So if you want to customize this, generally, we can use SPX or PowerApps. So if you want to use less cooling, so we're now paying for this power reps here. Okay, so let's see how to do this. Now. If you observe on the top of the list name, you can see a small ribbon here. And here there is an option like integrate Power Apps, okay? Since we want to customize this new list form, click customize fonts here. So once you click this customized form, it will open a Power Apps here. And the tablets good to again, SharePoint and go to the site. And so now this Power Apps is learning in the meanwhile, we, let's go to, again to the SharePoint team site contents. And we created electronics rate. So and they also, to get the countries, I created a lake, you can create countries. Yet one more glitched, a master list, which will contain all the continents, India, so Korea's Sweden, China, USA, and also cities here. Okay? Cds we can also create like this. And we can assign the country, which it belongs to here like this. Okay? Now, let's go to our form. And you can see the form here. So everything is nice. So let's change the background color of the font. Okay, so go to the properties on the right side and you can see here advanced. And the form is having fill here. So let's fill this with some light green, light to blue or something here. Okay, so now we have fully formed with light green. And no, let's customize this formula. Okay, so title is normal product name is with textbooks cost, cost is in number column, right? So let's make it different control. Let's add different control for this. So the product cost, normally, we can define a range. Okay, so what shall we do is select this data card. These are data cards. Inside the data cuts. There will be the actual controls like textbooks are labeled here. Okay, so first let's customize this product cost. Okay? So by default, the data code will be locked. So go do any changes to it. We need to unlock it first, okay, So select this text box properties. You can observe here all these things and go to the data occurred and go to Advanced here. And here, unblock chains the properties is just unlock it. We can now introduce these textbooks for the product cost, I will take different control, let's say some input control like Slater. Okay? So if you want to add slider to this and just select the textbooks and add it. Okay, Now the slider game, so delete the old control textbooks. Okay, before deleting it, saved the name here. Okay. So we will rename this new slider with the world name, okay, then if any connections have deal with the warning, it will be satisfied and no errors will come here. Okay, Now let's do these textbooks and delete it. And no, rename this slider with the woolen data card value three. And know a little bit adjusted. And you can see it, it murkier. So let's see how to solve this problem. The formula bar. And you can see here, value of data card 3 dot TXT scoring. Value wins. Data card. This is generally a text boxes. Treat. The values in the textbooks is a string. But in the SharePoint we have given it as M number rate. So what it done value of data card, well-lit read.table. It gives you a number written. It will return the number format. So no, we have replaced this textbox with the slider. So we need to change this full formula here. Now we can just remove this value takes to even remove here. And we can also remove this value of and dot lot when you know that it has gone. Okay, Now, let's check this slated properties. Here, the Slater properties and max and Min, okay, So from a 100 to give you one lakh, or we can reject those int. Okay, the product cost maybe. Okay, now let's save this and go to this. Let's preview this. Okay? No, no items are coming. Okay? So what we need to do from conical form and change the default mode to new. Okay, no, save it. And again see the preview. And now you can see the preview, okay? And here you can see the product cost. By just using the slider. You can see, you know, what shall we do? Iis, publish this to the SharePoint. Okay, So after publishing it, Let's go and see whether this is reflecting in our list. Our list name is electronics, right? So Electronics is it to refresh this page and click New here. And now we can see the world form. And again, refresh. I think it is not appearing. You can do two or three times refresh. Now you can see my new list form is been customized with Power Apps. Okay? So like this, you can customize power-ups. The SharePoint new list form with the Power Apps, okay, if you want to do more customization, Let's do that. Go here and remove that attachments because which we don't need it. And city is 0 right here. And if you want, country, dropped on, okay? So let's add that country list here. And the data sources and data conductor. And this kinda from the SharePoint. So you're just creating a connection. And in This SharePoint site, we can get the contrary here. Okay? And here, what will we do ys Foster remove this from the form, this control. Okay, good with the form. Set up the form here and go to the Edit Fields. Let's remove the country here, Primo. And again the country here, that field. Okay, Add. And it is saying that edit text, but we wanted Rob bond breaks. So you will select here a lot of values. We can now do appearance drop-down. You have country. And for this crop don't we need to add a data source means SharePoint list. We helped her to be contiguous straight. Just saying that here. We've got this problem. So year items plus tan lock it. Let's unlock this must. Okay, and come to this drop-down. And here items. It's asking datums. If you see here on the top formula expression here just to give you the countries, Our year I make empty rate. You can see her items. Items you just essay and these countries here in the value, we assign title. Right? Now, if you see the output, you can see these countries coming in via South Korea, Sweden, China, USC, okay. Like this you can do. And also here, there is a little bit off, edit the formula a, some error is there and go to their dorms, maybe in the update. Since we had changed this to drop-down. Here in Data Card Value dot selected a value. It is not allowing us to, let's see, this lake title. Okay, now editable, okay. So like death, you need to do some customization a little bit. Now, we have ratings here. Read lips the deepest, this textbox with input ratings, like stars. Okay? So no, he had set up this and unlock the Change Properties. Select this text box and go to input here and come down and click rating. So rating scheme now and check the name of this textbox data card, W6 civet, coffee, and delete these textbooks now. And for the new control ratings, dish.name, business world, controlling, controlling. And you will get the small error here. Go to the Formula bar. And in the update, we got value of data card value six, gesture. Make it little bit and the top. Change that. Okay? So go to remedies the bit. So when you're replacing the controls, mainly in the data card, they will be property for updation update. So there you need to change all of this. So now here data card value dot six, and let's see what properties are available here. Value is given value, it's flowing. Right? Now I want to move this rating sit down below. So I'll equal to form here. And go to Properties, edit fields, and ratings being done to the country. Okay? I can do like this. And if I go to see the output, you can see here how it changed city, country, and the ratings here, product cost. Okay? Now let's go and see whether we can assign anything to city also. So you already know that city. There is a, another SharePoint list we can add are not required. So this customization is enough for now. So flash to save it. And publish this. And go to the lift new list one, list two banks. And click New here. And you can see the customization from the reps right? Now, just add something. Here. My product name is the, the, the three and product name, iPhone. And product cost is like just dimensioning. This is not the real cost. So I'm mentioning it does extreme those int because city, I will use this as Q, but Dino and the country I can set up it tells us here. And the readings I will give fire ratings since it's iPhone, Wayfair it. So okay, now save it and let's see whether these fields values will be inserted into the SharePoint list, okay, so you know, you can see this, all the values has been inserted into the SharePoint here. Okay? So this is how you can customize this new SharePoint list from using Power Apps. 9. Send emails using PowerApps Connectors: In this class, let's see how to connect to Office 365 connectors. In the previous class, we have seen how to connect to Excel. Okay, now let's see how we can kinda do some office conductors here. Okay, so I'm in my Power Apps here and select the Canvas app from blank. So my app name I'm giving you like office. It's conductors. And the format is tablet. Okay, Create. Now, using these conductors, we can send emails and we can get the, for example, if you want to send an e-mail to your manager, you can also get your manager's email like that. Okay? So first of all, when we create this, we can see here this screen here. Okay? So just click hold. In the previous class we added Excel. So here also click on the left side data, Okay? And add data. If you click at data, you can see the kind of first year. And in the connectors, you can add Office 365 Outlook. If you want to work on the Office Excel Outlook, okay. And if you want to add one more connectors, like Office 365 users you can also use this is Connect, okay? Now let's send an e-mail using this Office 365 Outlook. Okay. So further, I will take three columns, three C, three text boxes, okay? First. So a little bit. Let's do some designing. So let's take one rectangle from the icons, okay? So rectangle years. And let's make it like this. And make it transparent to the beach. Or let's go to custom and add something like this. Okay. Now let's do something. The label here named Tess email. Okay? So increase this font here and make it as plateau black. Okay? So like this, we can loosen, add some hand are kind of thing. Okay, now the label we can have and also we can also have one. Text input will generally, we will have the two field layer. Okay? So like this, we will have for email, we need subject and body rate. So let's add one more level here and name it as subject. Okay, now, now you can add a text box again, text input. And after the subject you will have body, right? Gordy. And you know this whole text. And then the body. Let's add one more texture input and remove the default text and make it as multiline, year mode selected multiline. Okay, so that you can literally drag down and add in a button here and rename it like send email. Send email. Okay, So now this is how it looks. And if you want to add your name or whatever your profile image on the right-hand side, you can also add here. Just take the image, image year and bringing image here like this. And for the image add user. User is a function every level user dot image. Again. Now the login user will come here like this, okay? And if you want to send e-mail to your manager, you can also send that. But first you need to get there your manager email, right? So for that, select this default, textbox. Textbox a property is default. And here let's use Office 365. Users cannot tell here, okay. So now Office 365 use dot manager. We do of IUD is asking the ID so you use the word presently logged in user, aiding user and arch. Here we can use email. Galois, anything is not good money. Okay. Or we can just new here. Department disciplining many things are coming here. Suppose if you do your e-mail and here we're just asking country, department, given name, job title, enemy. If you click mail. If any manager is it for you, the manager will come along. Manager is available. So we need to add the management in the ad to directory. So at present here, my manager is irrelevant. So Let's go to Act 2 directory here in your Office 365 admin. So here you can see as you read correctly. And the agenda today to choose all the people are the use of CF click users and from the user with my name, click here, and then check whether a manager is, a manager is not yet here flips. So edit. Make Manager as one person, change and make them manage it as her mom, select, think, and say, say here. So once you saved me, one personnel manager to you, so you go to here and again, the freshness. Just check whether it's not seem it was saved the application PowerApps application here. And go to, go back. And let's add one more time. This offices to a user's shopping and data come up. That's obvious is actually a user's selected. And you can see that my manager emails coming here. And here the subject, okay, everything is said. And now let's add the code for the e-mail also. Okay, this is how we're going to write for the manager email. And now using obviously, let's send anyone, okay, I'll click the button and then the on-chip write the code. Okay, so now Office 365, how look, Let's see the properties for this year. You can see sandy male version 2, right near exhausting to the 23. Let's knew the dxdy input text and put one dot text. And the subject text. Input to bark texture in the body. Let's do the third one, text, which three are fixed? Okay? When this, you can view all the three parameters here. One is for two subject volume. Okay, now let's check whether check the preview of the screen here. Click this file. Preview the app on the right, safe. And you can see here like this and subject, you can write the subject whatever legal request involving y, I need to leave for one the Jew to OK and click Send Email. If it is showing the something is loading on the top, it means it's sent an email. Okay. Now, the email went to her ish year on, but I cannot shut his email. Okay. So what I will do is I will keep myself in the SCC, okay. So that we'll know whether this email went really to the particular mark. Okay, so I click Send Email here. And he had after this discipline main three parameters. Let's see, Any additional parameters are available for this Office 365, Outlook, Sandy may lucky. I'm clicking, I'm entering here comma and you can see you, we can also see, right? Ccds are additional parameters straight, okay? So fun. To write the additional parameters. We need to open the floor brackets and here in the form of brackets. Let's sic CCSE available. Okay, cc. And here we need to go over email user, user off The human plate. So now the middle comps Control-S. Let's again send them even go to preview and leave request, send an e-mail again. Okay, Let's see whether we got the e-mail or not. Or you go to my Outlook here. Let's see c. Now we got hearing requests to it. Okay. So like this, maybe some lingering questions gone, but some kind of no problem is if the recipient, such as smoking, no problem for this, but the email is implemented here successfully with this Office 365 Outlook connector. And I got my managers see me with the official extra user. Sophie. Thanks for watching this lesson. 10. Open PowerApps in your mobile Phone: How do open Power Apps in our mobile phone? So we need to go to Place towards here. And in the Play Store, Let's type our apps. And once if you have installed Git, open it. And if you're already, if you have an icon, just to open it with your work account, and you will see all the apps. Whatever you have written will be listed out here in the home. All apps. Okay. So if you were doing this for EPS, if you're designing for deform, it is better always to give you the name of the app. And also mentioned with them. As it is. Designing for the phone. Just like if you are designing a new dashboard app. So dashboard that hyphen phone, whether to give it a name, select it, and let me open this dashboard phone app here. Okay. I'm clicking this. And it's opening null. No, you can see the items. And this is the gallery control. And you can see a refresh. So this sorting. Okay? If you want to add a new item, click plus c. Now it's very smooth and very nice. And if you want to click this arrow, click this pencil symbol to edit all this things here. I'm going to return thing here. And again, adding, updating. Okay? No, it's celebrated in the social. Yet like this. This is very nice here to see this bar reps on the mobile phone. Okay? So we're going nobody would or creating any kind of app. Just to mention that along with the name for each device you are creating the cell. Okay. And if I go here, you can see the landing page. Who? We can also know PowerApps, Felder depths of a. If I click click IE, you can always make it as a ferret here. And you can also pin to home. Okay, if you've been issued click Pin to whom, it will be placed in the home screen of your phone. Okay? And here it is showing a neuron when bought EPS release, okay, everything, the details of this. And let me see whether it is in my home screen. It came to my home screen dashboard form directly. We can open this hip from here. Okay. So you can also see here the my account and all these details. Here. We can see the icon and we can also say note here. So no CAK, visit ferret and been shown now it is. The app dashboard is on the top. So we can do many good Apps and Power Apps. Mobile apps, okay, So that and deploy to our claims. Okay. Thank you. 11. Types of Variables in PowerApps: In this lesson, let's explore how both variables in Power Apps. Just like every programming language, there are variables in PowerApps also, we have different types of variables. We have three types of variables in Power Apps. Those are local variables and global variables and collections. Let's explore each one of these variables. First one, local variables. So local variables are subjected to only one screen. So if you declare a local variable in that particular screen, it will, can be useful only in that screen. It cannot be used for all the apps. Reference it anywhere in the app. Okay? But year microsoft has given a provision to use the local variable. In the next screen, I'll say some second screen using the navigation function, okay? We will discuss that in later. And this syntax of this local variable is we need to invoke update context function and that function we need to write variable name and its value. Okay, so if you see here update context, the variable limb is bad name and the value is. But if you want to create more than one, you need to write comma here. And you need to mention again the variable name and its value here where department is a variable name and the value is IT. So when you create this, you can see two variables, local variables with one name, variable name, and it's very deliberate. And second, variable name, variable department with value IT. Okay? This is how we can create local variables. Next, explore the global variables. And unlike local variables, global variables is subjected to app scope. So it can be referenced anywhere in the app. It will hold number, string, the record table. Okay? So we can use, or we can refer to global variable anywhere in the app. Suppose if you have ten screens and the 10 screens, you can use this global variable. Okay? The syntax or function is set off variable limb comma value here for example. And could I am declaring a global variable with the name and the value literally. So if I use name, it can be used in all the pen screens are more than one screen. We can refer this global variable. It's okay. So in the next type of the variable, lease collections, this collection services like same as global variables. The scope is HAP, so we can refer anywhere in the app does collections. These collections holds a table that can be referenced anywhere in the app. Collections that sometimes used to hold the global variables or make a temporary copy of a data source like shave published. Suppose if you have a SharePoint list. So that can be dumped into our PowerApps screen using these collections. Okay, so syntax, our function is like collect. And you need to invoke the function collect with collection name and item. Here in the example I'm showing. Ice cream is name of the collection and the flavor is one column and quantity z1 column. Since the collection, He's hold it table. So table here columns. So here also we are giving the columns names just flavor and quantity. And the flavor. We have a value blackcurrant, and the quantity 40, and again the flavor orange quantity to a 100. So it will create two records here. So this is how we can create, make use of the variables in Power Apps. And let's see how to view these variables and collections in the Power Apps, the Power Apps menu, you can see File Home inset view. So in that if you click View, you can see collections and variables. If you want to see variables, click the variables and you can see all the variables declared in that particular screen or in the rep, okay? You can see here, there are global and local variables differentiated a bin icon. If you click anyone, not that you can see. What are the variables available in that particular screen. Okay? So just like that, we can also watch the collections here. Just click the collections. And you can see that table format. And you can see the column name, age, class student, like this. Okay? In this way, you can create variables in Power Apps. 12. Demo: Local and Global Variables: In this lesson, let's learn explorable variables, local variables, and global variables. Okay? And here, the local variables can use only in the screen. If you want to pass that to other screen, we need to always use Navigate function, okay? To declare a local variable. We will invoke this update context function. Okay, Let's see in the action how it will work. Go to your Power Apps. Create a Canvas app. Demo. The roots demo. We can also pass some dynamic values to the next screen. Okay? Appear and naming the screen, screen one. Screen one. Okay? So here I declare some variables, local variables, okay? So further, we can use any control here. Suppose if you are taking text input, we can write on change. And if you're taking, but we can write on select. Okay, So this button load my local variables. And on writing update context. This is one function which will help us in writing this local variables. And now we need to buy the context. This is just declaring local variables. Any contexts to be. We work in with this curly basis. And the curly braces you can write where BMP name, okay? And he can send a string. Okay? Next, if you want to read one more, you can keep comma here. Olivine sand as shown here, the AMPA, ABC. And if you want to pass a number, BMP, age satellite connected to one pastor number. This is how we can declare the local variables. And you haven't, you seen here string, string, string, right? So let's load this value is first, okay? So This is, so I'm writing here commenting there might be multiple variables. Declaration. The declaration. So we are working on this 100 contexts, open curly braces. And here I am writing EMP. Armed. Men, say some aims, the company, this company. Okay? So now this is single variable declaration here, multiple variables dictation. We need to fast loan this, okay, go to preview. And local variables first, the red income. Check whether it's the variable set loaded or March. To check the variables does not need to go to View here on the top and good wearables. And you can see on this local variable, it's okay. And this local variable, a local variable, it will show that this local variable is from the screen one. But I'm on. And they select property like this. You can check the variables. These variables are coming. You can see this variable name is a number. It can hold a number, it can hold the texts, texts takes, and we can also hold. A record also inevitably, let's see how we can do that. We have a function, say, use this new user. We need to do semicolon and you use them. But the main fullName image, this is one kind of function where we get the trivial who's currently logged in user email is fullname and his image. Okay, let's store these three values in one vehicle utilization. So declared here, update context. Curly braces. Current user. Now we will assign this user function here. And let's go to Preview here. Let's lowly alien. Now, both variables here and the view. You can see that current users, if you click this C here, this is a record. This is number of employee edges, number, this is required so nobody can know that our local variable can hold the record, a number, a text, say it is a string. Okay, so now let's go and see this clip, this record here. And David Record icon is edited quickly here you can see whatever the columns it is holding email fullName, image. Okay. So now we came to know that how could declare the variables. Now, if you want to use these variables in the next screen, Let's see whether we can use this much. Go to Home and create one more screen here. And this is my screen too. So in the screen too, I will keep some labels. Labels. And at the level I want to do the employee name. Here. If I call that variable, It's not showing anything. See young people. It's not showing up when it is not shown because it's a local variable and it can be only use it from the screen one molar if you want to. Use a variable for the second screen, you always need to use a workaround. So let's see what is it, what Karen ellipses, same here. Let's hit a year. Amp name, variant, very, very MPH, SME and the names for these labels. And see what the comments that we will look at diversity because it's not and available so pH when this t Now we can see errors because it is not recognizing this local variable layer and the second screen. So now let's see how big it can replicate. Nice, Okay, button here. The main focus screen to the workaround here is if you select this pattern, there is a function, the main navigation. So it will take as few parameters, say target or target-based screen to screen two, comma is asking for any transition. We don't need any trends or some happy. Now this is a key 0.1 comma contexts. So seizure context, it is accepting the variables here. Let's see how to pass the variables here, okay, But context, we already know that we need to open the cabinet restless and get right one by one variable. You can use this. Or we can, you can write this year, been copied from all the concrete. See here like this. Okay. We're modules. Now we're passing these three local variables, variable name narrowly and the MPH students might scream, okay, go to Preview. On, go to screen to screen two. And we go there, you see typical ABC employee ID, employee name. So this is how we can make use of the local variables from the screen one to the screen to okay, if you go to the screen to, and we can observe here, there is no errors because now they're recognizing the variables, local variables. Okay? So we can do this local variables. And also you can send, okay, So you can send a local variables from one screen to other stream using navigate here. Okay? And one more thing I want to say like a lot of variables can hold numbers, strings, and lots of records here. Okay? Let's take the left signal, the global variables. Okay? So now generally global variables are declared on the top of every programming. So here the starting point of app is up here. And you can see on starch. So let's declare the global variables here. Global variable, global relevance, severe global variables will be declared. Well, if we check. So what global variable will be declared in ads on Shark property since this is a starting point or the app. And we can set the value of any global variable. We set this function, we need to invoke set function. Okay? So let's see how we can learn know sich. And it's asking the variable name, mine. I'll say something like my company. Okay? And the value get you the value of your company name. The VC. We can do like x-ray, j-th component. Like this. We can, we can search and we can write so many. This set, my cost, price, cost praise the word numbers, something like this member, No. Okay. Here we can also set the table also, but we already shown you a current user or we can set U. So now let's use these global variables and how we can use this. Okay, so first, we need to load this global variables in onStart. If you click run on stack, then only these global variables will be set. Click run on start here. And go to the View variables here. And you can see that global variables on the top. We can see the cost price, my company, XYZ. Okay? These are global variables are already know. And we can use those in any NANDA strings. And the screen when we can use go to and second level shared some labels here. And S and labels with global variables. Here. What is a global variable? Name? My company. Right now you will then the very next widget company. And what is other global variable cost? Price? Cinema. You can use this and also you can also use this on the screen to go to Labels, screen to and click to. Labeled sensing is the screen 2. And here you can see my company is a global variable. No. It's recognizing model global variables, okay. Like this, you can declare the global variables in the app. And you can use these global variables in multiple screens. Screen one screen to screen DRI, like the pin multiple screens, you can make use of this global variables. Okay? So if you are doing this, developing this app, you first define what are the things. You will use this in all our screens so that you can make them as global variables. Okay? This is how these, that there are three types of variables. We have seen no global variables and local variables. In the next lesson, we will see what the third variable, which is known as collections. 13. Demo: Collections: Collections and it's demo. We already know that collection is a part of variables types. Okay? So just click how the variables hold some values. Here. Collections also hold the table, okay? Just like global variables, we can use it anywhere in our app. Okay, so here, Let's see how we use these collections. We can create a collection by invoking collect function in Power Apps. Okay, so and also we can visualize this collection by assigning to a data table or gallery. Since when we use this collect function, it will create a table with the records. So this table can be assigned to a data Gallery. This data table and guilty, okay? And also we can put a SharePoint list into a collection. This is good feature here. And we can also reshape the data. Okay, So suppose using some functions like add columns, rename columns, we can do that. And here, there is a limit for this collection. Suppose if you are copying some items from SharePoint list or collection, it can add only up to 500 eight amps. So if you want to overcome this, we need to increase the limit in the settings of the app, okay? And you can see here the syntax, okay? So actually collections will create it. Temporary space for the holding of the data. Okay, so here the syntax is collect and we can, we'll give collection name and their records and the curly braces. Okay? So if you want to clear this collection and add a new record, you can use clear collect. And if you want to completely remove the collection data, you can use clear. And if you want to copy or dump SharePoint lift, turn the collection you can write collect off and the collection name and the SharePoint list here. And also, as I told you before, we can reshape the collection. Suppose you take this example, mobile sales. You will display all the information as it table. And you want to add a column which will have name as revenue and which will give you the calculated value like crazy into quantity sold. So we can reshape a collection using the add columns. Let's see all listings, okay, now, and go to the Power Apps. And the Power Apps. Click Create. So set up the Canvas app from blank and name it because collections demo. Okay, format, I'm selecting tablet create. So it's taking some time to load the studio. So now we've got this, skip it here and flushed. Let's add a button on our canvas so that we can load the collection. Okay, in such and click button. I'm literally doing this. The button load collection. Okay? So in this and select this button, the create the collection. Okay, so we're clear, creating good Corruption. Now invoke the function collect. We got this collective and it is answering the collection name comma item. Okay. Now, the collection names, so lets me add my collection name as employee EMP details. Okay. This is my collection name and comma we can write record us to collect. So I need to write a record or an item. Super write that record array. We need to first uses curly braces here like this. Okay? Mounting the study visits and define since 1850 do returns. The table. We will have columns light. So let's define our column name here. So for employees generally knew them employee name and name it does, but a T it. Okay. And next the next column here. So employee, the age, the Phi. We can write like this, another column and EMP skills. The skills I can you share point. Okay. So now this will create a collection with the name VNP details and with the columns EMP name and the MPH and EMP skills. Okay, first let's see this, how it will work. Let's load this collection now. Click preview here, and click this load collection, click it. And to check this collection is created or not. We need to go to view on the middle. And then the view we can see there is an option view collections. Click it. And now you can see collections here. It is created with the name EMP details, GMP, GMP name EMP skills, employee skills. Okay. So like that, we can create these collections here. And now let's add multiple data. So common and they gain weight. Another recording here, this is having a single record. Now let's add one more record for this collection. Copy this, and change the names here. And if you want to write one mole of B, we can write Ws at a screen like this. You can add more columns here. Okay, Now let's load this collection once again. Good to preview here. And click load. And come here and go to the minimum of your hand, come through collections and you can see again the data case, the data edit, Krishna and all the stat edit. Note there are three records here. Okay. With the column names, the employee name skills and employee age? No. So what shall we do now is like so now let's check how Bu, clear this. So if you want to clear discipline collection, you can add here not. So we will see the clear leader first, we will check how to visualize this in our Canvas app. How do we visualize this collection here? Further, I can add data table. I can add Gallery on the right side. If you see Gallery I can add or I can add data table. Let's add question data table here. Blog can offset. So now let's bring it down. Let me which label visualize collection. Okay. There's this, no. Now let's same celebrated as the Deterding is asking to assign a data source. So here the data source, that will be our collection. What is our collection? It's EMP details. Okay, let's assign to each edit fields. You can add 15 and we are same. Now, let's add in here. I can add ENV name, knowledge. And we can see if one by one it's forming here. I'd feel EMP skills, skills came now and add fields, the MPH. See now you can see here all the data which is there in the collection is visualized here. Okay, so now let's add few more records here. So copy these records. Had fewer records here. Moving on. Let's do one more column. One more, Sorry, one more record. Known. Go to preview and load collection with the new records. And now you can see all this data collection, okay? This is how we can visualize the collection data with data table. Suppose if you want to add gallery, you can also add it. Visually. It's collection data with data that will, this is the one data table. And if you want to check, if you want to add a gallery to each, you can also add gallery, no spread of data or visualize the collection data here. Okay. So I'm building this Data Day we leave. Let's, okay, let's preview once again this one. And this is how we can visualize the data collection data with the data table here. Okay, so now let's see how we can visualize our data with the gallery. Deleting this delegate AB bar, and we can keep aside like this. Now let's visualize the data with D. Yeah. Okay. Gallery control. Okay, let's let's add galleries from the right side. We can add a blank vertical, or we can add a vertical layer. I just want to add blank vertical here first into our canvas up. No, it's Kim here. Just know that Liberty a dome. And now let's add a data source for this gallery. Okay, None and add seem collection to this gallery control. And it will leave these blank know that suites not showing any data. So now here we can add yet layout is 0 right here we can add blank, hand, title, subtitle, title, subtitle and body. Okay, then if we add these things, so all listing column values will come here. No. See now, you can see, right, you can see the data right now here. Well, let's make it small. And let's preview each. Once. You see now this video logger, these collection data with the Gallery control, okay. So the left side one is from the data table. Okay? So now what we're going to do is we will clear this complete collection and like to add a new collection. Okay, further, we will take a new button here and name it has the year, collection and new. Okay, so so for that, what I will do is like I will take some blue, some dynamic data here, functionality here. Okay? So now we have hard-coded the data, the column values right here. This is hard coding of the data. All the sea and binning skills ate everything. Now let's get some dynamic values only on here so far that I will add texting. Texting, one more text input, one more texture input here. Okay, So what I will do is give a label on. So here's that BMP name. Bmp name here. Okay. You can add skills. One more label years. The MPH. Okay, the MPH, known, know what we will lose by saying the load collection. X86 known in the load collection. Let's add this denmark various funded money to add these many records here. And just TJ Moody's records. And in the EMP name here, the hard-coded value displays the name of the text box. Dx2. Put one dot txt because of textbox name is dx dt input one. Okay. But the way we learned this year, mph. But the employee, the employee skills, text input to the next word. Two dot text here. Okay? So and for the EMP age text, we put three dot txt. Okay? Now this is Vb add data to the production dynamical Lima. Okay? So for that, what we shall do is if we add now, it will create a new data to the collection. Let's see whether it will lead out not. Let's add name as John. Here. Emp skills is sick. Will MSC, an employee age, compete for load collection now? And you can see here we got MSC query and John. And now let's go to the add their employment momenta. And you something like we can say like Azure. And employing that the age, by age 30 and add collection had distributed with the collection. And we can see, we can add the collection. Okay, now, I want to create a new collection by clearing all this content and one bird new data. Okay, So now I will go here and every new names here and the ones if I added to it, Here's the wall delta and add some new data. So let's see how to clear the data and the new data collection mode. Okay, so I'm writing the new names here. Now. Let's add dotnet. Don't clean the collection and adding this new data here. Okay? So it's not working because we have not given this. Okay? So here, I think we forgot to add the color to this one. That's the same thing. We actually do. Add the collection function would PUT collection, create a new collection. Dumb. Clearly, clearing question, clear. First we need to clear the collection. And new collection item. Collapsing item on record. Okay, now collect, collect. More, clear. Collect. Collect. Okay. Let's go and see. Go to preview. And now I'm adding this new name and it would hamper EMP skills.net and employers to defend. It. Will I click this gear collection and add new data. It will clear all this. John and Samantha. Woulda time declared en route and dotnet 25 C to see new data came here. Okay? Like this, it will work this clear, collect, remove the data records from the collection and add these. Okay? So this is all peer collaborative work. And you can, if you want to completely clear this data, you can add one more button here. Neither one more button here. And Mimecast, clear. Call to action. Okay, so now let's go to the preview. We will end this here. We need to invoke clear clear off. It is asked in the collection name. So what does the collection name? Emp details. There's our collection. Now let's save this fast. We actually got pursue this app and let's see, No. So it's saving know. And let's go back here to this. And let's check here the preview. And now you can see if I click this clear collection, it will clear all the data. See it, It's good. All the data here. There is no data in the collection. If you want to see. You can also go to the menu here and click View and go to collections. And you can see empty data is to empty the collection, we need to use clear function. Okay? So this is how some things which will work with collections. And suppose if you want to know the count of the items in the collection, we can add a label, the earth in such Some functions also work with the collections like this. See, bring this here. And if you want to see the count of the collection. So in this text right here, Kong. And comparing the items column, we can take like items count. In this column, we can do count of source. Source means a column of values to count. So here we can do employee details. And let's single column right here, comma. We can write EMP named Hirsh. Okay? So like this, Let's check how it will come on. Go to Preview. So I'm loading this data here, but nothing is coming here. Items won't. Let me add a page that page. Load collection collection would get items from this not coming. Let's take what is the problem here? And let's see the problem. What, whether we can use this same cone of employee details on, we need to add one more cone. Any other function is available to count the rows. Cone rules, okay? So controls of source, I can do employee details here. And now we will get the rules. Can see here items, rows, columns, and rows count, like it's a record, count items. Okay? So if I add one more here and see ETL and age 32. And they can see here, you can see your item count three genome. So with some of the things we can create, collections, collections, and our new data, clear connection. And we check how we added this. We can also count the number of records in a collection. Okay, now, let's see something about reshaping the data. Since this collection will reopen the output of the data as a table, we can also use some functions to reshape this data here. So let's see how to do that. For that, what we need to do is take, I will take here hard-coded value. So, so I'm removing these things here. These things, leading these things. And now it's in the load collection. I will hard-code a table name here. So in the pour point we have seen, we got the example here, clear. These things, right? Take this, come to this here and here. Okay, so know the name of the collection name is mobile sales. This MOOC or optimized. Okay. Let's add something here. There is some double-quotes of her coping. Okay, so let's sell this. And here I'm clicking, I'm creating a collection with the table name, with the payable and the column names as brand, price and quantity sold here. Okay, let's take this first, go to preview and create this collection flush. I'm loading this collection here. I click Load. Nothing is coming now. Let's see what happened here. Okay, So we are giving a new name for the collection. So okay, anyways, first, let's delete all these buttons. And we're loaded this new collections. Mobile C. Go to the View and check his mobile sale. We got the data right. We need to assign this collection for this data table. Now, mobile sales data and edit fields. You can add fields, brand, flavor, brand, flavor, brand we can add. We need to check ones. Is there any brand, brand and brand Olin? Same names must be in the columns here. Okay, so let's clear this one. And load collections and go to the View and will be the collections and see here, Brand, okay, price, all these things easier. Okay, so we are limited. We need to add exactly who the unit plays. 16000 quantity sold 35, Okay, Quantity, everything is their collections. Go to check here. Quantity unit. It came on. Okay, Let's indeed this rose, name it as place only. So no, let's do one more time load collection. Actually, we need to give all the column names as saying, OK, and you'll get another group, the collections. We got the, the, created this collection small hand. Let's assign this collection to the data table leash. Mobile sales. He plays columns and add a column one by one brand phrase, unknown, quantity sold. Okay, Now we got this data here. Let's remove this gallery control. It's not requiring. Now, for visualizing gesture, you will use this data table. Items count. We will get this items count by mobile since items pulled bones are not necessarily in yellow. Let me delete this. So low. I loaded a new collection with new data here. Here what all the mobiles, Apple, Nokia, Samsung. No, I will reshape this collection by adding, add columns, rename columns. And what I'm doing is I'm reshaping our restructuring the table in the collection here. So for that, let's go here and create new collection. Okay? So control C. And then call me this new collection. And then writing, I am taking the New button here. Load. The ship would call auction. In this code, I'm writing the clear collect mobiles, calculated columns, mobile sales, and I'm adding a new place. So let's check here. And we're going to visualize the data with the new data. New data table, visualize collection data with data table, great. We will concurrency as saying a new data table of the relationship That's shaping. Somehow add one more data. They will, and make it as mobiles collect calculator here. When we agreed on here. Let's go preview each and load, reshape, reshape the columns. You can see. Okay, no problem. This is not required. He's already you will see a load reshape2 column. And here we need to add a, what is the name of this mobile sales rate? And let's see mobile sales revenue, price and quantity sold. Okay. Let's click on load reshape2 collection and go here in the view. And the collections go here and you can see new collection has created with mobile scale cluttered. And you can also see Brand, bill place a quantity. All these things have created now, okay, like this, we can reshape. We can add one more column, extra column here without disturbing that table. Here we are not disturbing, disturbed any kind of table data here. The same table will be there and we just added a new column with the calculated revenue year. Like we can use the C, this add columns here. This is completely a vote collections. And the next lesson we will explore more topics on the PowerApps. Thanks for watching. 14. Design a powerapps gallery: In this lesson, let alone how to design a gallery in Power Apps. So we know that there is a gallery control in PowerApps. So it is used to populate data from many data sources such as Excel or SharePoint. Okay, here I am taking SharePoint as datasets. So here I created a SharePoint list with some data here. And it is having columns like title, cost, brand status, and country. Which status is a special column? Hi is column here. Okay, so that's our single line of text. So let's populate this and let's see how we can design gallery. So go to your Power Apps and go to tablet layout here while creating. So no, skip it and add some type of Minow. And footer here, go to Insert, and here in the icons, select the rectangle here. So you can see the rectangle here. Change the color. And the base. One more rectangle, keep it in the bottom. Okay, now, add one more, like home or some kind of mineral icons here. More like this. You can add icon and hamburger menu icon you can keep here like this. And one more icon in the bottom, we can add like contact as like that. Okay. Let's add something like made. Okay. So now let's say I have a text label. It's like something like a copyright symbol. We can also add a she'd go and check here. Any website, corporate symbol, you will get this one right. Circular one. Copy. Abc Company Limited. Okay, Let's preview it like this. We can see here. Okay. No lips AD gallery here. Let's add to the screen Meno and gallery here. You can add horizontal. Everytime we will use Vertical rate. This time we will use horizontal here, okay? Horizontal. Yes. Okay, Before that, we need to add data source, right? So for this, let's add our data sources. Sharepoint. Get is SharePoint, SharePoint. In the SharePoint we need to add mobiles, mobiles SharePoint lists. So here on the right side, add mobiles. So once you connect with that mobile SharePoint list and the gallery, you connect with that in the data source, you select Create mobiles. And the thing is here, the layout is blank. That's where no data is coming. So you can add a title and subtitle title and subtitle on overlay. Okay. So nothing is coming, no. So keep like this, drag it like this, and go to Edit Fields and you can see nothing here. Okay? So try to add. Had an item from the insert, contrary to add some labels here and see whether data is coming or not. Into these gallery. I'm adding iPhone came. It came. If you want more cost game. You can see here a brand. You can see verified, it is very fair, dot-dot-dot. You can see from which country it is there. Okay? So like this you can, you're getting all the data. So now we say m time. You can see all the data here. So I can also hear, use like we can, we have here what we can do like this, to do like this, it becomes a little bit dragging. We can drag here. You can play whatever we like this. I can create one here, iPhone. So since it is non like iPhone, see we can add an icon here. And it will, whatever icon you add in the first one, it will be like it will be generating all other columns here. Can shifting over. Now. I'm adding this year, 100 is added to. All right. I'm keeping this earlier. This is iPhone. And I've already mentioned this, says this is my form. We can keep like this little bit. And let's call those end the brand we can keep here. And we can make it 19 know at present here. And the progress, it's very phage status can be given here. And this Apple USA you can keep like this year. Okay? Now, we can do like this first one. And if you want, we can add here bold. The size of the font or the font size is normal or bold or semi bold. Something like that. You can make it more resistant. And here normal verified. You can, let us say, okay, like this, you can be something like this. You can also change this verified and keep here so that it will look. Now you can see preview gallery is there. Okay? Now, what we do is since cities for hole, go to the preview and gallery in the Gary label. This is a one. So we need a border for each and every item, right? So for that, go to icons here. Go to icons and add one rectangle here. Can I like this one? Make it transparent, transparent levels? And so you can do your transplant. Transparency. Transparency like this. We can see like this. All the denser coming. 15. Search, Filter and Lookup: In this lesson of Power Apps, Let's see what filtered search lookup and also sort. Okay, so this is very important concept in Power Apps. And generally when we have the requirements, we will filter gallery or we can search in our gallery, walk. So all these things we will do in the actual data retrieval from some kind of gallery or data table, Right? Okay, So here let say checkerboard the filter first. So we can apply this filter on gallery or Decker table. So to invoke this, we need to use filter function. And this can be applied on the Items property of the gallery or data table. So, and also the syntax is filter of especially to last for a data source, maybe it will be a collection or a SharePoint list, or an Excel file. Okay? So next, we can use the field name and the field name to Suppose you can see the example here. Here the filter we are applying on the mobiles SharePoint list and we are showing the content, the grid then vitals. And so it will show all the mobiles which are more than 5 thousand. Okay, So in the gallery or the data table. So the other example, we can apply this on some kind of deaths date formats of good columns. I have a date column in the SharePoint list, which is known as publishing date. And here I'm giving the formula. So it will display the large to 10 days records. We have a date AD, and good. A minus ten. It will view the last 10 minutes. Okay, No, Let's see a demo on the filters. Let's go to our Canvas app and select that canvas tablet. Here, click Create. So Power Apps, it's loading up now. So generally when we are creating portraits, it will take some time to load up. Here. Select a background Claude screen. So no legs, and then SharePoint list. So I have SharePoint list with the name student registration with columns, student name, class, fees, group, section. Here, group and section or choice fields, sick in the leash settings, mortar exactly the column types for this list. Here, the title is single line of text in class, singling, rotation group and fiction or choice fields, feces number. Student name is also single line of text. So with these kind of columns in the list should enrich tuition. Let's create filtering. So now let's go and the SharePoint. So at the SharePoint connector. And it will ask us from which SharePoint site we need to take the data. So there is a SharePoint lessons. And from a SharePoint lessons site, just select student registration list. And now we need to assign these data to a data table. More gallery. So a year I'm choose Data Table. And now I'm assigning this data source student list to this data table. So you can see now the all the data rendered into the data table in the Power Apps. So let's say according to the design, this data table. And now let's apply some design. So I'm applying some design here. Little bit of a hint for this disorder, not required, but to look at the screen in a nice manner so we can view here. So now let's add the label on the top and we can view the heading header as filters. Okay? So now the main of these screenings to filtered items. Okay? So let's see how this filter function will work here. So I want to show the mobiles, sorry, the student name here we are given. So I want to show that she's paid whether student which is maybe greater than totals and get funded, I will make a filtered here now. So to filter it, we can apply these filters on the data table. Items property. If you check with the silicon, the data table, on the top left, you can see items. So in items, we can write this filters. So let's invoke this filters. The filter syntax is it will accept the data source first. Okay. Let's see. Let's write filter and the sources SharePoint list. Right? You are logical test condition fees than 2000. So it will show all the items in the data table with the column fields E value is greater than 2000. Sima. Let's take a preview and you can see all these items. Fees are greater than 2000. In this way, we can use the filters in for rats. Okay? So now we can add more than one condition here. Logical condition. We have written t is greater than total. And we can apply this condition to other column. Also here I'm giving a section. And since section is a choice field, we can write section dot value equal to B. Okay? So now section is a choice fields so we can, we need to write section Live. We have written but it's showing some middle because if the choice will be needed to Rate section dot value. Okay, so let's add that value here. And let's go and check the preview. You can see all the sections that z is greater than 2000 analogs. Deception is D. So we can play multiple conditions, logical conditions with from the columns and use with this filter. Okay? So now this is all aboard the filtering condition, which we can do it by invoking light. So we have already had two columns. One is fees and other hominids section. Okay? So now let's this filter is having a source and some conditions here. So we must remember that always in us it will show the syntax on the top. Okay. So now let's see the other topic such okay? So the search actually also filters the data. So this, this will work with a single text in one or more columns. The single text for the single text to you, a textbox generally. Or you can view where you can hard code in this function such. So this searches also, we need a DataSource and a search string. The substring we can get from the text box in the Power Apps form. And next we can do the fields field, one field. For example, we can such a mobiles. And the text box text sets the title of the mobiles. And more than, more than one field, we can do the columns in the double-quotes. And also the search function is easier to read and write. Then filter if you want to specify multiple columns and multiple in operators, it was 10. Close the names of the columns in double quotation marks. So if anybody asks you, which is easier, we can always tell such function is easier. According to Microsoft. Okay, so now we need to always remember that our text, such is the textbooks where the substring we will get. Okay, Now let's we have seen the example here. So, and also for the one tilde and more than one field. Okay? So all this must be in double quotation marks. The columns, especially with which we are searching. Know, Let's see the demo. So now let's go and check. We will apply this on the student registration SharePoint list, like what we have done before. So we can make use of this SharePoint list. And let's go to Edit here. For this search, Let's add one text box. Let's add R1 textbooks here. So bring that text box on the top left corner of the data table through some properties for the textbooks and in the Hindu texts relate search. So there's a show in Spain in the textbooks. Use of this data table, which the source data sources student registration lists. You can see here. Right? Search and it's asking good data source. So in the source we will do this. So we need to do the text here. So what is a textbox name? Text input 1 dot text or whatever we want, we can write here the name of the textboxes compulsory year. This will act like a search string and comma the column names so far, which the column name you want for students. Like one off. For now, we can have for the student name. And you can see it's returning a table format. Okay, now let's check something in the text search. And I type my name here, VA be beaming. See you were to valid increase. Like this. The such is working fine now. So working mice with all Lee. So this is how the such real-world. Okay? So we can also write one more column. So then the string will searching both the columns. If you want to write. You can also do that. But the search name, Writing Young and means available in all the things here is checking this amazing available in the student name and the pedal and it knew as one entry. So now let's go and see the other filtering oxygen. Such No, I'm commenting this. Let's say the lookup table or gallery here. So this lookup function finds the fossil record in the table that satisfies the formula. It will you only record one record. So the single record we can see for the if suppose that matches one or more criteria, the criteria, if it matches, it will do the single record here. So you can always see the example. Lookup off ice cream is the data source name and column name clever, which is equal to vanilla rich so that it will show the data where the column name, column value equal to one ILA. Okay? So such as for a recorded flavor equal to any land of which there is one, since there is no reduction formula sulfur then record desert region, soviet lookup, the entire record, single record will be written. We can make use of It's a local variable and we can get this lookup value as a record, saying this record to a variable from the variable, if you write in Dart it renew the particular column value. So we can make use of touch. So here you can see here we are writing and lookup equal to so it will return only one record. We got one record here, right? Instead of the hard-coded value. We can also use dropdowns that help us in filtering of the data with the lookup. But we will deploy a single value. This is all as filters, search and look up. This is very important while doing the projects. 16. Demo: Multiple Filters: In this lesson, let's see how we can combine filter and search. We learn about filter and search in the previous lesson and the demos. And now let's see how we can combine both of these, filter and search. Okay, so first, we need to write invoke such function. And in the search we will do data source and that search there are extra text-box with the column name of rate. We already know that. So here the trick is introduced, this data source, okay? We need to do the Philadelphia now, okay, so we need to filter that data source, whatever, whatever, whatever dropdown controls VM. And do that filter function in the place of this data source, discrete listed, and combine these two. And you will get this formula as such, filter and mobiles, drop-down and carma, such text column name. Okay, Let's see These. Hope it will work for us. Okay? So in this lesson we will take one drop gun control and assigned to our choice fields in the SharePoint list. Okay, so for that, let's go to the Power Apps. So here now you can see the previously, we have used a search box here. Now we will input one drop-down. Ethane, this drop-down with the choice column. So in my SharePoint list, I already told you I have a choice columns here, group and section. So this group will be assigned to this choice column here. So this is my dropdown and I'm assigning now the price column from this drop-down. Choices. Since it's a complex field, we need to rate choices of column name. So column limb will come from the student registration group. Okay? So now you can see all the groups in this drop-down. Rich. Okay? Now, let's go to this such a here. And go to the Data Table. Select the items. And let's trade the formula here. Complete formula, combined, search and filter. Okay, So no, we need to read carefully here. First day will rape search. And here the data sources to rent Appreciation, Whereas in the text column is texting, put one dot text. Here. I'm giving the student name as my column name to such. Okay, Now it's done. This is no. Let's replace this with the filter function now. Okay? So first-rate difficult or function how you'll rate here the filter function. So let's keep in comments. Matched filter. Filter will ask us to the source name Student Association. It is, we'll ask group, group dark value because group is a choice fields. So we need to ViewGroup dot value equal to grow Dong. One got selected dot value. Okay, So now replace filter. This one is z array. This formula replace the student registration here. Okay? Now copy this cut. We can cut this one. I'm adding here today and crushed format text in the place of student registration, a matting this one. Okay. Now, you can see here the full-time student registration and silica, the value or the scenes we have written. And let's go and see here how it is going to work. And now you can see if a senior by UC. And getting all this filtering. Okay? And if you buy a PC and a phi one to search with the name Krishna. So it is searching with the boats. Okay. I'm also can such No. It is sticking with all of this. Now. These two are working now. And let me add one more. Drop down with the section, okay? And let's see how it will work with all these three filters, okay? Now you can see I have added this filtering in this such as fatty combined. So now it's working fine. And let's make it little bit more complex by adding one more filter condition here. Okay? So here the notch filter condition is, I can take here one more filter condition by, but before we need to add one drop down, great. So let me drop them first. So he, I will add a drug on with the section here. Okay, So go to my input sheer drop bone and bring it and assign the section column for this. So this is a drop-down with the name from don't do and the logged on buoys having the properties items here. Here. Now I'm assigning one choice, field, choices of student registration comma section, okay? Since it is a choice fill, so it will sink nicely with this drop down. Okay, so now you can see we got three rings vary to work here. Now let's add this formula. And the formula also go to the data table. And the items. We have added Group dot value dropped on one cell to the value. And like this, we will add one more year section, known section. And section is a choice field. So we need to write dark value here. Equal to grow down, drop down To got seller value. Now let's see how it will work. Here. In the filter, we have given two columns, two such, and we aggregate drop down here. And let's see. Now in the MPC, we put VA section here because I sell affiliate here in the babies and nothing is here. And Michelle center to here. If I set up to be here and they sell up to here by PC, you can see these three things. Now. These two are sinking and on by PCB. And you can see this working fine if I sell apps. And you can see here could be blood coming. Now these three things are working fine. Okay? But the thing here is, if I open my app here, what's happening is suppose I will save the surplus. Okay? Let me see. We said with the name combine filters. Okay, let me save this, and it's saving know. What is the main problem here is even if my drop-downs are empty, then I need to show all the data. No. Okay, But here What's happening here is if you see, I will close this. Okay, if I open this freshly here Apps and you can see here our drop-downs or populating with some values. But I want this drop bombs should be populated with nothing like EMT must come here. I want to show all the data in the data table when all these drop-downs are empty? No. Okay, So how to achieve that? So far that what we can do is let's go to our app now. And there is an option in drop-downs, pokey to keep them as empty. Okay, so let's work on that. A little bit of code we need to write good fit that. Okay, so let's see how it will work now. When this one, Let's skip it here. And here. Centered live. Dragan first served him drop down here and go to the properties. And you can see here in this election faults, okay, So make it truly Hello In decent option. And let's go and see if it comes. Nothing is coming here. Hello. Hello. And legs from this also, we can do a low-end be selection range. Let's go to the property and see default is running lump-sum. Do this. You also remove this one. And now you can see here everything is coming in NP, but we cannot see here the data, okay? Now, initially when there is no selection of the strong bones, we need to see all the data, but we are not seeing here. And how do I choose this one? Okay, for this, we need to literally reach right? Week called R, whatever you see. What do the data table here? And let's come here and we can write here. The simple thing, something like this is blank. To check whether these MB or whatever here, vSim and round on. Bob sell up to the value. And we can write here or so like this. If we write the same thing we can read here. Sometimes it will show or we can write here, blank, blank. We often, why we way of writing this scene here means like if it is blank, the ground bonded silicon, well-reasoned, blank. If it is false, it will show all the vendors. If it is false here, show all the values here. Okay, now let's save this. And let's see how it will work. See now, you can see all the items now. So here you can see all the items for right? Now, what's happening is this is just a little logic here that's on. Here. It's the drop-down selector value is empty, is blank. So what I'm doing, R, it means R. This is, if it is, blank, means this conditional. So we'll apply here then groupies, the group value is we need to assign all the values here. So like this, okay? Student registration will take this as a condition like that, okay? It will apply if it is blank and Rob number of silicon value. If it is empty, value, show the values. Okay, Like that, okay, if it is empty. So now let's go to the year, the filtering. And now here, such with something here, fast searching when birds here it is working now. Okay? If I select here and BC by EPC is rate 1, 2, 3, 4, 5 items are differ by a PC. If I select this one group, it will show five items, which is showing favoritism. So 1, 2, 3, 4, 5 hurricanes. And in this way b, c phase selected B. I see only one to three atoms here. Okay? I can see three items here. Okay? This is how you can do multiple rings. In the Power Apps. I'm just showing again the formula here. What I have written this one. You can also try like this and HUD come combination of such filter. 17. Patch and its uses: In this lesson, let's see what is patch function. That function is used to modify an existing record or creates a new record. Generally, we will use submit form to create a new record and update in the SharePoint list. Okay, so here without using the Submit Form Peking are used fetch some vents or requirements may be so complex so that we need to use this fetch function. And here the patch function generally used to create or modify. And also it majestic records outside of data source. Suppose if you have five fields in a form and there is a, another field outside of that. And you want to patch both, which are inside of the form and the form. So you can do it with the PECC. Here. At using pets, you can only record at a time, a single record. So if you want to do it more multiple records, we can use for all function here. Okay, So now here, dispatch function. To create a new record, we need to use defaults function here. And the defaults function is to create a base record with the default values here. Okay? And this patch function is works very well with the power-ups in the screen. So I can really easily recognize the columns available in the SharePoint list. So in this example, the demo, we will make use of a SharePoint list along with Canvas app. Okay, No, go and create a Canvas app. So it's loading now. Now, let's skip it. And the first thing you need to do is go to SharePoint and check, create if any lift is available for dispatch. So now I already created the list with the name main tasks year. So in the main tasks that IT will be the task name and the due date will be that due date here, column, date column. And the status column will be the choice fun. Okay? So we can see here the dihedral due-date status assigned. So now let's go to the lift settings and see what type of columns we have created in the SharePoint. So if you scroll down a little bit, you can see all the columns we have created in this list. Title is by default it to become and it will be the name of the task name. So he Stratasys that choice field and in that you have some choices. Improve this nor started and completed. Okay, now let's go back and come to Power Apps. Now let's add these lift to our Power Apps application. So good to add the SharePoint connector here. And when you set up the shift point, it will ask us to select the SharePoint site here, or SharePoint site is SharePoint lessons. In that SharePoint lessons, if you select, you can see the might ask slashed selected my task list. Once you select this. And the sludge will be connected with this Power Apps application. Let's get all the data in SharePoint lessons, site and my task list. And now refresh again this. Okay? And now let's create the fields one by one. So I'm not using here an edit form or something like that. I'm just taking the individual controls and I'm Bill patch this into the SharePoint published. Now let's take a label here and name it as. Before that let's add a beautiful background for this screen. Let's such a beautiful school background of students related thing here. We already seen some very Year loading up self-discipline. Okay, now, let's see the cool background for this screen. Let's start dragging one by one labels and text boxes. So now let's, let's add a header for the screen by selecting the rectangle. From the icons. Or extend this little up and now go to the home when you can set up green color theme. And it turns to green because green color theme. And now let's add one-by-one conclude here. Okay, So we can write this X, don this header. So let's increase the font for this and make it white color. And you can write a hint, hint text. But not required for labeling text. Generally, we can write in here and drag the controls on by one. Label and textbooks. Namely slave less task. Jimmy, Jimmy bit, so that it will be easy for us to see that. I'm doing it. Okay? This is a task names. And let's copy these labels one by one, because we need three levels here. And three input boxes or date. Or input thing can put controls. So Task Name, due, date, and status. Okay, Now let's add the input controls. First of all, we need to add a text box, text input, SSH. And let's add the date now. Date picker. And let's add a third one, drop-down. So in this drop-down, the values will come from SharePoint list column. Okay, let's keep it button here to write the patch. Patch function in location will be happened in this button. Okay, now, let's check one by one control. Input controls here, the text box into text. And you need to remove that texting foot here and configured now the status. So it is coming from the SharePoint list column status. Now we can configure it by choices and giving the name of the column. So column means my tasks dot status. So it will show the status now into that control, problem controls. Now you can see here once issued, done this, you can see in progress Nord started and compute it. Okay, now, let's take a preview of this. And let's right now the patch code inside the patch pattern. Okay? So select the patch button. And one more thing I want to do is whatever I patched, it must be assigned to a gallery control so that whatever we insert in a SharePoint list, it will be reflecting here. The data will be reflecting here. Okay, so that's why we are adding a gallery control here. So now let's write the code into the patch data button. And once if you batch anything, it will appear in this gallery control. So now let's select the date and select the status. March chatter, batch, Jetta, clip, Latch, batch data. And now we need to read the code here. Actually. So let's add code here. So let's adding code for this statue on Select. You need to call the get function. And you can see the c Suppose does in tanks, heat must have one data source and they record. So since we are creating a newly, we need to use the defaults here, okay? Edge of my tasks and B falls off mine. Does. We need to we need to match column name with TX2 controls in this screen. Okay, Tatum, put one dot text. We have Judy. We can write new date. The column names here and in the products must be equal. Unit date picker, 1 dot selected date, September. So we can see here we have status and the status. We need to get the status to the SharePoint status we'll come from God bones, so we can always write here selected text here. Now everything is looking frame, warmer texture, things plane. Now, let's go and see whether it will work or not. Here and click here. So you can see here the patch function is so that ideally you date status defaults. When we're creating a new record, we will use defaults and the patch function. Okay? What shall we do know? So let's go and take a preview here and just pick the bad data. And if anything is SharePoint list and it will be assigned to the gallery here. And let's add one more item. And the gallery, you can add one more item in the gallery. So we can have a new entry which will be assigned to the gallery now. So I'm selecting gives you life in selecting and clicking batch data. And you can see one more item has been fetched. Single, single item at a time, okay? That is a example. Add one more item here. And I add one more item. So click patch and you can see the last item. So now what we will lose like we will play, do modify, record our item using the patch. Ok, so now what I will do is I will create a check my clear the layer and I will write as mark as completed. So before that we need to change the status to in-progress are not structured in a SharePoint list. Now, we hell three items here. So now let's write the function for individuals item in that gallery. Okay, so far that check box icon here. So we need to add it. To add an a downwind do the gallery, we need to select one item and drag the icon, whatever you want. So to really understand that you are going to add inside the gallery. Now select the check. So here my Amish too, if anybody clicks this thick, the status of the status must change it to completed here. Okay. So I help fill that mark as completed. Okay. So let's see now. Mark as completed. So once we knew muddy, like clicks, this mark as completed, the status will become completed for completed here. So individually we must go and do this for all the create ohms. Okay, Now Write Checks. Icon. So to catch the mark, modify the items. Knowledge. Slate. Here, Marty Fei Ye when normally to the defaults here because we exist the modification. So Charles might asks, who recognize this particular item in the gallery? When you trade this item? After this, say don't weekend, read the value of that particular column. Status. We can great. Satan is used to recognize the individual item in the gallery. Item comma. We need to open parentheses and red are required on his status. And status. The value will be completed. This update we need to do. Turtles were new completed to compute target and then double quotes we can get completed. Now, quickly fade one more thing with anybody clicks year. This check box kind of thing. And I'll mark as leader must be. Mark has been brilliant, even normal, but this checkbox control, little dizzy when here, okay. This chick, so fat that we need to go to the display mode. And the display mode when you create a single simple if condition is this item dodge dip, readily really pulled a completed. So any record in the gallery is like the stratosphere is completed, then we need to disable this, or you need to disable this completely. What we can get some information display mode and dot ADH. Display more Mandant edit, okay? Now if you click anything, it will become disabled. And stratospheric. Really sure as complicated because here mark in the status rates. So let's see comprehension and also it may be upgraded into the SharePoint list. Let's go and check in the SharePoint list once. So you can see it is showing concretely, do we know? It is like motif, model thing and I don't know some grapes and the customers will ask something more than this. They want to modify all items at bedtime if they want to do something in. So we need to like batch my dusk and this Satan. So this item will recognize the item here. Okay. Here see, oops Bache, the status column completed. Okay? And it's the beauty of detached function here. And we're modifying single items here in a gallery? No. What if we want to update all the items similar Gallery in let's see that one also. Let's before that. That seems the Status columns, they don't slip seeing the items. Now, let's add a button here. Which middle? C? Batch. All the data at anytime. Yes. Okay. Funded. We can have a button here and we can keep on top of that gallery. So these will be the customer requirements generally. So that button we need to write it for all function, yes. Okay. Now let's think how to this function with the Patch button on. Select that for all. Let me add some comments here so that the people understand and function. So that it will identify all these things that we need to write for all our items. Again, no comma here. We need to recognize the record. So that way, we need to read a patch here for all Batch, batch of tasks, my tasks. So after that, we need to read the really important thing here, which will recognize the ID. Yeah, okay, so now we can write this record dot ID. This is the key point here, so that the firewall will work for us and the status you do normal value completed. So no Next one check. Let's go and check your format. And let's go and take a preview. We have written for all and we are iterating here. You can see it. We can't yet reading the gallery items here. We had an edge. Now let's go to preview and batch all the tasks. Status. Now. Now you can see all these data seal which NG tube completed with the disabling of the check box on the right. Checkmark also disable your lips sick whether it is happened in the SharePoint list. And the SharePoint is to also go to the completed status value. So we can learn the fundamentals of catch. Okay, so let's get into the next advance of things on your patch. 18. Patch Complex fields: In this lesson, we will see how to batch complex. We already know how to use patch in batches the function rare petal submit form. We can use it and insert all the data into our data source using this patch. So now I want to patch complex fields in SharePoint. So if you have a SharePoint site, will go and create a list with some Few complex fields, like a lookup field and a person, our group field. And then normal text field here. Okay? Now I have a SharePoint list here. So it's name is mobiles. And I'm going to list settings of this SharePoint list. And you can see here a default column, title and a personal managers and the lookup column, country too. Okay, So like date, you can also create one complex fields here. And let's see how we can patch that using tarps. Okay, so let's start CO2. You can also see now let's go to your Power Apps. And first of all, we need to add the data source right here. My data source is from SharePoint in the SharePoint site. I need to select my data source. Since I'm using lookup, we need to lifts here. One is countries and the other one is mobiles. So here nothing, don't worry. You need to know how to create an elif condition point. If you don't know how to create a lift-and-shift point, chuckling another course on SharePoint basics. So you can able to learn. So now let's insert a label here. Right? So just to do something about the film, Let's start adding one by one here so that we can patch this complex fields here. And one more thing, if the lookup is nothing but suppose if you have a lift in SharePoint and if you want to get the information off that lift in another list. So you can make use of a lookup column and you can get the information of columns into this list. So if you want to make simple, VLOOKUP is nothing but if you want to have information of the other, you can get here in this list using the lookup field, okay? So lead one by one here controls. And let's see how we can patch this complex fields. So I'm adding the textbooks for debating and simple text. And this is also simple column for us. Let's add to the managers here. So for the managers, I will take them to generate manager name of us. So we will need to add a, we need to add some kind of Office 365 user conductor here. And using this, you can get the manager name of his physics for users dot such User dot display name. So to select our managers here, we will write an essay and these two are not the problem of users, such users and it will, it is not leaving anything in this drop-down here at present. Even if you write this offices for users, such users disciplining. And so let's copy this host seeking something. Okay, let's, let's copy this. Here. It's giving the things. But maybe we need to select on the right side. I think it is better to use some other control rather than this drop-down to see why it's not coming. Well, it's not taking these names. Generally, it must be working, but let's see why it's not working here. In the default. We are trying to do this offices swaths of such Display Name, display name. But somehow this control is not working for us to display the usernames in our tenant. Maybe 18. We can delete this control or we can make use of a combo box. So let's do one thing. Go to the drop-down and check the default properties. Once again, let's add know why it's not coming. I don't understand why it's not binding this. Let's take Version 2. There are two versions to keep this username. So let's take this version to know you're getting some data. Okay, Let's see. Where is this manager's our users. We got to use disciplining. Something. Sometimes we need to try lender that we need to do, right? So that is something we are doing now. And don't worry much on this. Drop-down is not taking again, it's not taking. Okay, let's do something. Let's delete n, Let's take combo box, then. We can expect something good here. So let's see. Yeah. Yes, we're doing the same formula for the combo box. Given this display name here. And now you can see all the names coming pen, Let's hope something good. Yeah, Well, see now, after adding this combo box, we are getting all the names so that we can find one manager Wadi creating an item. So now let's go to the other field here. So I'm giving him Chris DTL by default, when you open this form, you will see the crudest did here. And in the country lookup drop-down. So here the values will come from the country's list. Okay, I'm binding a country's list. Items value in the value seven given painting. So you can see now some data is in this top bone, right? That's why I added two lists here. Let's add a radio buttons, since we know that status is a complex column, no choice column, so it will be complex. Status is a choice column in the SharePoint term here you can see, right? So that's why I took the radio button. And to generate something, choice columns, we need to use this formula. Choices of mobiles. Got status. And you can see on the data will be generated here. So now you can see all this chatter straight. Okay, no control on the form on the screen. So now let's add a button. This, Let's rename this with the name PECC. In this Burton, we will take the logic here in the on select property of this pattern. Let's start writing or invoking the sketch function. So this is complex fields. Remember, we are painting the complex fields here. Lookup, Personal group, so that, Okay, So patch off data source or data sources, mobiles, which the SharePoint list. And let's write one by one. We know, we know that the syntax of patches, then you are creating a new item. We need to write defaults. And the defaults is also will take the source. So nipples of molecules. Yeah, Let's see the manager, the personal group. So let's, let's try to patch the fast. No need of an in-order or something like that here we can directly by the column name exactly what is there in the SharePoint. Write the logic in this bar, EPS. Okay? So know this manager is a personal movement. So let's first derive the title. And titanium will be coming from the textbox, so text input, text. The next one is actually in the fall, it is date, but we can write in whatever manner we want. Since we are dealing with the complex field, let's write the formula here. The code for the manager. Since it's a complex field, we care right at all data type. And check carefully how I'm writing this formula. So that you must keep this in mind. Because this is a standard format given by Microsoft. If you want to know the managerial fully complete formula, you can also get this formula using Power Automate. But here the power Automate is we are not using. So I'm just writing this formula. While dating this must be very, very careful because even if a small mistake in rewriting this with some brackets are some common ones, this will not work carefully observe here. So I'm just typing this formula and see you also practice along with me so that it will be easy for you. If you find any doubts on this. You can always message me. And we'd have a section to discuss here also, you can ask me. So I am just making here writing one by one length. So faster how convoluted award data type. Now I'm writing that claims. These are actually, we can tell them like a properties to patch a complex field, person or group. So let me stop my y's for some time to carefully observe how I'm writing the formula. Okay, relax and see. I have a function which will make, let us, since the manager may come from obviously. So we are writing this lookup. Combo box. Must be very careful. This department. Okay. So we have written everything. No. But we have a simple problem here. So that's why it's showing the red lines, maybe some kind of a bracket problem here. Let's say, OK, enemies, let's write the other things also. Feels like a date. Yet the column is published date and then dragging the gate control. So let's try it for the date. So let's complete this trading friends so that now we need to know. Now we have computer date. We're writing for this status, which is a choice column, needles little bit complexities involved. So it will be similar to the one we have written 30%. The middle rate, the fast lane as bolder type. Since Choice column, we will have value. And so we have taken the radio buttons, so we are writing no really one dot selected value, okay? No trading for this status. Now we are writing the complex field code for the lookup. Let's see how it will go. Since it's a lookup, it will have, well, we need to take a similar kind of data types, the same. Here we will have two more lines. One is you can say like IAD. The other one is again value. Let's very good. Carefully befallen my video. Let's go riding issue here. Everything's fine. No need to write down what is the name of the drop-down? Okay. Let's see that the names we must check because sometimes the internal names will be different here. So everything is fine. Here is a date. You can write next to be dating. Because this is not a complex field. Let's see some brackets. Sp list expanded, expanded vx. Okay? So this must be carefully. You should be keeping in mind expanded users. This actually cooperate for other fields also. We need to correct them. Okay? So for the small wing mean. Okay. Now we need to write the check. The formula is correct or not. Here we need to read SP leashed expanded user French. So we are starting now repeating, then we're good to go. Once a patch, everything will go into our SharePoint list and it's really the core is ready. No. No. Let's go and review the alerts. And one by one. When he said let's give the manager year, date. Soviet, it's generally takes to the state and check the country and click in progress. Much. Moisture see observability. On the top. It's rent when RefSeq in religion. That I didn't. It's not coming up. Let's make some errors. Are there? Maybe because this is a pledge fields, we need to be very, very careful. Don't worry about this yet. Some maybe too many errors of the Leipzig how to solve one-by-one, the unselect value radio and not selected here. Let's see what exactly is bothering us. Okay? Status is there, it's okay. Maybe more bug here. So let's say we correct formula for everything. No. I don't think so. Nothing is there for the stewardess condone. Let's see what the lookup value contribute. I don't think. So. Maybe because of a small flower brackets here we have so we can remove them. Everything will be working on. So let's see here has written many years. So let's do a few. Yes. I think no. One more one more research here. Yes, listings must be very carefully. Now gets done now for my erasing is what we'll find and let's go for trivial and play this app and click Batch. Okay, now, yes, now if you patch with the same data which we have previously, not good patch from the top you can observe some dots are moving to the right winds. It is successful. Then we can see the data is coming into our SharePoint list. You have no, You can see that data is being inserted into the SharePoint list. You can see this pollution days status and magnesium permanent shape. Okay? So this is how you need to patch the complex fields in Power Apps. So let's see one more time. A full big for now, but we need to remember it. Because it's not easy to remember. We need to write somewhere in your notes and you need you just copy paste that from the field. So I hope you all understand this. And maybe it's little bit complex. If you really feeling any complexity here, just to e-mail me or just practicing two or three times, then it will be easy for you. Okay? No. It will go to the next important topic contents by this step. Okay. Thank you. This next lesson. We are good to go now. 19. Multi Screen Patching: In this video, let's see how can we loo batching. But a complex solutions are a big glitched and divide that feeds into different screens. Suppose, if you have, say suppose 20 fields that I want to divide that into 55, 54 feels like that. Okay, So further, let's add that complex or big glitched into this Power Apps. Okay, so once if you add and let's go and create the new screen. So I'm creating a new screen here. So now the new screen, Let's add a form by clicking insects. Will click Edit here. Sna, source to this form. I essay in the SharePoint list here. My, it's not as simple list here. So you can see no. Actually, yes. Here you can see all these things right? On the fields must all the links here. So now let's remove the fields which are not necessary in this fashion screen. Okay, So one by one. So on the left side you can go to the 11 by one, the fields and try to remove, delete. Okay. So now see just not necessary in this first, okay. Okay. Yeah. Okay. Yeah. It does simplicity actually a wood employees, right. So I'm keeping a label here. So I'm giving its name as employee information. You're done with the first screen here. And we have kept whatever the fields necessarily in the fastest screen. Okay? Now, let's apply some colors for the screen. Okay? And how to conduct green Mulcahy. Now, we have 12345 fields in the first screen. Now let's add a button. When I click this button, it must go to the second screen. So in this button we will write a formula to navigate to the next screen. So we already know that we have a Navigate function. Now let's add one more screen. So in this screen, Let's add the same procedure. Had farms, edit and the simple selected from my SharePoint. So we again go to all the fields here, and now let's remove one by one. We don't need the first define fields, so let's remove them. We can also use these tools section and we can also remove here and also we can remove from the hierarchical view also on the left side. So let's remove one by one. No. So let's bring it down the form. So here the key point VBD, hold these. They will know whether it is flushed screen or not. So that is the things we don't know, let's say. So these employed contact info sheets. And let's add Run button here in the down. So that will go to the next screen. Just like what we have done for the fastest screen. Same thing. We will add the button here. And here. Again. Let's add one more screen. And let's add a form again. And it gets to this form. And again, remove the fields which are not necessary in this because they had already available in the screen to screen 3. So again, remove things one by one. I want to keep It's all level the employee. So the employee and aim and setting the label. Okay? So again, the key point here, manipulated how these three screens will know the belongs to the same leashed, could just wake up. Sometimes they will tell you the trick here. So again, EMI led a button here, the final button. I will doing in this as final, final batch. Right? So This is our screen to screen 3, screen force, right? These three screens now we need to connect. So the thing is, go to scream three. And here we have a property here. So actually from the second form, select the second form, okay? So that data source, we need to do defaults so that it will be connected to the first deform. So the faster form is in the screen too for us, there is no need to write the defaults. But from the next screens on wards, we need to rate default the data source. So repeat same again for this third form here, go to the data source of that formatting and defaults. Writer defaults, and in that SharePoint reached. Now these three forms are connected with the same relished late. So if you do submit and all this data will be inserted into the same religious. That is simple list which is available, which is no SharePoint. Okay. Now let's add the in the final button and all the buttons. Actually in the screen two, we need to write them navigation function so that it will take us to the next screen, screen tree. Okay? And also some skin transition that feed. So now for the third screen, just navigate to, it must go to the full screen. Now. Now we're getting ready for the final submit button. So exactly, we will let Dispatch could dispatching those multiple screens here. Okay, now we're coming to the real important step. Now, this is the final submit. But here for this form also we need to connect, right? So this is an important step. Now let's try th the patch. So we already know that. But we take the data source because we are inserting a new data, we will write here defaults you the same data source. The small updates form two daughter updates? One to two forms. Shapes? No, because we are creating the form of debt software, the form of goods intended really, we will reset the form, right? The three forms later on that finding, we will do we need to visit all districts farms so that again, when they come to a given entry, it will be clean without any previous data. So let's write Dax. And good part in Betty's became patch a field outside of this form also. Because don't think that there is some finite fields in a form. And if I write a sealed outside ofs This Islam, and it's mentioned that in the batch. So it will also, along with the form controls, it will also add to the control which is offsite. So let's write on not spatial data submitted sepsis. I think we need to write that out s2. Okay, if you want, you can waveforms one daughter desert from Google research. That's not much necessarily but in this class, but you feel sometimes customers have on screen you can write those things. So now, let's stick with our syntax of writing this code is right or wrong. Maybe I'm seeing a red line. So there is something which we need to correct here. Okay, so now I have written the Nordics pay outside of this batch mode site. Okay, let's see how it will work. Faster one. So because you have nothing is visible, we need to change the font settings. And on the right side there is a property for every form will go to the right side and change the default mode too. New. Reform do the same thing, repeats. Go to the right side and leads hold. Mali's new. Default mode is new. Okay, so right now, let's go to the first one. And this is the first farm. And let's type something here. Some information here. So this is a multi-step patching. So now let's click Next you to take with the next form. Next is clean here, which contains the form. So let's do some some tips. Next to. The next screen is a tiny one. And then submit. It's the final submit. All this data will be submitted into the one list. You know, we bought demon permissions that are submitted and you can check node in the list. Yeah, we got this information, Mr. Smith and all these things and these how we can do this multi-screen patching by column employee chain. And let's see that also how we can batch outside of default. On the same screen, on the screen. We'll include this control textbooks. So now we are actually merging the data in the form of notes it the form using the patch. Right? No, no. Let's see. I will take an input text box. But outside of this form, this is embracing the main intuition on this rating of several deformities that batch will actually help us in inserting the foam as well as the state controls. So now, right, The, often the form three sub grids right here. Open the parentheses because this is a single team here. So we need to mention what is a field. We want to get to it. So I want to patch the field name, employ rank. This textbox name. Let's say what is the name of the textbooks text input text. Let's submit the same information. Since we have not written here from one daughter reset. So that same information and hygienic contain here. If the phone wonder that release it and the information will be clean. So non-core to this second form. The second form yet Something data mentioned some data here. Okay. So here a boat in the profane realm, something which is in the form and employ rank is out of the form here. The control. And like something in the employer rank also. So that we can see the how the batching will happens within the firm and outside the form. Submit and get a submitter know. And let's score and see or say point list with a yes, we got the information. This is helping me to do this multiple screen patching. Patching is a very good thing for absence Giving us make use of this. And you add all your complex functionalities using this batch. This is the screen one screen do that business, patching. So my luck, good luck for new students. Anyway. So hope you all can these concepts, concepts, important concepts. 20. Add PowerApps to Teams: In this video, let's see how to add up to the games. And we can add as it appears. Okay, So let's say go to these teams here. And if you click Edit, Deb, the general themes, and click Add. And you can type Power Apps. You can see the products here. And click Add here. And this Photoshop's is added. And now it's getting all the apps. Okay, Now you can see all these FCF me male TO these halves here you can see. Okay, so let's select one of the RPN and see how it will work. And I'm going to add the dashboard form. Okay. You can add doublet of doublet management easier. So let me select this dashboard and click Save. Now, you can see my thought up coming and rendering and D. Microsoft Teams is working smoothly. You can edit. Everything is working fine here. Okay? So if you want to connect anytime, you are Power Apps to the Microsoft game, just tab here. Okay. Everything you can add one more. So let's see. Let's select something leg the sun's click Save. Now let's see, this is a business thing, is every level in this app. So let's add one more tab. So now see here, okay. So it's sort of got EPS or create an app been bought cups. You can answer. So you have this will go to the products. And you can see employee learn variables. Everything is employee em. Save this rendering. So you can add as many products in our Microsoft Teams. Thank you for watching. 21. Call Power Automate from PowerApps: Hello everyone. In this video, let's see how to call Power Automate from Power Apps. Okay, for that, good to PowerApps, first, click Create and create a Canvas app from blank. And here named test called PVA Power Automate. Okay, so create. So it's loading Power Apps Studio now. It will take some time to load all the components. So basically the spot Automate and Power Apps belongs to Power Platform, microsoft curves created. So apart from this, Power Virtual Agents and power ba are also the part of our platform. Okay, now, so the app opened, skip here and create two fields here so that we can pass those two fields values to Power, Automate, click and set their name. Textbooks, text input. And again one more level here. One more label layer with rule number. Okay? And you make textbooks texture input. And now click buttons. So this Burton will invoke Power Automate. Previously Power Automate is known as a mass flows. Okay? So now let's see how to invoke this. So here you unselect property of the button. Generally. They will be false or true. But we can also write in action here on the top. Action. And here we can add the flows using Power Automate. Click the Smart automate. And here it is asked him to create a new florals, select the already available flows, okay? But I want to create a new flu here, create new flow. And it will take to the Power Automate portal. And here let's create the new flow. Create. And since we are creating the flow for the Power Apps, so create from scratch. So here we have our trigger Power Apps. Okay, so let's click these forums. And in the new state. So what should we do is like we need to send or we need to get the parameters from the Power Apps. Okay, so far that Let's create a variable or something like that. Compose. You can take on was that operation and inputs. So this input will come from Power Automate. I'm sorry, Power Apps. Okay, so good to hear. And here we can see Ask in Power Apps, right? Click this, okay, composites. And you can rename this if you want. You can do one thing for us to rename this as student name. Okay? And again, you take a new step, will give, compose, and rename it as colon m. Okay? And in groups in which you're going to get from the Power Apps. Okay? So asking about Fs, okay, now, let's see here. And let's go to our apps and chick. So flows associated with the button one, okay, this is a button on. And what is a power? Whatever student name, roll number, this is the Power Automate and the flow we have created. So now these dual use student name and row number must come from power-ups rate. So cell up here, the floor and add it to this form. Now it's adding different this flow to the Power Apps form. And here it's giving us the run function here. And our run function is accepting to better mentors snow faster, knees. Compose inputs means name. And then next one is rule number. Okay, So no, the first parameter, Let's do the name text box. So the name of faster ticks boxes text input 1 dot txt. Okay? So the second one is rule number text and put two dot txt. Okay, Now let's see, let's implement this, ladies, and let's see these two inputs. Go to Power, Automate or not. Okay, CV this. So now let's preview this app and give you the values in the textbooks is those values must be coming with the Power Automate nodes. Preview the name. Let's skew. Which no. Rule number is nine, okay, No. Click in OK. Power Automate. Power Automate now. And let's go to the bar automate and go to the workflow history for this, flow. Can weigh flows, and go to the workflow history. And you can see succeeded here and click this. And you can see here the student name. We should know we got okay, discounts. This came from the Power Apps and the room number. Main name man named. So this parameters are coming from Power Apps. Okay, so now we came to know that, well, we can invoke Power Automate from Power Apps and we can pass the parameters from Power Apps or Power Automate. Now, let's do the reversely. So send some values from Power Automate power Apps. Okay, so let's see how we can do this. Let's go to My flows and edit the flow. The flow, and click on the top. So now here, the new step. First, decide what you want to send to Power Apps from Power Automate. So fat that we take a compass, that our version. And right here something, whatever you want like this value for VA, min-support our permit. Okay, I'm giving this input. So here we can rename this as from B, which means this. Oh, groups are from the VA. Okay, Now, let's click the new step and go to the Power Apps actions and get bought up sections. And here we have only one action from the Power Apps, respond to your body up, our flow is still up Dutch. And here it's asking to add an odd, okay, so we sell up next year. And it does ask them that you can use Lake see from underscore VA Okay, and deliver value to respond. So this value will come from the, from B, okay? Outputs from V, outputs, okay, click C10. And know. The challenging thing is to get this value. End up Power Apps. Okay, so go to Power Apps and we'll get the value. So the value will send from Power Automate power epsilon. So store that value in a label. No. Okay, so far. Set the level here. So keep this level here. So now it will be very tricky here. So the text value must be similar to similar thing like this. So no, What shall we do is copy this MOOC, complete expression and new here. And let's sic anything available from the Power Automate here. Nearly a year. So let's go to the ER, action and Bharat and rich set of this part of it here. It's edit. If I click again, nothing is happening here. So sick here. Nothing is coming here. And here each. And we will go here. So let's save this. And let's hear what will happen manually or automatically the recent triggers succeeded. Okay. Did test and your flow ran successfully. Respond to the exclusion of template restaurant water is stick with the client application is not waiting for invest funds from service circuit. That's okay. So now let's see the value we live. We are here marks which not come in here. Absurdly here one more thing. Nothing is come in here. On what to do is let's and this Power App one more time. Okay? Once you deserted here, we already know that text, sorry, text input dot txt, comma text, input dot text. Okay? And, and do here dot. And you will get this variable from wonders for PA. This is what you're actually, we have given here at anode, okay? This one from underscore per year. So this fill activate here. Okay? So copy this complete one and use this value is hey, recruiting at this level. So we can make it as say, something like global variable and local variable. So let's do each set. We set means six it, anything is happening or not. Nothing is happening. In MOOC. In this invoke itself. Let's see whether we can write something here or below. This. This sit, sit and read this name, a variable in here. Yet I am writing the name of the variable VA where, pair, PA, Where we, or automotive variable. Okay. Pharma. I will do this complete thing. Consultancy as a value here if you see a set of variable Km value, again, here, we need to give the value lot from scorpion and close the bracket now. Okay, now, let's see how it will work. Okay? Do you eat? And let's send this value again in work VA. And we need to assign that variable. So let's see whether this variable value is coming or not. First variable, global variable, and you got the value, this value from VA can know SAN, this global variable to this particular sea level. Okay? So where is the label? Okay? So this level, okay, so here in the text you can use from it will limb is there. Ba, okay. So you can see the output here. Okay, now, let's Save, to save this product and give you eat and you new variables, new values here. And in work. And you can see already this is coming from the or automate. Okay? So you can go here and go to My flows. You can do workflow is and extend such as fully and it's giving me a US student named could snap. And 1, 1, 1, 1. And from VA, this value from VA, respond, it's, everything is working fine, not good. This is how you can call Power, Automate power Apps. And also you can pass the data will ways fifth son, thank you for watching. Please subscribe. 22. Split, First, Last and Replace functions: So let's see how are how the split function works and the string we got from the Power Automate and how it will work, right? So here, actually we got the we actually use split to make this text into a different records. According to Microsoft. If you check here, the split function breaks a text string into table of substrings. Okay? So our text is labeled side 0 comma modified, and the date SUV actually splitted here, this complete stream. And so the result is here table with two records node. What are the two records? Label and modified. Okay, so now we need to get the FASTA record here, label colon 51 joules. So forget that we have used it to the other function in Power Apps. That is fast. Okay? I have used the first function here so that it will be the output of the first function is a text. So what I exactly it will loop. Let's check in the documentation here. So here, the faster function returns, the faster record up the table. Okay, the first step function returns a record of the table Soviet. What is a table here? This is a table that I use or the first function here. So it will, it written me the faster record here, okay, now, one challenge is done. Okay? So the label vigour and know the adaptive challenges we need to get 5. So now what do we will do is again, we will split this label pipeline. So again, when we split it, it will create one more table here with the fossil record label. And the second one as 50, 100, 200. Ok. Now we have, I used here sweep sending again. Now I need here the second record. It means the last record in that table so far that I have used. You can use Foster Ian, or you can use the last here. See here the last, last function returns the last record of the table we can use. These are the first to end function returns the fastest set of records per table. The second argument specifies the number of records written. And then we can use whatever we want in this, this last week in this presentation I assure you with the last year. So the last will return us 5. If I use the Lost see here, I use it again for the hole. It will give me the text 510. Now, we need to replace these double-quotes, right? So what I have done these, like we can use a substring or whatever you want. Here. I just use replace here. So it's replacing the plastic part of the double-quotes. And it gave me this. Okay, let's check what exactly the city place we will do this requirement. And it's helping us to learn many kinds of functions here. So the Replace function identifies the text to replace by starting position and length. Okay? You can also see the substitute function identifies a text to replace by matching a stream. If more than one match is formed, you can replace all of them are specific. To replace. We can use both substitute RV place, whatever you want. I just use it as a replace with absorbed. Okay. So again, let's go here. And you've got €500. Again, this double-quotes is there. This, we can use substitute or replace. What I've done is I've taken two replaces. One more replace f written. So it gave me €500. Like this. We can make use of substitute also in Shut up replaced to replace these double-quotes. Okay. 23. Get version history of List Items or Documents: Hey guys. Do you ever got a requirement like this? Get Version History of SharePoint list items or documents in PowerApps. So here in Power Apps, there is no direct way to do this to get the versions of SharePoint list items or documents in PowerApps. So in this video, let's see how we can get this version history or SharePoint list items or documents. Okay, So so first let us know what is the version history in lift. If you go to any list. So you can see here list items right there. Option here, like three dots will be there for every list item. So if you click that, you can see the version history. If you click the version history. So you can see the version history of the complete a list item here. At present I'm showing here there are seven versions of their particular list item here. Okay, You can see here the list items, Version, History, number, and also the modified date, and also some comments here. Okay, So these things, Let's see how we can display in PowerApps. So now how to achieve this version history in PowerApps. So there is no directory, as I told you before. So to achieve this, we need to do few things here. So first we need to identify the versions of a list, item or document, okay, so we know that how do I identify just by clicking the three dots we can see here the versions of the ListItem mock document. So next here, but that is a manual way, but we need to know how we can do it programmatically. So let's frame a rest API you are at. Rest API will give you the version numbers of the particular list-item, right? So using this rest API, we have an option in Power Automate to send a request to SharePoint. So the step that action we can use and we can input the ID of the ListItem from Power Apps here. Okay, So in the Power Apps form, we will design a gallery where we will get all the documents or list items. And I click that list-item based on that list items ID. So it will invoke the power Apps, Power Automate and Power Automate. It will give us the all the data of the SE, this list items version history by calling the rest API URL. So here, let's see the execution one-by-one. So first we need to input the idea of a list item or document library. So next it will invoke the Power Automate from the Power Apps. So here the input will be the from the Power Apps. Okay, So based on the input IED, this Power Automate, we recall HTTP URL from the send requests to shave point tip. Okay? So once we done that, it will use the JSON format of that particular data. So this data will come in JSON format like this, but which is not in a good shape, right? So what we will do here to make it in a good shape, so you can make use of Power Apps, text functions, and we can manipulate the JSON into normal readable format. Okay? So like this, if you see in the output of the Power Automate, you can see it is like age isn't right. Power Apps, we manipulated it like not mercury WV. So let's see from the start. So how to frame this flushed in the HTTP URL here. So we already know that if you are already aware of the risk TPA in SharePoint, you will be very easily can get this. Okay? So here I am giving the first, see. Here, I'm giving the URL and then the site and that particular site name. And from that, we are giving the underscore API slash, slash lists slash good-bye title of medicines. So it will hit the Medicines List. And in that I'm giving items of 12 minutes. Item number 12 I'm requesting. So in the item number 12, this 12 will come from the Power Apps. Okay. So next slash version and the versions, I can select only version label, okay, At present, we can have version label or else you can if you want any Modified Date, modified by all things we can fetch. Okay, so here, version label along with Gaussian level if you want another item. So you can write like version level karma modified. So. It will give the modified date. So you can see the output here like this. If you paste this URL in the browser, you must see this output, then it means you frame the rest API URL correctly. Okay, Once this is done, then come to next step and create a flow like this, which you can see the input is coming from the Power Apps, then the document ID. And we are sending requests to SharePoint and the data we are parsing. And we are using some of the data operations like create HTML selected join. And we're sending back that data to the Power Apps. Okay, We will see everything in the action and this term just explaining here. So once you've done that in the join, we are separating that particular JSON with semicolon here. So join generally take the input as JSON and it will do the output is string. You can see here outputs body, you can observe the JSON format has been separated with a semicolon here, okay, In the outputs of the body, you can see here. And once the output comes, we are sending that to Power Apps. Here on the right side you can see the image from Power, Power Automate. And you can see the output. It's given in different manner, which is not a good readable format. Okay? So those not readable, it means like it's in a JSON format which will be not good to show in a gallery. And our gender, our customers ask her to format it in the normal way. So here we will use, make use of something like different kind of text functions in our apps like split, last, last term, replace rim except right here. Okay, so now let's see in the action how we can do this. So I will show you here my list. This is my list, which is the name medicines and it helps too many medicines here, like already and non-valid medicines. Okay? So if you click anything here like one, see this product by Janet, and you can click here version history. You can see here we have 7 G versions, means like it is having seven versions. Okay? So now we need to display these versions, Power Apps. Okay, now, let's go to Power Apps and create one app here. I'm taking here tablet layout. So I'm skipping this here just to do one thing here. In set, a gallery here. On the right side, I can see gallery here, blank, vertical or whatever you want. I'm generally a will take blank vertical. So blank vertical energy is asking something like to choose a data source. So let's connect the data source here. Here add data. So add that assaults from the SharePoint. Sharepoint. Sharepoint, and hear from the SharePoint. Let's celebrate the site Health portal. And here you select medicines. This is a SharePoint list, right? So now we have connected that particular SharePoint list and now assign this SharePoint list to this gallery. So here I'm clicking this gallery and then clicking here. Now, you can see here fields and click Edit here and nothing is coming. And the layout good to blank and select here, title, subtitle and body. And you can see here all the names of the particular medicines here. So our aim is now, if I click this button, if I click this arrow, so it must do the versions of this particular list item. You can, I have added a list here if you want. You can also add a document library if you want here. So if I click this here in the right side, I need to get divisions. So now what we can do here, flushed, invoke the Power Automate to get the versions for stroke. On the top you can see action if you select this next arrow button. And if you go on to the top, you can see action here. So if you click here, there is a Power Automate option, okay, Keep this. And it is trying to ask to create a new flow. Let's create a new flow here. So now with the Power Apps we are sending the document ID or itemid. Okay? Now let's create. You can create from scratch or we can use these templates already which are available here. So I want to do it from scratch here. And you can select here, Automate Flow, and skip this. And you can select here power Apps. So Power Apps. I will take Power Apps, this one. And here the input will come from the Power Apps so that what will be the next step here? So if you want, you can save this particular one which coming from the Power Apps into one string if you want. That is not a mandatory, but generally I will do that sometimes. So initialize a variable here. So here I'm naming that as item. Id are just mentioned like this. Okay? So here ID will be a type integer and the value will come from the Power Apps. So I'm here clicking. If I click here and I can see the dynamic content has skin Power Apps and this is the important thing, right? So I will click asking Power Apps, then it will create a variable name. So then the next step is, let's see if this flow. Okay, so now let's do request to ship point. Okay? So now let's frame the URL now. Okay. So let's frame the URL. No. So I already told you, like here in the PowerPoint. So how to frame the Civil City? You URL here, you should see here, I'm just copying this one. So I'm pasting in this browser and let's see whether it will use some kind of data. Okay, so now it's giving me some data. I am given here items, well, let's view here. This is the item number by gender. Let's go and check what is the item ID. So ID is near one. So let's check if I 21, how many item I have many versions will come here and giving here one. And I can see version level starting from one. Or if you want version label. And you can see last 27, you can tally with tipped SharePoint if you want. So here's our country. Right now, we can make use of these rest API URL. So just copy that rest API URL. And let's create know. So we already copied that. And here then the next step to play writer, click SharePoint. And here you can see sending HTTP request to shape. Click this and set up the site. So my site name is Health portal here. And keep it as help get an array here. This example they are showing underscore EB slash, slash lists get better. It'll documents. Okay. You can copy or you can type here. I'm just going to type here underscore APA slash slash lists. You can also use document library here if you want. I'm using lists here. Okay. Bye it by title. So do the name, the list here. Okay, So now after the new year items, so it will do all the items. So the items I want the input from the Power Apps. So further, we have initialized here the variable. So this we can do. So we can rename this tip if you want, like Rename and it's already available ID right here, you can do IUD. So there must be a dynamic rate Michelle initial phase variable. And just select this id here. Okay? Now once you knew the ID, which will come dynamically from the Power Apps, now we need to check version, so slash versions. Here. In the versions I want only version label and the modified date. So right, Like take select, equal version label. How I know this is version label. We can see in the VA data here, this is known as version level. Because I selected derivation level version levels came here. You can do modified. And you can see modified date will also come along with diversion label here, version label. So modified age, this is a molecule. You can see this modified. Okay? So same thing you do here. Version label comma modified. Okay, now we just got our array. So we need to read some headers here. If you are ever with the HTP, you will be knowing, know these headers. So if you're not a good gesture view that nothing much because this is best practices in this TVA from for SharePoint. So now we know that if she saved this, if I click Test, Let's see here that the seven versions will come in this action. So what shall we do here is, let's add this. Okay, here to our Power Apps fast. I'm clicking year for eponyms phase we are adding here. And start adding here. It is asking for the one of the parameters. So you get the parameter is the ID of the particular list item rate. So this item dot ID here. Okay? So we are sending the input. Now, let's review this Power App and now just send the input. Okay, and let's go to the Power Automate know and check how it work for us. So go to the My flows and go and see the workflow history. Yet succeeded here. Click it. And you can see everything is in green mark. And let's see the output of this action. Send an HTTP request to SharePoint. So everything is fine here. Accept, so outputs, output, we got like this in a JSON format. Okay? We got division level here. We got the modified gate. It means it is successful right? Now, let's add more into the Power Automate. Next, we don't know the data. It's coming in a JSON format. But if you want directly, we can't get to the properties in the JSON format, right? So we need to parse it. If you parse it, you will get the properties. What are the properties here? Version label and modified it. So let's parse this JSON data type data operations. You can see Parse JSON here. Or we can get data operations. You can see all the data operations here. So if you are anytime, if you want to deal with this Paris a JSON, all those things you can make use of this data operations. So here, select Parse JSON and view the content which is coming from the same, hence GDP SharePoint. So here, generally select V, the dynamic content here, the body. And check how good is this expression. Also you can see here body. And now here the important thing is to generate from the sample here, okay? So here you need to do some sample kind of things here. Okay, So if you want to know the sample already, I will show you here some sample JSON data. We must give it here so that it will understand how the data I need to treat. Okay, so let's see how we can do here. So we can go to. And we can January, we can write it like this here. Okay? Here we can give like this. So in the array, like this value here. And you can give like this. Or if you are not ever know how to do this sample pillared, you can always go to the street here. We'll go to work for history and copy that particular output here. Copy this Control C, and go to your flow and modify. Okay, Now next step, parse the JSON. View the content as the body from this energy TPN he had generated from sample. You can do this, the one which is generated here, okay? Now everything is fine value. Okay? So now I'll click Done and let's check how it will since savage. And if it is working fine, and we can just check from a table also, we can check here. We can create a table here, new step data. Or we can use select or whatever you want. Select cell up to each field will help us in creating the seals in our own. We came from Parse JSON. So in from the parse this and we need to do here value. Okay? So from the parses and you must give here the value because here if you see there is a value here straight. So further we must give your value m here, GW label. In the end that value, you can label your syllabi. Modified. Modified. Okay? Now, like this, if you do syringe and since you see with this when you go to Power Apps and add one more time here. Okay? You need to even never you do a change, you need to add one more time here again. And go to action or automate. And select this for AB initialized variable. Adding one more time because they're in the Power Automate it's updated rate. So if you add again here it will get updated. This item dot ID is done in. Let's go and see the preview here and click this one next sterile. And you can see the workflow history, how it will come. Go to my flows and go to the workflow history here. And let's see how it will come parse this in is fine silica. How the set of outcomes, okay, select everything is fine. Now, see here how nicely this JSON we got here labeled zone 0.06 with the modified, since we have given only two columns here. So we're getting a nice JSON format here, but here. So we need to, if you want. But this actually, this data must be sent to now a Power Apps. Power Apps. It is better always. It's, it will treat like a string, right? But here the body is not string. Now, to make it string, we can do one thing here. We can make use of join here so that it will join all that JSON data with some kind of a delimiter. So we can make use of yep Semicolon. So add here new step and AD Joined here. Join is one of the data operations here, and you click data, you can see join. So in the join, the input is coming from select, self-doubt, put, and join with a semicolon, right? Now CV H and null out the output which is coming from the join. Let's send that output to the Power Apps. Okay, so now I click new step here, and I will go to Power Apps. So we have a action respond to a PowerApp or flow, okay? So I'm not responding. Add an output. Here I'm taking text, click Text, and here I am giving the variable name like something. So from p will be having the value as join value from the joint. So here do the output of the joint and no salvage. And now you go to Power Apps and once again you add this because we have modified the Power Automate, right? So you need to write one more time here. We need to add more time, add. You remove this, add the updated one. So Power Automate tagging. Come here again, PowerApp initialize variables. So click it, exerting so that motivating also will reflect here. Now, run and you the this item dot ID. Now let's see the preview. Now if I click here again. So let's go to the Power Automate and see how the, let's save it once. And let's see now how the workflow history will come here. So workflow, this tree here, we can see select. Okay, it is giving the output as JSON. And in the join, we are taking that JSON as an input and we're joining with a semicolon. And finally, we are converting that JSON data to a string. Here is, you see, this is all the string joined by a semicolon here. And this output we are sending to Power Apps. Now. See here from PA. See this is the output. This will actually go to the power epsilon. Okay? So now this output in, this output is coming from the Power Automate PowerApps. So we need to check how our apps or deal with it with this data. Okay, now, do one thing and just go to Power Apps. Let's go to Power Apps here. And what we will do here, the logic is we will save this output current which is coming from the Power Automate into a variable. Okay, So let's do that first. And go to the Power Apps here. Okay. Click Okay. So now let's see how it will work. Okay? So the thing is now. So now let's see what we can do here in this Power Apps button, set up this PowerApp button. And anyways we are, we know that it is invoking the power Automate. And then the next plane, you set a variable because you are getting a string kind of things from the Power Automate. So store that string in some kind of a variable here. So furthered, a global variable m taken. So here I'm just taking the data comma. So I will do this complete top one. Up to this control C, control V, remove the semicolon. Okay? So now once you got the data from the Power Automate, so you here, you need to write that particular say that this is the data coming from the Power Automate. So the Power Automate, we have seen the name of that text as from PSO. You dot here and you can see that from P. Okay? Now, from Power Automate, the whole data will be assigned to this variable where data, okay, let's see how it will happen. So click it and pick this again. And you can see that dots going on the top. It means the available is caught some values here and go to the insert, our view on the top. And you can see the variables. And the variables. You can see you got some data here, right? This is a global variable. You got some kind of data. You can see all this data is coming from the Power Automate. Now, the challenging thing is how you can assign these data to a gallery Control. Gallery control generally accepts data as a table or collection, right? So the challenging part is to convert this whole text into some kind of a table, right? So far that we can make use of split, as I told you in the PowerPoint. So we can make use of the text functions available in the Power Apps. So here we will make use of split. Okay, now, let's check how the split works. Okay? So let's split the data here. Split, Okay? Split. Now here we need to do this complete data from B, from B, okay, this and you should check the text, the split text comma separator exhausting for this operator. We can do this every trends semicolon again because we already have the data with the separated with a semicolon so that it will spit. So generally the output from the split is titled table right here. This is a table. Okay? Suppose what if you store this table into a variable and all, okay? So giving and giving or I'm storing, since we already know that global variables can hold the tables also global variables, okay? So sit here and giving table data comma here again, and giving one more bracket. Now let's see in the table how this Spirit will come, the split data. Okay, now again click here and go here. And you can see here view variables. And you can see one more where table that I could click this. You can see all the things are coming in a table format. Now, this will help us in assigning this table to a collection, right? So now let's assign this table data to a gallery here. Let's place a gallery in this scandalous. So insert and take a gallery, the gallery, and take a blank vertical gallery here. And now. So we can assign this table directly to this so-called gallery. So where is Miguel rehear it went here, bring it here next to these main gallery. And you can do the data source directly here in the items you can do like bare table data. Okay, once you view like this, you can see here all the data is like this. Okay? And click Edit. Here the layout is actually blank, right? You select here title, separate and body here are titled, title or title and subtitle. You should see here, we got the result. Actually, you can see here the result here. We are getting the result like this. But the first one, you can see 7.7 versions of the year, okay? If I keep the second one, I can see you only three versions. But this data is looking little bit weird because our customers can't understand this. So now we need to. This is one more challenge for us, right? So now what we can do here is like you can make use of some available text functions from the Power Apps. And let's see how we can manipulate it one-by-one. Okay, let's see how to do that. And before that, let's go to C. Before that, let's go and see what are the things we can do here. Okay, so we have split function to split in Power Apps. Just type it. You can see here some kind of dogs if available within Power Apps, locks. So that will give us more idea here and how to do this split function Power Apps. So we must learn these functions here. The split function breaks text string into your table of substrings. Okay? So we need to break no data here, okay? First, let's break the data here using the split function. So this is a one I need fast to break this data. So I need to break this Jetta fast. So what we can do here is let me make it the values. And I can see all the data here. Visual. So let's make it 10. So you can see here, right? So we need to break this data. So how we can break here? So is there anything here? So we need first item is labeled C 7, which is a version number, right? So these labels 1 and the modified date can be split using comma here. Okay, Let's try with debt. So here, but the output of the split is a table. Here it is a text, so it will not accept this. So what we need to use if you want a faster table from the slip split here, if you want. So it will give the table like this. The result will come like see here labeled and the modified did this table kind of thing you'll get. So if you want to make it as a text, so we can make use of here, another one. And we can make use of this substring extraction. We can do here. We have here fast. Okay? This fast we can make use of the first function returns the FASTA record of the table. So what will be the first record here? If you see here, the fossil record will be done labeled 6.2 kilo, postulates, split it and see what's happening here. So I will write here split. And I will take this data here. And I will separate it with a comma. Comma. I will separate this year. And now we've got an error because it will accept all this text. But what the split, we'll do this, we'll split this data into two tables, no, two records. One is labeled sound 0 and modified, but we need the labels on 0, right? So in the first text, so we will make use of the new function here. This is a new function. Okay? So let's make use of that. First. Okay? First off, it's asking the source, okay? And given this whole snow, now, you got this source. And now you need to check. Is there anything like result here? So you got here no label 4 level re-find you, right. Now you've got labels on 1000 Holcomb. I got the fossil record. We got the first record. No. You can know. What we will do is again, we need to write. We need to get the n here. By separating into it. We need to do one more split, this complete thing. We need to do one more switch here, okay? Or we can check here. The first 10 function returns a fresh desert tougher. It took her record suffered table. The second argument specifies the number of records to them. So we can make use of this fast. But before that we need to again split it with semicolon here, column against pre-teach. The whole thing. Split here with a semicolon. Okay? Right? And you will get an a in any way settle because the Spirit will split this label and 7. So we need the second one, right? Second one means 7 we want. So what we will do use here. So we will write here one more function first, yen, yen. So what it will do generally, if you see the source, I'm giving this as a source karma and count. So from the count we need to do. So, we need the second lambda, right? So we can do here like two. And if you want to see here it will do the first 10 function returns the fetch desert of records of your table. Yes, flush to the courts. It's giving. The second argument specifies the number of records to written. We need number of records here. So let's head to the ER and check what we get here to FM giving two here and dot result. So now let's see. We got anything here. So we have nothing too. And again, we go to the first 10, we will get this C. You'll get some table kind of thing. And again from the table we need last function, last function just in the last record of the table. So we need the last record rate. So we can do this like this. We can lost record, we can directly give here last and see what will come here for us. Last. Last off. Last of source here. We're not getting anything here. Just last. So that's why we are giving year two. We will get in the front. So it will do the two record straight from from that we need last one. So I will write last year. And you can see if I write like this, you can see it's 5, you got 51. Now how nicely this last phos ten split, everything is working and we got finally 6.2. Okay, now, just a little bit. Let me go to the last, everything fine. So let's replace this double quotes here or replace this W. We can also see here, holder replace works. So replace function identifies the text to replace by starting position and the length. Okay, so let's see how it will work. Now. Just time, I want to replace this double quotes with some kind of say, spaces. If you get anything like this, replace, replace all old text. This is a world text right? Now. Replace a whole number of characters. Prof characters only one. And the new text PSU start num. Num start number is from the one and the number of characters of one. And the new text will be double-quotes, years and less sick, and you've got 51 do and again there are single or double quotes again and the end, right? So we need to remove that. So again, we need to relatively please one more time to replace them. Next, double-quotes, replace off. Hi again, it is asking, begging Q, it is num number of characters. And the new text, which is replace Sui should write like this. You can see 51 jury is getting replaced V here. So what we'll do now is to do some kind of small, let's see what to do now. So now here we have the finally we need to do here, start number. Start number means we need to check here. What if I knew here in the 7 is 7 double quotations or seven, 1, 2, 3, 4. What if I give here for so you can see no five hundred and four hundred and three hundred, everything is coming in a nice way. Okay, so like this we can do. Finally, if you click Format, you can see here how this whole thing will come like this. I hope this you understand practice. We need to get this nicely. Okay. So here we can see Sean Punjabi got here. And let's see how we can modify this. This one also. Same thing we can do here, also seeing, okay, so let's see how we can do this. We need to write same thing here. Again. Split the split here. To split this item is clipped off. This results, sorry. We are splitting widths. Semi comma here. Again. Apply the same thing here. Now we need to get the last one. Great. So here, now let's apply here the same thing. They already held this. And if you give this, you can see the date modified came here. Here also same thing we have done like split, flushed, scripted and lost secondary split again plus 10. I am lost. We have taken these trim because if we, if you think any spaces you will get, you can make use of dream. Again, replace trim and left. Okay. So this is because we needed care, care, or pursue. We had given them here. So like this, we can make use of the text functions available in this part. Here has 10 lost ten law. Replace Klimt, all these things. And we can make use of, and we can get the output for this Git versions here. And this is a little bit tough, tough one because we must know here this text functions. And if you notice this film, we urbanize. So let's preview this once. And you can see here, I can see for the first item sound, sound versions are there and the modified date here. And I will click the next one. So next list item, you can see here there are three versions. Again, we have one more. We can see here. Okay. You can see here there are five versions, but this item listings, okay. This is how you can get the versions history of the particular ListItem or document in our reps. Thank you. 24. Dataverse with PowerApps: Hello everyone. In this video, let's see what is Microsoft data verse and how we can integrate this data into the Power Apps application. Okay, Now, this data slips as securely store and manage data. And we know that Microsoft Power Platform consists of four Va bar graphs for Automatic Virtual Agent straight. All these four can use the data works as a common database here. Just like adults databases, it is also having a table and a set of rules and columns here. And this can we create custom tables using Power Query, etc. So why do we need to use this data? It is E actually a online-based database, so it is easy to manage and visit secure, Cloud-based. And the logic and validation everything will be defined here by default. And I need to choose this. So according to Microsoft Docs, it's like a Cloud-based one. And it can also, it can work with any type of data. And also it will be having a predefined APA format. So I also had very secure here. And you can also like you to, you can see that it can work with any type of app. So in the analytics and reporting is very easy in the data of f's. Now, let's go to Power Apps and check how we can integrate this Microsoft Dataverse. They will lose. Okay, Let's flip the Over app icon. So now it will open up the epsilon page here. On the left side, if you see there is an option. Okay, here, we need to add the tables. So by default we can see many tables here. So now, if you want to create a new table, just click the new table year option and I'm giving them new table name as student info. Here we can see Display Name, Name, frame rename column. Okay, now, click Create. And now we have created a table. And now let's add some columns here. Okay? By default you can see few columns in the first one is a name, and slowly it will show other columns also here. By default we can see money columns. So if you want, you can make use of the available columns or we can create our custom columns in this data verse. Go to the top and you can see here Add Column, click Add Column. And we can add the columns for government related to this table. So this is student info, right? I just want to read it column student name. So I will keep it like the student. And the data type will be text. See here the required all this validation set are also given. So now we have added student. Now let's add the class and class. And this will be also text. Or we can also give us some number, a whole number. But I want to keep it as a text. Let's add one more column section. Okay? No, No, add column. And it led the admission date and then the datatype we need to select. Ok, once you are done with the columns, the next meeting we'll be adding their records. Okay, now click sale. They will end up bottom and the table will be saved. So now the next thing we'll be adding the Berta. So on the Cloud side you can see data and there is no data here. We can add the data records in two ways. First, we can add a new record here by clicking the Add Record. And when you click the Add Record, if you want to fill up the columns, you cannot see anything. Here. I got some elderly or insufficient permissions anyways, refresh it one more time. And click OK. And now, now you can see here only name one or, but he cannot see the other columns, right? So I hope you get the other columns. So again, go to the hub for our tables here, and there is an option here, a little data in Excel. This is one option where if you click, it will download an Excel sheet. And the excel sheet you can add the data records just like a user name class section. But if you want to add in the user interface, go to Forms. And then there will be three forms here you select the main form and you can see here a screen showing to add all the form fields here. Too. You can see in the general they're only name and honor. Now you have, you add default fields. What are the rules we created faster on the student? And the next one is class section and the admission gate. So drag-and-drop all those fields here and Save and Publish. Admission date, section and the last and final admission date. Okay, now on the right side you can see Save. Once you've saved you can publish. So now the thing is we need to add some data to the trait. So just go back. You can see here only Maman Warner previously. Now once if you go to the year the PowerApps and here in the data versus information mean, you click the information. This is a place where we already added the things, right? And now you can see all the columns. It means now you are ready to add the data. Go to add code to the data now. And there is an option on the top add record. Now in the form you can see a lacO custom columns we have created. Now add the data here. Okay? Here name is mandated. By default. It's not an issue. Just add records here. Section me and Mission gates and they can go and save it and add one more. Yeah, This name is, it's a required field. So add some data here and save it. And now again click New to add one more record store and Krishna Class 7, Section B. Okay, so we're done with the adding rows here. Rows or records. Okay, save it and now go back to the tables and you can see, and you refresh the data here and now you can see two interests are coming rate. Now the hand now, let's go to creating a new app using Dataverse. And you know, you can see the learning page. You can create the app from blank or you just directly syrup Dataverse here. And when you serve the dataverse, if you'll ask us to establish a connection and you can create new collection are already available. You can select the Dataverse connection here. So click the database connection and it will generate older tables, have a label and you set up the custom table when we create a student info connected. And when you connect this, it will be just like whatever we have done in the SharePoint. So it will create three forms, details from gross row, screen, screen and edit screen, just like when we integrate it, a SharePoint list, how it will generate all the forms. It is also same thing it is doing here. And if you want in the gallery, you can change the fields here. It's no. Seem like every other. Database integration with the Power Apps. You can change the thrills here in the gallery control. Okay. This is a simple application. We can move with the Dataverse. Okay? So wherever you want in the Windows Forms, you want you just to add decimals. Let's recap actually what we have done to integrate this data table into the Power Apps. So let's go to the Dataverse. This is the Dataverse from table form. By default, discovering actually visually see only name and Warner and we actually added to the class better. So you need to select the left side data tables. The tables you can just add custom, Okay, we'll say the columns related to that table. Okay? This is very easy. And we can, in their diversity can have some relationships like many-to-one, one-to-many like that here. So you can see here the information in the main form. In the main form, we can add the farm fields. In the form. Fields. In the form fields are sealed and published. You can go to Data and add record. And you can get the records in this data. Okay. This is, we can integrate the DevOps into the color Apps. Lets you. Okay. Thank you. 25. Validations: Hello everyone. In this lesson I'm going to show you how to validate the Power Apps field, okay? So whenever use Power Apps, we can see that it is like a form, right? For every firm generally, the customer expects a form field validation. Here. We will start this validation from scratch. Here I'm taking SharePoint lift test data source, okay? So my SharePoint lift is known as electronics here, okay? So here my columns are title, brand, manufacturing, get serial number cost. Okay, So let's start and new PowerApp here from the blank canvas app from blank and type it like validations. And I'm choosing the format tablet. Okay. Let's wait what some time, which things are getting ready? Now? Skip it and now let's add the datasource fast, okay? Add Data and connectors. Select SharePoint connector here. So let's see VAEs or SharePoint connector. So once you've selected this SharePoint connector, you can see all the SharePoint sites will be coming here. Okay, now select our SharePoint site. It'll end point and celebrate our list. So what is our list and electronics, Okay, then click Connect. Once. If this is confound, now, it's time to insert a farm here. So let's check vary the forms are there here it is the farms. And now we need to create a brief form, right? So select Edit. So once you select this Edit Form, it's asking for the data source to attach here on the right side. Okay? So first we what? We need to check the default mode. So here the default mode will be new. And let's attach this datasource health chronic SharePoint list, okay? And it's, I'm attaching now, you can see all the fields. And I will remove the unnecessary attachments here. Okay? Now, let me little bit. In the snap two columns, I want one here so that you can see all this like this, or you can click to like this, you can have. Okay? So now let's observe this from fast. Okay, good to review on the left side and click the form one. And you can see here all the data cards, whatever fields we haven't SharePoint, list. So infrequently, we will call them as columns. Here. All when we integrated, it is showing Lucky data card. This is one data card. This brand is on data card. Manufacturing date is January advocate. Okay, now let's see the preview of the form. So this is a preview of the form, but there is no validation like if here, right? So also you keep on Submit button. Here. It can come outside or is okay. So submit protein. And in the submit button, let's code here. Okay. Submit form. From one, write. Her name is formed. And after submit let we set forth from one. Okay. So school no. So if you submit anything from the form that will be inserted into the SharePoint list, that's okay for me. And here I want to check like if I submit here saying like an entry is required, has an individual value. It means by default, the title is required one for every SharePoint list type that swayed showing that. Okay, now let's see how we can validate you some validations in this title brand everything. Now go to lift settings. This is validations you're giving from the SharePoint. And you can see all the columns here and the title is required. That's why when you're submitting you just showing Lake at the title is empty, right? So I I will also do here like serial number, right? There is serial number and I will make it as required here. Required. Okay, Now let's click OK. And once you change the list with some settings, go to Power Apps and go to the data. And since we changed the settings in there SharePoint list, we need to refresh this. Okay? So let me refresh and go here. And now we can see here that the serial number of let me submit. Now, this is saying something and we can like see like iPhone. And again submit. And again, it is asking is we need an invalid value is like this is a serial number. Okay? So what we can do is confusion. Let's go here and see that how would we record this column contains information, so we will keep only one column as required field looking know. And you can also write some for formatting if you want. It's not necessarily just refresh. Okay, Let's now save this file. Okay, Now let's, I'm saying this no saving of perceiving. What I will do is like, let me close this. Let me close this PowerApps. And one more time, let me click this poets from the stack. So now go to apps here. And I can see variations. Let me select it and click Create on the top. So let's see. Sometimes a list will not get updated. So by doing this open close, we can experience these changes here. And now come here and select the data cutoff tidal, OK, now you can see here advanced and here required. That's why you're getting a small star here. Okay, Let's unlock it. And here, required. I'm demoing this and making it is false. Let's go to top view and let's submit. It is asking for an entry, right? That is the immediate serial numbers. And make it true. Now you can see here this start mock. Okay? So like that, now you can use so many. You can you actually validation from here or from SharePoint list. So you can see submit your initial C and then submit the data. We can see here phonics, MB space v Gore rate here. So that is how it will work generally. Okay? So this is one kind of validation. And if you want to do, and if you want to do more validations like so you need to write something. If you observe a, if you observe this particular suppose for cost. If you observe this data card, right? And on the right, on the left side you can see cost data card here. Cost data card, you can see here error message, right? This error message will be helpful for us. So let's see how we can use it. So in this error message, can write, basically this will be having a parent or whatever, but we will rate it with one if condition if mark is blank. Okay. What does it mean like if it is not blamed? My data card value destroyed occurred where Louis see something like data. Card. What is it our Dakota value here? That occurred where new five, okay. I'm going to say dot txt. Okay? If condition, if it is non blank, so dot-dot Codreanu, so something if it is blank, some condition must be read and make it as and b here and here in the else condition, I will write like please. In a course like this, very close this here. You can see a red mark here, please in cost. Okay? So if you go here to the form, we can see this is asking for a please input costs because it is blank. This in few supposed to do something here who doesn't. And Sweden goal. Okay? So like that, we can also write some error messages in this particular data card. It's work like a validation here. So if you select this, you can see the error message. Actually in the setter methods we can write deceased conditions. This is one kind of don't say something like conditions. And also we can great validations in suppose C, say there is a quantity here, rate and this quantity, you unlock this fast. You can see in the quantity error message. So everything easier, right? If you go to a message, you can see all this text here. Everything is available here. And if you selling this Jetta God, or if you select this text box, you can see all the properties. Once. If you select these fully, you can see here the V's and the lake can observe here. Data field required. Everything is in this required also actually you can write some kind of doctor formula. Okay? You want, you can write here, okay? And sometimes what will happen is like there are some kind of, say, some kind of built-in validations given by Microsoft. These match for apps. This is, I'm kind of function which will be use in tests whether it's text string matches a pattern that can compromise ordinary characters. So let's select a. This is mismatched function ARE regular expression so that we can enter only the numbers in that cost. Let's see whether it is available or March. See is mass matches the text string. Okay? So actually is measured through this texturing matches the fat and not false. So let's see Is Match. Movements contains his magic example. See he's match. Imagine that your app contains an extra input control named exchange, when the user enters the values into this control to which toured database the user types a lower entropy texture input one, input is matched texture input one Hello World. This dashed area that the user inputs matches exactly the string HelloWorld. If deacons, if it is true, then it will recognize it through like that. Okay? So like that, we can also do here is match, matches an integer greater than 0, like this also we can give, okay, there is also one more kind of match and match all examples of Holies we can view like this. So suppose if you click Is Match and it will be controlling and check. Yet these match rate. In this match, match, match, match, or they will have little redox kind of magnetic match, multiple digits. What do you do when you do math? Just one more letter. Not just one not more letter. Okay. So we match, we can use those multiple letters match multiple levels. So if you see here on this page, you can see all these available C match, match of this range. Let us use something which will help us. So now let's see how we can make use of this. Mad and Holdings. Okay, go to Paul reps. And if you go to quantity, you can see at present, if you go to quantity, I can do here like nothing because it's like a normal number in SharePoint, so I cannot give entity, right? Okay. And also the cost, he's also a number here. Let's see. Okay, so lift settings. And you can see here causes number, quantities number. So I can create a new column here. So final costs, something like this. And I will use the singular enough text if I click OK here. And again, if you go to Power Apps, let me refresh it. And let's go to the form properties, fields. And these fields, let me add one more. Feel final cost. Okay? So I added the final class to year and it came. Okay. Let me select farm here we got the final cost, okay? But in the final cause generally means number. No. You can enter everything now here. Okay. So how to control this from the Power Apps, okay, so let's go here and reward is all stuff. And come here. And this is leaky data card rates so you can edit with unlocking the property stretch. Now, go to the last data got. Final cost. Go to the error message and you can see printed out error rate. So here we will do one thing. We will add a new function known as Qualys. It will returns the faster non-blank argument. Okay, so that's what we need here like this and the parent error, we can write one if condition, if lot match, It's not easy. Match of data. Card. Knew mine. Right here. If you see the format, our syntax of these matches, match of text comma format, okay? What format we want? We want only to enter multiple digits. So we have Match, dot, Match, dot, molar, deep blue digits. You can make use of this format. And karma. This is if condition. If this condition it will have the else if we drew or false rate so long we do. Is match multiple news, more neat numbers, a lot like something like that. You can read this morning numbers alone. Okay, So close this and let's see how we do it. So go to the Formula. One number cellos. So if you hear this, it will show you numbers here. This woman numbers. So like this, we can do some kinds of validations. And if you want more on this validations part, could do docs dot Microsoft.com and you can see all this match everything. Okay? So try this, all these functions for more validations in the follow-ups. Thank you for watching this lesson.