SharePoint Power Hour: PowerApp Galleries

[Music] hello everyone welcome I'm Laura Rogers and this is SharePoint power our this is my weekly show where I go over just all kinds of things in SharePoint and office 365 out of the box pretty much there I mean there are million different topics that you can talk about and SharePoint and we go over just demo something for an hour every week or have conversations about things and kick things back and forth we've been doing this is probably we'll probably have about 200 episodes at this point and I've been doing this for two or three years and basically we're just I'm just going to be you know demoing different topics every it's every Wednesday at 11:00 central I broadcast live we have a little bit of housekeeping we have a slack channel that we use for communicating for going to have a conversation while I'm doing that's the whole point of doing it live is so we can have a conversation people ask questions give input as I'm doing the demo which makes it fun and lively and so in the description for this YouTube video that you're watching there's a link to get directly into the Select channel if you have already been to it and there's also a link to a form to fill out to request to join it and of course I have to manually invite everybody so if you request to join it while the broadcast is going on probably won't get in that day but so we have a little channel in there with hashtag power hour and that's where we have the conversation during power hour and basically today's topic is going to be power apps we did a power apps power hour probably about a year ago right when power apps came out the products a good bit different now they've made a lot of great improvements so this isn't going to be another just overview of what power apps is this is going to be a little bit overview but mostly just a deep dive into specific we working in power apps because I feel like there are a lot of overview power app sessions and videos and things like that all over the place at this point but I wanted to go ahead and give you guys a feel for what it's like to when you're building a SharePoint business solution in there with how to do something specific so to end today's demo we're going to be talking about galleries in power apps which our galleries are kind of like the same concept as sub-grid subtables repeating tables related lists and historically and InfoPath that's one of the things that people have them have liked doing in InfoPath form library forms is repeating lists but it's always been a challenge to be able to have repeating lists in a form and not have it buried inside of the form when you're using InfoPath so it's usually suggested that you use your related list as a different list and have like a sort of like a relational database but it's just a lot it's kind of awkward to try and build that in SharePoint because there isn't really just a quick out-of-the-box why you just throw that sub table onto a form I have a blog post I wrote a couple years ago about InfoPath and repeating tables another way that blog post has got hundreds of comments everybody's trying that because it really wants to do that so this demo is shows how to do that same concept in power apps so you can have in this example we have customers and we have projects that are related so any customer can have multiple projects and we can also have any customer have multiple timesheet entries and all these different things in our site that can be related to a customer so this can be think about anything that you might have that's any kind of relational database sort of business solution you're doing in SharePoint you guys feel to chime in and brainstorm in the chat window what kind of things do you like to have to be a better related to each other to be able to show the related items on a page is it expense report and expense details is it projects and tasks associated with a project is it maybe a travel request with associated tasks with that travel request you guys feel free to bring and chimed in with some kind of things that you like to do that have you need to have that relational database concept and share points like I get a lot of my audience that's the kind of things they're doing is building solutions like that so with power apps this is only in office 365 but you can use on-premises data in it so if you do have like a hybrid scenario and you do have office 365 licenses this is a potential product that you could use to marry together data that's on premises and in in the cloud and in multiple places all right I'll go ahead and start off with a couple of demos quick demos of solutions that I've built in power apps and I'm going to start off by just showing a quick way that you can go into a list in SharePoint and turn it into a power app list a list that's got sort of power app as its power apps as its forms so let's see I'll go ahead and take let's see I've got a SharePoint list me go ahead and share my screen and you guys go ahead and use the hashtag power our channel in here to give me your feedback as we go all right and everybody say good morning and just say hello to everybody join it okay so I'll go ahead so I'm sharing my screen and it have just a SharePoint list here called travel requests I have to be in the modern look to be able to do power apps so if you if your list is not using the modern look you're going to need to go change it to either either default experience if your default in your farm is modern or change it to new experience so changing it to the default experience in mine does work so you'll notice that in the modern experience you're going to have a couple of new fairly new buttons that might have appeared here they may or not show may or may not showing your tenant depending on if you've if your admin has enabled the ability for you guys to use that I'll go ahead and click power apps and click create an app travel travel app and this is now there are several different ways you could start from when you create a power app this is just one way by starting from within a SharePoint list and this is sort of this is a really easy way because it builds the whole app for you and built some screens for you so even if you don't use this as your app you can use it as a basis for learning and just digging around and seeing how it's built and it just some thump something to start with all right so I've got okay so here's the powerup it built for me so immediately when I see a power app in here I can use this little play button to preview it to see what it's going to look like when people fill out or using this power app so it starts off with just its first of all it puts it in a mobile view by default and then it starts off by just showing a list of the items in your SharePoint list and then when you click on the arrow to go to any item you're viewing it that's like a display form and then you can click to delete it and you can also click to edit that item directly here so probably I would want to have you know some of these things that maybe I wouldn't want people to fill out or I want to be hidden or read-only and from there that's why I can go tweak things in my in my power app all right so go ahead and use this little back button navigation to get back to my main list I can also search for things so as soon as I type Hawaii I don't even have to hit enter it just automatically filters to show those and then I can also sort these this is just sorting by looks like it's sorting by the something else not the location that I'm going to yeah so not sure what it's sorting by so there'd be another thing to dig in and try and fine-tune the I can also fill out a new so this is a new item form I can fill out a new travel request and that puts the item directly in my SharePoint list when I do that so that's really and then I can refresh it if I want to get you know fine I think there are new items in SharePoint can repression see the new items but this is what you get out of the box it's a form that shows you all the lists of things a form that's a display form and then a form that is in edit form so if I click plus and I'm creating a new one or if I go a view one and I click Edit the edit and the new form are really the exact same thing in the power app so I'll go ahead and X out of this little preview mode here um so just right off the bat how do people use this power app once I've created it on a list so I'll go ahead and make sure and save this I can give it a cute little icon if I want to and give a name and I can click Save and I'm saving my power app so I've got a name for it and all that information and then I can share it which takes me to another tab I think and oh I think it's logged in as a different account it's trying to log me in as a different tenant on the screen so every time I open up a new window it's you know it gets confused with my authentication as you have to deal with an office 365 everywhere let me go back to show you sure points so let me close this so I did save it and we're going to show you what it looks like from within SharePoint once you've created it so I've got a new view basically so you would tend to I would think that I would just go back to power apps like this but if I go back to power apps I'm creating another app so you don't want to create another app you want to go to your existing app so I have travel app here and that is basically a new view in your list that it creates so this is where it is I have a button to make this view private if I don't want people to see it maybe if I'm not ready for them to see it here's where I can directly go back in edit it later and if I just want to remove this view I can do that so this is what the end user would do they would go to this view and they would click open and then the power app opens as it fills up the whole screen and it has been filling out the power app I'm not sure why it's doing that today it didn't do that yesterday but it hasn't like it looks exactly like I just showed you with in the preview so it fills up the whole screen it shows you exactly like I just showed you when I was previewing that app so there are a lot of different things you can do around we're not going to get too far into security and things like that in here but we're going to go ahead and delve into that again more specifically the galleries so I'll go ahead and I clicked edit in power apps I'm back in the edit mode here and here I can see one thing I like to see in here is I can see connections and the connections are what I've created why is it let me just sign in and see if it's just confused maybe that's a new one I don't know I just did this demo last week and it wasn't trying to get me to do a trial or anything so I'm not sure about that all right connections connections are the same thing that you use and see it's logged me in as a different account that's why it's confused about me leaving a trial because this whole browser window thinks that I'm logged in as a different in a different tenant even though I'm logged into my wonder Laura tenant in these other tabs this particular tab keeps trying to log me into the other one so let me just appease it here so we won't run into that anymore am I the only one do you guys have that issue where you maybe have multiple tenants that you work in or customers and things like that where you have your browser gets all confused about which tenant it's supposed to be used using flow and power apps are really bad about that so every time I go to like float on Microsoft com I usually double check my log in at the top right and you you have to log out and login because it doesn't know you know what what I'm logged in as on all the other tabs okay so here's the travel app I just created and here's a little bit I'll show you a little bit more information about it so I can see who it's shared with so the whole shared with org is user and then Laura Rogers is the owner of the app but then something important right here is the fact that it's got a web link when you're looking at the details of it so as far as end-users using this power app and filling it out you could always just grab this web link and use that maybe in a promoted links list on your site or somewhere easy and obvious that they can click on to say fill out a travel request or whatever they going to do instead of having them to go to the list go to the view click on the name of the view click open which is you know four clicks that's a lot all right so there's your web link it's going to be on the details tab when you're looking at the information about your app ok so let's go look at a couple of apps that I've already created go back to the home of my power apps I can also get to this from within my office 365 admin I go to off streets of admin admin centers I have power apps and flow they pretty much take me to the they're tied together so this screen looks very similar I think it's the exact same screen that they take me to for both of these but that's how another way that you could get in here to manage all of your apps and then the connections that you have are these are things that I've Afeni cated to these are all the different places that I cannot that I can use all these different types of data I can use within my power app and so make it to mix I'll look like one bit congruent app but it could be data from all these different places CRM SharePoint Salesforce Google MailChimp RSS feeds etc even steven got slack in here so that's where the connections exist again I'm not going to go through all the details about connections I'm going to go ahead and go into my power app and Adam app demo a couple of they're examples of this specific thing with the customers and projects and then we'll dig into the galleries so see how reps is confused let me close a couple of other windows there okay so I want to open my power app that I've done recently let me go look at this one okay this is the same list of customers and projects but I've built it out and added a few more things so let's let's talk about this so first of all this is I spent a little bit more time making this one pretty we'll go ahead and demo this so this has my customers and some social things I can do it looks a little weird because in my resolution right now but this is also an app on my phone it looks exactly like this when I pull it up using the power apps app just from the app store iOS app store and looks exactly like this on my phone so I've got my list of customers I can search them and you know click on them just like I showed you and I can go I always have my navigation I can go back to the home screen but when I click on a customer then I've got these are all the projects so it tells me the name of the customer I just clicked on up here and then the word project so like if I go back and click on adventureworks that says adventureworks projects so I have that as dynamic and then I can go see these projects that the hours of each project is supposed to have is listed here and then these hours use are actually a rollup from within the timesheet which is a separate SharePoint list and it's actually doing a sum and showing me live that hours use compared to how many hours are slated for the project go back and look at contoso see this one's pretty doing well so then I did some conditional formatting to show one red and one green notice when I hover over these they kind of pop out like that also I can go look I've got another SharePoint list I've got customers projects and timesheet but I can go look at the time for any given project and so now it's doing a filtered list of the time sheet for that one project and list the project up here and I can go edit any of these so all these different things in here are different screens that I've created so this is a form to fill out for new time entry I've got the list of projects I would probably want to have like so here's the button to create a new project I don't have that one connected anything yet but so those are all screens in power apps so what I'm going to show you today is this concept of this list of things which is a gallery so this is a gallery of customers I call it customer gallery and this is a gallery of projects and then of course if I go here this is a gallery of timesheet entries so that is their terminology for having a sub list or having you know a list of anything in app our app is a gallery alright so let's go ahead and show and so instead of doing everything with mobile app demos I went ahead and I can go ahead and pull that up and just kind of show you what it looks like in my mobile app it looks exactly like you see on the screen but I want to show you an example of a full screen demo so I created this one so when you create it from within the SharePoint list like I did and I went through that little wizard it is only going to create it as mobile but if you go just what I did in this case is I opened up the power apps actual Windows application that I got from the app store on my computer on my Windows 10 computer and I click to start from new blank template just as a tablet view so the tablet is the size of this one so this could be more like a full SharePoint solution that would fill up the whole page with all kinds of different things going on and you could have dashboards that way so when you go into power apps on your computer it's got a lot of demo content a lot of demo things that Microsoft has created I highly encourage you to go look at those they're much prettier and shinier than mine and they have a lot of like pretty buttons and images and they're much more polished but in this case since I wanted to just kind of go over some more some technicals about these concepts I didn't want to spend a ton of time you know trying to make it pretty but I'll go ahead and pull that one up in my on my phone real quick so this is what our app looks like that I'll be showing you that I'm going to be digging into now and it's just basically one screen right now it's just customers listed down here and skeletal scrollbar and as I click through each customer I can see the details this could be a full detail page with all kinds of information about that customer and then I've got the Associated projects get filtered quickly by that customer as I click through them and you guys chime in and let me know if you have questions just as I'm demoing this stuff so I'll go ahead and close my little preview and let's dig into the nitty-gritty so I'm going to create a new screen instead of just starting with the one that I showed you I'm going to create a new one so I'll do new screen and I can name them two so by default just screen one and screen two and these are going to be like views in InfoPath so this is going to be the same concept you've got the same set of data but the screens are going to be just different ways to view it now I have a little quick way over here with this layout tab where I can pick kind of how I want this to look do I want it to be a list of things with pictures you know or whatever and I can quickly quickly click one and it would fill it in for me and then I'd have to point it to the right data or I can just take that and delete it and I can just insert my own thing here so I can insert a gallery that's so that's what I'll start with is insert a gallery so when I first and start a gallery this is just going to be a list of customers so I can see that if I had you know maybe some customers that I had like each customers logo or something in there to make them look nice I could do one that has images in it but in this case it's just going to be words so I'll just do a insert a vertical gallery and these steps that I'm going through are what I went through in my in that blog post so nice so here's a travel request this is the app so it looks really nice if you want people to be able to just fill out timesheets or fill out or you know travel requests and things like that just on their computer on their phone while they're on the go and you could even do fancy things like let them scan in receipts and all kinds of stuff like that so as you can see when it's on mobile it looks exactly on my phone like it did on the screen in here alright Blake says is there not a way to use the template that's automatically created from a SharePoint list and change it to a tablet view now that I know of Blake that would be nice I haven't seen I haven't noticed a way to be able to do that nothing obvious all right when insert a gallery on a page is just going to have all this fake data in it but I need to point it to what data I want now I've already created my data sources these are my customers and my projects lists if I have time I might add a third one and show you how that works with a timesheet but I wanted to try and focus on the gallery so my gallery is my list of information so for items up here we have all these different properties we can choose from items is the default one it's going to show here so I want to say I want the items to be my customers so as soon as I start typing it shows me customers as one of my options and that's just the name over here of my data source that's the name of my SharePoint list customers Jim says how about security when using the mobile do they sign in with a SharePoint ID yes that just uses you our SharePoint credentials in the in the mobile app just like if you went to the SharePoint mobile app and you use your credentials alright and then I can resize this this is pretty freeform I can take it and move it around where I one make it more narrow and then so I've got a few things I've got kind of the way it looks and the way it works and then I've got what do I want the data to be in here and what I want it to do so first of all I've got the gallery tab so I can one of the nice little things I can do is I can pick you know make the template be a certain size or have a certain padding I'm going to do with this whole template I can change the layout quickly to horizontal or vertical no need to drag these boxes and make it go the other way on the page my transition is going to be as you hover down the page whether it see I chose pop so as our I hover over each thing it pops out so that's what pop is so I chose my transition of pop and I can also say whether I want the scroll bar to show or not when people are looking at this gallery so they could be able to scroll down show navigation which is this little arrow that lets them go down and then whether I want to snap to a grid disable visible world so just some more visual stuff having to do with that and then I've got let's see on the Home tab just in general it's a nice idea to get in the habit of naming things correctly so when I put a gallery on this screen it just defaults it to gallery one I'm going to call it customer gallery actually we put customer gallery too because on this other screen that I've already built out that's when I called customer gallery see up here I called that one customer gallery so I just need to make that gallery name unique so this is just customer gallery - just because I'm demoing this in building the same thing over again alright and then so giving it a good name because I'm going to use that in other places so it's going to be important I also might want to give your screens better names too now when I'm in my gallery notice that it's got it's just put title as every field so what I can do is not dope you can't click in just any one of these items down the page after when you click in the first one the first one is what lets you edit basically what happens in all these items and how they look so click on the first item in the tab to configure first of all you're going to configure what fields are showing here so world wingtips I want that first one to be see it says title that's the title field from SharePoint that's fine that's what I want that one to be then the next one I might want that to be something else I might want that to be whenever that item was created and I might have and picture a bunch of other metadata that you might have having to do with that customer and maybe showing just a couple of things here in that list of customers so this third one that's got World wingtips that's it I don't need that I don't need to have three pieces of metadata so I can just delete that I just deleted that whole box and now it's just given me - alright so now I've got this box and I can actually watch this when I drag this up it narrows them all down see so as I put things as I do things in this top box it it mirrors the exact same thing all the way down the page to all of them I might still want to make that a little more narrow there we go and then I can make this look a little nicer like I can go insert maybe a little shape in here save one insert I think I'll insert a button I really just want it to be and wanted to be like a button to press I just want it to be like a little shape in here so that's done insert text box button take me to show you some of the things that I can insert text box then inserts that could be another field so if I insert a text box it would prompt me to fill in that other field if I wanted to add one back in there but another thing I can do would be to have button that I want to do something text which gives me different types of text input controls gives me a lot of different items that can do buttons and dropdowns date pickers etc this one's just a view of all the customers so I don't need to have much they're going to be doing to interact with it right now and then of course a gallery I don't want to insert a form and don't want to insert media so I could have images and things or be able to capture things for my camera in power apps let me go ahead and you see when I cannae just want to shape I could have sworn just shapes where one of the things that you could insert in here it's a little weird they don't see it anymore okay well here I'll just go grab one from over here for my other form that I was doing see this is just a little blue box I'm just going to copy it and paste it every now and then in here you know you'll find just like in a lot of things in the cloud lately you'll find things that move or get rearranged and who knows where they went right you guys experienced that so I put a nice little pretty blue bar there and now I can now kind of made it a little shorter but I have a nice little delineator between them all and I can also do a border around this whole thing so I can say maybe I want a border of one so now I've got a border around my whole gallery and if I select so if I select this box not the not the actual fields but the whole box itself then that's where I could do things that like that would happen around you know whatever I'm selecting so all right so I've got my data in here I've got showed you how to kind of rearrange it you can add more fields in here you could add buttons let me know if you have questions and then that's just a gallery and all it again all this gallery is showing is the list of projects so items it's just I mean just customers also you have the ability if you look at my my little blog post I did you'll have the ability to do some other things in here like sort it so let's go ahead and add one thing will just add sorting in here for sorting you have to do this little do a little function so I'll do sort by sort by columns like that and I'm pretty sure it's case sensitive let me see there we go so I just start typing sort by columns it picks it so as I'm building a function here as long as I know what the function is supposed to start with then it'll let me it'll kind of hint give me a hint as to what goes inside of that function kind of like an Excel and then I can say okay what table do I want to sort that's going to be customers that's my data and that's my ride originally had the word customers in there and then what column do I want to sort it by that's going to be lets me pick from my column so I've only got three right here and then what's the sort order ascending or descending so I'll do ascending and then close my parentheses and then now I say that they're sorted alphabetically nice huh now I'll go ahead and skip to putting that list of projects on the form Oh maroon says they're dynamic forms that will be ruining it rolling out quotes soon are you talking about in power apps are you talking that's something else all right yeah just let me know what you're referring to exactly are you talking about something in the context of what we're doing ok so then I'm going to go ahead and show you since since this whole concept is about galleries and how to filter them I'm going to skip over for now the part where it shows all the details that's a form so maybe we'll do forms in another power our session but I'll go ahead and put the other gallery in here of the projects so I'll go insert and choose gallery ok rinses in power-ups well what what's different about these dynamic forms you're referring to that it's not already in there is it different than the forms they're at because they already have forms don't know what you mean by dynamic forms they'll be interesting ok so I'll do another vertical gallery and you could have you know be creative you'd have one vertical one horizontal or something like that but I'm not very creative and I just want to show you guys the functionality here okay here's another gallery with a bunch of fake information so I want this to be projects so it gives me kind of prompts me projects projects is the name of my data source that's my SharePoint list and then I want to give it a good name so instead of letting it be called gallery - I'll let it be called project gallery - again since I already have another in this other screen that I demoed I have one called project gallery and then maybe I want to narrow this down a little bit so in here this is where I can have all the details about each project so I'll get the name of the project these don't show in order I'm not sure why but I've got the name the title of the project and then it put the title as everything that I want to change some of these to other things so I can go change this to be maybe hours planned and then this third one can be project start there and then I'll want to have more information about what those fields are because all it's showing these is the value so I could just type the word hours in here inside of this or I can make this look more like columns if I want to so watch this I'll take this gallery and move it down a little bit and I can have the name of the project maybe a little bit smaller like that and then I can have one I could have an hours column and then a date column so watch this I can take hours and move it over so this is I wanted to show you the concept of having columns in here without feeling like you have to have them listed all down the page with all the fields one above you know on top of the next one so if I do it this way then I'll be able to move this way over so the customer so the project name can take up more space that's and I can also make this text box have an auto height so auto height is true in that way it a little expand it'll get longer and then see it narrow that down and then I can have a nice pretty little I'll take this little blue box and I'll copy it and just paste it and then ooh that's I didn't copy and paste the blue box I just copied and pasted the text so I didn't want to do that I just want it to copy and paste the blue box so let me move this text box out of the way there we go take this blue box copy paste and I'm going to create a nice little pretty blue box at the top of this as maybe some column headers so that's where I could type project name so I can insert another text I just take this text box I have copy and paste it I can say project name I'll end it up you can see how it could get time-consuming and the text is I'll just say project and then copy and paste that and then say hours so a lot of what I do in here is from seeing how it's done in existing apps and Microsoft's little demo apps and copying and pasting or just kind of using that to learn from so I encourage you guys to do that I'll just call that date that's like the start date I'll just make it short and put date okay so this is a concept of having a table in here and then I can also do like do a bottom border maybe border thickness that put my border thickness of the whole thing so I can take another little just box like that and put it inside of here there we go and I could get creative with the colors etc ooh where did it go disappeared there we go alright kind of nice probably too much blue okay a little bit columns alright um um I'm trying to see if you guys have any more questions if for now is a single rule down the new be responsive it okay ooh nice good to know alright so now I want this whole gallery to be filtered to only show the ones for this project right so then that's where I have to do a filter and this is another one of the things that I listed in in that blog post so I'll say items I like the way it's got what it bold if I'm if it's something I've set or done something with it's got it bolded in here so go ahead and do items and then instead of just showing a list of all projects I'm going to type filter oops got to do it's case sensitive filter and then what am i filtering filtering projects and then what's the logical test so what's the filter that I'm doing so I want that ID so I look up field in my projects list that looks up to my customer list let me show you that over in SharePoint real quick I want to show you what it looks like in SharePoint so you'll get the full gist of kind of what where this is coming from and what's it doing here is again my list of customers so when I'm doing things in my power apps just writing directly to this list in my projects and then each project has just a lookup field to the customer so it's called customer look up and that way that's how I'm associating each project with which customer it goes to right so that's what's going on behind the scenes so that lookup field is already in so that's what I'm going to be pointing to when I write this the syntax of this that I'm about to write okay so it's going to be filtered by projects where a customer look up where the customer look up . now important this is important look up fields in SharePoint's the way they store the data it's just by the ID of the item you're looking up to so that's why we actually have to use the dot ID in here to point to that you can't just put customer lookup it has to be dot ID and that's what will give you the correct filter so dot ID equals and then I have to tell it which item that I selected in the customer gallery not selected Don ID [Music] and again this is all listed in my blog post so now whichever one I selected it immediately shows the right one over here so we'll go I'll do a little preview of it and so got contoso fine hi little blah and now I can quickly click between my customers and see their projects okay so I also might want to combine what I'm doing with this filter though with some of the other things that I need to do like sort them so some other things that we can do is we've got the filter in place but remember on this other one we had it sorted as well so to do all these multiple things in my gallery I actually have to put functions inside of functions to do this so another number I'm going to show them to you separately so you can see what each one does I already showed you the sort one I'll show you the search one so for the search one you actually have to have a search box and for the sort by you could just hard code a sort a sort value in there or you could also have a sort button if you wanted to them to be able to quickly do a sending in these what I'm going to do here is show you what that little search box looks like and remember you might remember that you saw that whenever we quickly created the very first thing demo that we did we quickly created a travel request little power app and it automatically had all these pretty little buttons at the top like a search box and a sort box and refresh all those buttons so that is that what we can do if we want to actually have them search for things we need to add the search as a filter on the gallery so that when they type a word it actually impacts what's showing in the gallery so just searching just sticking a text box and saying search on it doesn't really make it a search box in here all right so let's take this whole thing take this whole we select this and this well it doesn't let me select both of them let's see maybe it does I'll take this whole thing I'm going to move it down a little bit so we could put a search box at the top of customers as well I'm just going to show you how it works doing it here on top of my of this one it doesn't like let me see oh yeah it does that's awkward okay I got them all okay then that we can go ahead and stick a search box in here so inserts and I'm going to do a I want them to be able to type into a text box of text input and make that the search box and then we can put a cute little search icon next to it too so for text instead of it saying text input we're going to make it say let me see let me show you a little more details over here so text input one when I have any of these controls selected in power apps I have it more advanced things I can do over here so I have all my properties over here that I can pick from but I also have them all listed here like the data default value says text input but I could also do hint text so search here or something like that could be my hint text and I could have a default value of nothing and so let's see done that look nice it's got like the little words great search here posted and then I've got I need to make this so that basically whatever word you type here is going to filter that box down there with it now I could that I misspelled search here yeah I did search I could also give my text input a better name other than just text input so I want to maybe make it make a little more sense when I'm working with it so I can go find the little property down here that lets me rename things don't know where is that oh wait nope here it is so renaming things remember renaming things is up here so I'll call it search box call it text search box that and so now that has a name and now I just need to make this gallery filter to whatever is in that name filter the title by whatever's in that name so you're gonna pick which field you want to filter by and then filter it okay any questions let me know okay so the next thing is to add the search functionality in here so I'll do C search here remember it's case sensitive so this is the thing that I'm searching through this filtered list of projects and then C text search box see I've got a nice name for it so it makes sense it's easy to find in here right so it is a little kind of OCD and meticulous to go naming everything in here but it helps it makes it a lot easier to be able to find what you're looking for in you're dealing with having direct functions so I'm going to do what am i searching tech surge pasta what type of value is it it's text not hint text but the text that they type in it and then what am i sorting what field am i searching and it prompts me down here to pick which field I'm searching so then I can close that and look at that and that cool so now we'll go test that and I'll type uhm Internet so I don't even have to have a button a search button to trigger the search as soon as I start typing something it narrows it down pretty nice so it's very immediate now I guess if you wanted to have a search box for you could potentially have a search box for each column you could actually have a sort button for each column - that could be be hairy because if you had a sort button for each column think of how many commands you would have to have in here to program what all the sort order needed to be you'd have to have multiple ones of those sort by columns commands right who so that could get kind of tricky so just kind of keep in mind when you're building these what how complicated you really need to make it - because it is a little time consuming to you know drag on these little boxes around and change all the little colors and name the name all the controls etc so let's go ahead and stick a sort box on here so I will insert and I have all these nice little icons I can pick from so I can pick one that has a nice little arrows up-and-down is a sort box and I can take it and put it over here so there's my sort box and I need to make it do something so I want my sort box to first of all I want it to have a name call it sort button and then this is the one I haven't done as much but I want to so might be kind of fooling around with this one but I'll go ahead and say when people click this I want it to be able to toggle back and forth because I want the value of it to make basically whenever they click it it toggles the value back and forth which will make this sort basically up and down so we'll go ahead and do the syntax of what this needs to look like to add the sword in here so we've got the filter first we've just got the good old projects list that's all we had in there originally remember and then we have the filter to filter it to just show the ones for that particular customer and then on top of that we added the search so that when you use the search box it uses whatever you're searching for and then on top of that we'll add the sort so sort my columns and then open parenthesis and then sort by columns all of that and then if there we go we've got to use the right if along the upper case I so basically if it's going to look at how might the value of sort descending and be able to toggle it back and forth so that's why I'm doing an if statement in here if sort [Music] order let me say hold on a sort okay yeah sort descending okay that's going to be the name of my button yep sort button okay sort button if sort descending one sort button so basically I'm looking my blog post and how rude all this sort order dot order it kind of you know populate things for you but you still kind of have to know what you're starting to type and you'll know whether you need to put a dot at the end of it etc sort order but it is a sensitive not a sending oh my goodness okay so sort by columns and then open parentheses search filter I've got my projects and I've got my text search box and then I've got my if my whole if statement is in here and then sort button logical text ok sort button do you guys kind of get the drift it's kind of complicated yeah I know this is this is very Debbie I agree this is getting this is kind of hard to figure out like it takes a little bit to to work through these this is not this is not InfoPath this is not you know just quickly clicking a button to say you let this button sort the values or let this button do a search I mean if you have to write commands for a lot of things in here yeah that's pretty funny um so my sort button is going to be my logical text which is this little value right here needs to be my logical text as to what um don't the thing that I'm sorting sort of sending on if I must have left something out in here that sort button equals true it's true yeah I don't know it's missing oh it's sort of N equals true if something then sorted descending otherwise sort ascending so that's the part that I'm missing here yeah that's like I said when I first put this button on the form this is not something that I like practiced ahead of time so that one thing is I must have the syntax wrong for it so I have to have to double check that sort order thing huh if sort of icons project if sort descending sort I'm just going to put sort descending [Music] yeah see that's not like a thing that that's not a value that's not a name of anything okay Wow if I figure out if something's wrong with this and I type something wrong in my own blog post I'll fix that because that's important to know right let me take out the sort by columns thing so we did the sort by columns successfully by itself over here so it's just the toggling the sorting of columns that is the tricky part right now all I have to do to figure this out though let me go ahead and save this is now to figure this out all I need to do is go look at that app that I already created so I need to go look at that travel app now if you ever need to look at two apps at the same time in here like this one I have opened up in the client software and then I could go open up another one in the web because it won't let you have more than one open in the client app at the same time unfortunately so once you have the client app that Windows 10 app open it doesn't let you have two of them open so you could open up one in the web and one on the client or to them in the web and be able to toggle back and forth that's how I learn this stuff is just by digging in and looking at these things to be able to tell you know how I need to do certain syntax and Microsoft does have a help page that you know has some syntax of some of these things in it and has documentation that its power apps comm power apps Microsoft comm or you can go look at that stuff so see I can see this is all the exact now all this one is missing that I had in my projects list that I don't that this concept doesn't exist in here is in my projects list I'm filtering it by the project having that certain customer ID of the customer that I have selected so this one has everything else then and it has the sort by columns it has the search so it's because of the search box up here and then it's got the sort order etc so let's go look at that sort button okay look at that see that's what I'm missing on select update context so I'll take that and copy it over and I'll have to do that in my app let's see if I can just do that on the fly on my button here on select update context sort descending one and sort of send one okay and then that will make my syntax make much more sense right yeah runes showing it to yet did you did you pull that out of my power out of my blog posts good that's what I was looking at my blog post I just didn't have the button dude I didn't have that value in the button for on select so that's what I was missing in here so that needs to be in place first sort by columns and then at the very end down here this is sort of you know rat a wrapper around this and then which column is it going to be it's going to be the title and then that's going to be I'm not just going to put a sending or descending I'm going to put the you know let it use that toggle button so that's why I have to do an if statement if sort the sending one [Music] so we're just sending one descending [Music] hastening that do not give me any errors or did it oh those prints Easter go aha okay now let's try that out the URL for my blog post key are you able to go to wonder Laura calm and just look at the home page is that that it's the latest blog post in there okay so so ooh look at that it works yeah okay so took me an hour but I was able to get into sort of some nitty-gritty about galleries in here and a little bit about just getting around in here so once you have your gallery again just sort of a recap you have the ability to fine-tune some things up here in your gallery to do some more advanced things you can switch over from options over to advanced over here so whatever you have selected like I have a gallery selected here this is where you can see all your properties and be able to really dig into every single tiny little facet of whatever property you have selected and then as far as what shows in the gallery you need to look at the items property year and there's also an items property in here same exact thing these properties over here match with they're the same properties that you'll see listed down the right side and then you just need to write a function to make it show specifically we want you to see what you want to see or you could just type the name like I did at the very beginning just the name of what the data source is and that would be the easiest way all right thanks guys yeah I had to repost the URL to my blog post for some reason right before we got started because WordPress had generated some weird different URL for it for some reason not sure why it was just random but now it looks like it's working fine everybody can get to it right okay I will switch back over and see thanks everybody let's see um you guys feel free to write suggestions just informally just in slack if for other topics you want to do but I don't have any topics for next week written down and I'm not sure if I'm going to take that off as a vacation day now that I have my own company IWM intercom um can take kind of I haven't really planned my vacation so might take vacation might not not have a boss but I haven't decided on a via vacation next week to do or if I'm due Power Hour but so I might skip a week and um so yeah let me get let me know just kind of what topics you might want to go over we've got hundreds in there already but they're always you know could always dig in more nitty gritty into specific things in power apps or flow etc all these new technologies and it's always changing so lots of new fun things to learn as we go right so again wonder Laura comm is my blog iw intercom is my SharePoint training company and we have power our every Wednesday 11:00 central and you can go and subscribe to my newsletter to get notified about these and to get notified about training classes that are coming up and discounts and just what kind of fun news and I hope you guys have some great holidays and it's a weird week because Christmas is on Saturday so the holidays are kind of some people are taking them off this week and some people are taking off next week but um you guys have a great one and thanks for coming and half of you might be on vacation today but appreciate it thanks yeah thanks guys all right I'm over now bye see if I can get this thing turned off you

Channel: Laura Rogers, Microsoft MVP

Views: 22,771

Keywords: SharePoint, PowerApps, Microsoft, Forms, Office 365, SharePoint Online

Id: 6P00_UwTc6w

Length: 60min 56sec (3656 seconds)

Published: Thu Dec 22 2016