SharePoint Power Hour: PowerApps Employee Directory

[Music] hello everyone I'm Laura Rogers and this is my weekly Show SharePoint power hour I have Joelle and I have been doing this show for years I think it's been six or seven years now and Joelle is not in today she's dealing with some some family things and but I am here this is this topic today is about an employee directory which is a very common ask in SharePoint something that people want to you know do all the time so the solutions just if this is your first time at power hour we not a programmer so the solutions that we do in power hour are usually pretty no code lo code fairly simple ways of accomplishing things and this is a concept that there are several different takes in several different kind of directions that you could go so employee directories now you have a directory so this is kind of my little rant here you have a directory you have Active Directory as the directory that most people have and that is built in to share pointing you have all of your people like you know when you go to Outlook to send an email there's that's your directory of people the list of people that are in your company so it's kind of frustrating when people want to build a separate list a SharePoint list to have an employee directory but then you have all these multiple places that you would have to keep up your list of people so it's the best idea just for maintenance in the long run to keep it simple and have one list of people and have that be your Active Directory so I'm gonna go over a few different kind of takes on this and some different ways that you can go about it and some challenges and I'm going to start off with power apps so there is some cool built-in stuff just right there and power apps that we're going to dig into and there's also a little flow trick that I discovered too so of different way we'll talk about different ways that you could accomplish this because there are limitations and there are kind of gotchas here and there so alright I'll go ahead and share my screen and I have a let's see do a brand new just I'm at web power-ups calm and I'm just going to create a brand new power app and so I want you to you know you could even possibly follow along on this one so everybody hopefully you're in the chat we use slack for chat so that this is interactive so you can ask me questions as we go and it's live so you never know what's gonna happen so you all definitely ask me questions over in the chat and slack as I'm doing this so and you could even follow along because this one's pretty at least a few of the things that I'm going to show you or pretty much built in so I mount a new blank power app and I just click new screen and go to people and this is your employee directory alright done know so I have just this sorted this is my fake tenant with a bunch of just fake users in it so I'll just start typing my name here and so there's my name there's me and to Joelle so I typed a Jo let's see I can do like Alex so here are the people so literally just two clicks and you have an employee directory pretty cool right alright so now the thing about this is so what happens if you click on somebody if I click on somebody adds into this little picker so it gives you this ability to add multiple people so first I thought well what does this do like what is the point of that I I'm not sure why I'm adding people to a list but then I noticed they'll watch this I go and add another new screen and it's called email and so it's another built-in template so when I so I'll go to my screen - I'll just rename this our directory and then this will be let's see our email and I can just delete this screen one I don't really need that anymore alright so go preview this and I'll do find myself again and get a couple of people here so then what's doing is I haven't put any kind of navigation from one screen to the next yet but it's using this same collection of people so technically I could this is filling in my two box so I could say you know test and send a message and just hit the send button and it is going to send these people immediately send these two people this email that I'm writing so this email screen ties in to the directory screen most likely this there's another one called meeting will see if the meeting one does the same all right so yeah same thing so this one is a meeting screen so this is all just you know connected to your outlook and your user directory and it's automatically adding the data connections for me so this is I'm I'm actually creating a meeting invite and I can even look at people's schedules in here now again this is a my demo environment so we don't have anything on our schedules but so there's my meeting sending a meeting invite to so I kid I'm gonna rename this as see our meeting so what this does is lets me pick the people and then I can create a little button let's see like a little email button where's my email whether it is male and white and then I can just make this navigate so on select this email button is going to navigate me to my email screen alright so then I pick the people from the directory and then I go to the email screen to write them a message or I can do another button and I'll do the meeting one so I'll find like a little calendar this is pretty awesome it's pretty easy right calendar there and this one I'm going to say I want to navigate to the meeting screen yeah cool okay so then some of my people screen I pick a couple of people can get rid of these let's see I'll pick this person you got to go start over each time and pick another person and then I can go click email and then I can send these two people an email I can also you know create a back button if I want to you know them to be able to go back to the directory alright so that is some basics about just how the directory works out of the box you do have to start typing a name so you have to start typing something now the way this works is this is searching users just their names for whatever you type so if I type like I T here it's not going to find all the people in the IT department like in the department field it's just looking at the names when it's doing this unfortunately so this gallery is the gallery of people so what it's doing is it's saying if that's uh split this out a little bit so if basically something is typed in the search box then do this command office 365 users dot search user so in the search user you're doing you're searching for a search term and that searches just their name and it's going to tell you how many it's going to return so I could change this to like a hundred is the max it's the maximum list of people it's going to return where this dot search user is a hundred absolutely max so unfortunately I don't have a hundred people in my tenant but you could make it so that it would turn return more than fifteen you can tweak that now it's also doing what's it doing in the gallery so it's showing this item dot display name and then this item dot user principal name I could change it instead of user principal name mail those two are usually the same thing see and then I could also change like this email address button I could make it so that on select it could you know navigate you to the email screen or something like that but on select it's going to add somebody to by default it's going to add somebody to that collection now some other things that you can add you can add I can go insert another label here and let's just see what other fields I can put in here I got company name so this is all just the user profile fields here so I can put department here I might want to put department like over here somewhere and I could do their job title so maybe next to their name I want to do I'll do an ampersand comma space ampersand and then this item dot job title so look at that so now it just puts a comma now you could put job title in another sort of column like I did the department but this would add their job title to the end of like right after their name mm-hmm so it does it definitely helps to have a an active directory that is accurate and has all you know stays up to date so yeah that's it automatically will add office 365 users and as your as the data source when you when you create this screen using the screen template okay so I showed you how you can kind of add some other fields to this to give it some more information another thing we can do is and what I did for one of my customers is I added a little pop-up that you can get more information about that person to show a little like little detail screen about that person so what you can do is I'll just go insert another icon in this gallery and I'll find the one that's got the little more thing here the little three dots so I'm not messing with what it does it's just out of the box when you click to select one of these items but I am gonna stay add this button so that if they click this it will have a little pop-up so we'll go ahead and save that and this one is more time-consuming so I'll this is another copy of the same thing so I did the exact same thing to kind of get to this point and then so this is what it could look like so it's kind of messy so I didn't spend too much time working on it I just did that right before I went live but that's how you can that's another thing you can do is do a pop-up box to give you more information about the person that you click on so I've got their job title up here and phone number and a little button that actually will call them and I also you can also make the you can make this a hyperlink you can make the email address a hyperlink to go to open up an email as opposed to going to another screen that does an email alright so how did I do that now that takes a little bit of time but just you know to make it look pretty but what I did with that is I created I'll go ahead and just preview this again and then go back out so I I created this little grouping here that's got a blue a blue label here that's just a big square a label called employee name a label for employee phone label for their department a label for their job title a little X and then these ones with the rounded edges I created those as buttons just because I wanted to them to look like little pretty buttons I haven't and have those rounded corners and then there's my icon for the phone and the button for their department okay so how did I do this so all this is is just this is a very common concept in power apps is to have a variable to make things appear and disappear so I'm gonna I'm gonna use what they already have in here though for when they get the information about the selected user so let's take a look when I click when I click somebody's name just in the default settings they had to select somebody what is it doing like where is it putting that person's name so on select what is it doing just out of the box let me go sorry let me go to the list of people again okay so let's go look at the on select here so this is doing all this stuff alright so it's all at the same time concurrent means it's going to do all these following things at the same time so it's setting this variable called selective user to this item and this item is just this whole record this whole row Stewart the list of what ad attributes are accessible on the easy and easy way to look at that right when you're in here is just to do that dot like I showed and it just will show the list of them and that's just one way to quickly see what they all are in there but you can also go look at the actual variable that it's collecting so which is what I'm about to show you so what it's doing is its setting a variable to this item that's this whole row and then it's resetting that little set text search box and if it it's saying if they didn't already collect this person collect this person that they've selected add them to this collection called my people so my people is what it's showing those little blue rectangles that it's showing that's that's the my people collection well I don't want them my people collection when I just want to show one person's pop-up box but I may as well just use this same exact variable that they're using when they set selected user so I can say grab set selected user and let me go back over to my other this is my one that I haven't done anything I'm yet and this little ellipsis and I could say on select I could say set selected user to this item so what does that do so I'll just click on Alex here it you can't really tell that it's doing anything because all it's doing is setting a variable when I click this ellipsis but let's go look at our variables so this is selected user right here so this and it's kind of funky the way you have to go look at a record variable you have to click on the name of the little purple rectangle and you have to click the purple rectangle again to get to the details now this is the whole record of every single piece of information that this particular command is giving us back notice it's not there are some things that it's not giving us I don't have the person's manager in here I don't have their office oh I have office location let's see I do have their job title but anyway that's a list of what all that it's telling you I don't have a couple of things like their birthday and anniversary so this search users command that's giving you this list of all these people is not necessarily absolutely everything so that's what I want to talk a little bit more about that so when I'm clicking this button then it's and I'll just take this sort of pop-up box that I already created in my other one and maybe I can just copy and pasted it over paste it over this thing I'm going to take this whole group and copy it and go to my other powerup and paste it and see what happens I don't want to paste it in my gallery mm maybe not copy-pasted I did paste it from from power up to power up a little while ago but just not sure why it's not doing it control see no anyway oh yeah there goes okay so it pasted it so here's my little popup box and it pastes it over here so now this it's not showing though because I haven't set this variable yet so the other thing that we would do in addition to setting the variable of the selected user is set the variable and I'll just call it vert I call it bare pop that's just the pop-up and I set it to true so then when I set I'm collecting who that person is and then I'm setting the very pop to true and then that's what makes everything appear because the visible property is equal to vert pop so in the visible property of you know all these little things is the whole thing is going to appear because I have an oh group together alright so that is just showing some you know those exact fields that I showed you it's just saying this one is concatenated together Department with that variable dot Department and so you could do something like let me take this one I'll just insert another label and this label could be instead of it staying text so I have to tap into that variable that they already had is it not what they call it I usually don't begin mine with an underscore o selected user user and then when you do a dot here that's what's gonna let you pick from all the different fields in in you know that that are stored in that variable so this is where I could put their office location or something else it's a selective user dot office location which I don't have one so it's not showing anything all right so another thing that I did is the phone number this this little phone so the phone number is actually stored Bruce says just at the location of the pop-up box I know I mean I just when I paste it in it in there it just pasted so I know I didn't really move it and put it anywhere nice did I let's see I'm gonna grab that whole thing it's not giving me like the little handles on the edge to grab the whole thing and that's funny squish it down there I have all these little feels is why it's kind of time-consuming because I have all these fields locations relative to each other in here so if I move the whole thing around they all kind of stay together so yeah okay well we're gonna go over the birthday and anniversary stuff Jeremy - so we got half an hour left so that part is time-consuming putting all those little boxes relative to each other and and all that stuff but let's go look at I'm gonna go look at something with the phone number real quick business phones is business phones yeah see business phones is a sort of a sub table because in Active Directory this is structured where you could have more than one potentially so business phones and is there another one I think that's business phones and no that's the only one so with business phones I had to do it a little bit different I did a king cat so I'm basically saying for for all of the phone numbers in this selected user dot business phones for all the values of those I'm concatenated them together with a space in between them so this is what I'm concatenated and then this is what I'm putting in between the things that I can catenate so that's um because that particular field is a little weird okay so this clicking this little X will set the ver pot back to false so clicking the X sets ver pot back to false and then clicking this ellipse it ellipsis makes it pop up again all right so now what about not so that's the frustrating thing about this office 365 dot search user is that all you get to search is their name so they're with this dot search user there is not a way to just say show everybody automatically just show everybody or show everybody in a particular department so because remember there's that limit of a hundred no matter what you do so what you know kind of what I wanted to accomplish was to just have a directory of people that you could show on say a departments page and show everybody that that's in that department but there isn't a way to do that with that functionality now I'm thinking about and you can tap into as your azure active directory that's one of the connectors you can use but a lot of people don't have access to that like those of us that are just this sort of power user role we're not necessarily Azure admins or global admins like me at you know a lot of my customers logging into their tenants I'm not a global admin I don't have access to Azure Active Directory so kind of the direction I'm going with what I'm talking about now in power our is just assuming that you're working with what you have with just being able to top tap into office 365 users and not be able to necessarily get you know go get the whole directory people straight using the Azure Active Directory connector so let's go look at what some of those office 365 use users little options are so let me go I'm just gonna stick a label on here randomly and just go look author's office 365 users dot I have direct reports I have manager I can get my profile I can get relevant people and search user training documents user photo and user profile user profile needs a specific profile so user profile and my profile my profile is just a logged in user user profile in my profile are just you have to tell it specifically what user that you want so I could so let's go do something with this let me just escape out of here if I click this button I'm not gonna mess with kind of this variable that I'm already setting here I'm just gonna add another one so I can say set actually collects Mamie I don't know how much of a difference it's gonna make um I'll just do a since it's just one record there my profile I'll just do very search user my profile is usually just for the logged in user so I'll just do very search user to office 365 users dot user profile I just using the version two one and then this is where I have to tell it what specific user that whose profile am I getting now in this case I'm in a gallery and the gallery does know it already has the information about like the email address of the person that I'm clicking on since I'm in the context of the gallery when I'm clicking this button that's where it's getting these fields from down here let me maximize this so this is where it could go get do the office 365 user profile to go get that whole profile of the person I click on so let's go see what that looks like so I'll just click this and not only did it do the pop-up box but let's go look at this new variable we got not collections variables bear okay here it is so here's this new variable yes I think it typically I like to use the v2 I usually try to do that one first unless sometimes there may be still in development so they don't quite work right but I usually try that one first so let's go look at what vert search user gives us that gives me Oh a whole bunch more information like about me birthday business phone city country Department blah blah blah blah blah hire date and then so this gives me their full profile with all that about me school skills and all that stuff in there Active Directory profile it gives me a lot more then the search users one does but I can't just it will I can but it's not efficient to just try and iterate through every single person in the whole company and go get their full profile one at a time you could but think about that's not really scalable for bigger companies so you don't want to have to go collect or anything and go get every single person's profile and pull it into the power app so I did figure out a way now the problem with kind of what frustrated with me me is that I don't want to have to keep a separate list of users that's really frustrating I want to just be able to tap straight into this office 365 users but it's only gonna give it's not there's not a way to query it by department or to query it by birthday or anything you can't query it by anything except by typing the person's name here because that's all that search users does it's pretty frustrating right so let me show you one thing that I came up but you could still use power apps but let me go over to SharePoint here kind of flow so I figured out a way to let me get flip over to this okay so while I pull this up I'll just talk so I figured out a way to create a temporary sort of directory of people as a SharePoint list and run a flow that just populates it and you could just have the flow like run on a schedule or or something like that that would do it you know once a week or something like that but I did figure out a way to populate a SharePoint list you don't want people to ever have to go you know keep the list of people up to date in both places right so you wouldn't be managing this separate list you would just be having this automated flow populate it but then once you have this list it gives you can have all the fields and you can have all the data and you can do you know have any kind of interface to it like have a power app that is filtered by Department that uses this list as the backend or have a power app that shows everybody's birthday today and uses this list as a back-end so I'm going to I created this list so that's again it's it seems kind of frustrating that I have to kind of resort to that but I don't know what do you all think any opinions on directories and have you come across challenges like that about being conflicted about do you get people wanting to have a directory or people going around creating a SharePoint list all right so watch this so my here's my I'll show you kind of the result and then I'll show you how I built it here's my directory let's go look at what fields I have I just basically created this directory with way that's not the one on one I have one that I created the whole uh there we go I go delete everybody out of here okay so I have just kind of you know like a contact list with the last name first name company business phone home phone just some of those basic columns and just to show this as an example so I'll show and I'll show you the flow in a second so I'm creating the CEO CEO is Garth Ford so last name is Ford and all the blah blah I'll just ignore some of that okay okay so I created the CEO so and I'm interested in hearing more of your opinions about employee directories and if see if you have the same kind of frustrations that I've had with telling people not to go creating a bunch of separate directories everywhere just I just hit f5 and refresh the page so I created one person in this SharePoint list and it pulled in basically the whole rest only have like 25 people in this fake company directory but it populated the whole rest of the directory so I started with the CEO and then it went and got his direct reports and then for each direct report it got their direct reports so it went direct reports and it went down the tree and it and it just populated the entire SharePoint list so oh yeah I didn't share my screen thanks Lisa ok so let me do this again I'll just delete everything in the list you didn't get to see the magic happen I'll do it one more time ok so I just clicked to create a new this is just a like a to contact list and then you know you could fill in all these other fields the email address is the important one so I save garth fort just so what it's doing is it's I just hit f5 is it's going to garth fort and getting is all his direct reports and then it's getting all their direct reports and then it's so it's basically for every single direct report it's grabbing all of the people under them so it does help to have an active directory that's correct and populated but of course now this time i run it and it doesn't do anything I probably broke it by deleting all those items and then running it again or something that's so funny I wasn't sharing my screen and then I did it and then it worked and then then I shared my screen and I did it and it didn't work all right let me I'm gonna do it one more time and if it I'm still gonna go show you the flow either way so so yeah Garth the important one is the email address I might have missed typed it last time too no G like two cars off oh thanks yeah I think it's correct now and there's a delay too so there's like a 10-second delay from when I do stuff and you all see it Lisa says can you restore from the recycle bin most likely yeah there we go so as long as you're active directory's correct and everybody has the manager field filled in then this will work it just populated the entire list of my entire directory of people so all this is this flow just runs on create so it it's only runs on create for this list so when I create the CEO it goes through the to the CEO and gets their direct reports and then for every direct report it creates a new item so when each of those people get created it gets their direct reports so then it just naturally goes down the tree and each item that gets created gets their direct reports and then once you don't have any more direct reports it just stops there aren't any more items to go get so that's how that's my whole list of people so when an item is created in this list I do this action called get direct reports and so I just go get whoever just the email address the like I said the email address is important yes this is Dell Dell Fazal it's all the same thing yeah this delve is the is the ad directory the SharePoint directory it's all the same view so yeah it only works if you have your manager field populated so what I want to do is I just go get all the direct reports of the CEO and then I want to make sure I'm just gonna filter it a little bit I want to make sure not to go retrieve anyone whose account is not enabled so I'm I'm just gonna actually delete I'll delete what I'm doing here and rebuild it for you so you can see what I'm doing so I used to get direct reports of the person I just create you can't have co-ceos in Active Directory you only have one manager field so it's just based on the manager field in Active Directory so everybody would have to have a manager in there there isn't any other way to to fill in that field so I mean it's possible that your company has co-ceos but as your at Active Directory only has one manager field with one person that you can select in it so yeah alright so I just want to filter this list of people that it gets so that it only gets people that whose account is enabled so I'll just do a filter array and then my array is just the value of basically all these items that goes and gets so I'm going to say account and abled is equal to true and you could do other filters on on that data too if you want to filter filter it down narrow it down and then I'm going to go to SharePoint it's kind of annoying that SharePoint isn't in this list anymore you'll notice that that just this default list of all the actions to pick from somehow share points not one of the main ones anymore as of the last week or so then I'll just do create and again you know this is not going to be the solution for everyone it's only going to work if you've got your manager field populated but it is a solution for getting a list of people filtering a list of people and putting them in SharePoint so I'll just say I'll put it in this directory now I created it as a contact list and contacts list aren't going to be listed and when in your list name they've actually have to type the name of it which still works fine all right so then here all the fields to populate so let's go add I'm actually going to add a couple more I'm going to save this flow and just its last name is required so let's do my and it does this given name and surname thing so my surname is my last name so notice that as soon as I do the create item action and I put something in here it automatically puts it in a loop and it's going to loop through everybody in that filtered array all right trying to cover it make sure it got all the questions yeah I was so excited when I figured this out the other day I was just like oh my god look at just just when I saw the list just populate with all these names this is like magic okay okay so then I've got my list over here and I'll go add I'm gonna delete everybody out of it again and [Music] gödel the settings and I'll add the birthday and anniversary all right so then I've got let's make sure everybody's gone nope still got a couple people in there okay now the list is so basically you'd have to have another flow that just gets triggered maybe once a week that would go get all the items in this list and delete them all and then recreate that CEO item that would populate the whole list again right okay so I'll go edit the flow again okay so for each item it should have my new fields in here now yeah okay so this is kind of tedious so first name is going to be that's the given name and I have to go I have to get it out of this purple the purple is the filter I don't want to get it the orange because the orange is the data before it got filtered so I got to get my given name company business phone see got see it's got mobile phone it's got business phone home phone mobile phone and I'm not gonna worry about all the phone numbers email address is important because it's based off of that so I gotta use mail here see they just have kind of different names so it's kind of annoying departments birthday that's easy they're narrowed down to just the date ones anniversary as hire date full name is the display name job title mobile number blah-blah-blah-blah city so yeah on and on and on okay so I'm gonna say that now this is actually gonna warn me so it knows that [Music] this could result in a loop it's like hey wait a minute you're triggering you're creating items in this list and you're triggering this when items get created in the same list are you sure you want to do this so it's not gonna stop me from saving it but it is gonna let me know to kind of be careful so that's good so now it's saving it and I'll go back out so let's go do it again and I can just hit save hopefully I didn't misspell it again birthday and higher dates aren't in a teeny dovely yeah how would so is that in Azure direct as your Active Directory though yeah where would they enter in the birthday and higher dates is that just in the SharePoint profile mmm that's a good question mm-hmm I wonder if I have time to go let's see if I have time to go look this is just you know like I said my test tenant so come on well let's just go refresh this okay so now we've got all this information and you know the new columns that I added and I'll let you know a lot of this isn't filled in because this is just my test tenant but that's all your data all right and then let's go look in admin so Jeremy you added those to your schema did you do that in online is I don't think you could edit the schema in online all right so I I know the birthdays and anniversaries aren't in this active users list maybe they're in exchange maybe they're in Azure Active Directory I'm curious now so we've got recipients that's the pain point Oh your birthday would be manually populated via your SharePoint profile okay so let's go to my profile in here my office profile so each person but that's when you're editing your my profile each person would have to have typed that in their update profile and then oh yeah so it's got my birthday in here so let's go see if it pulled for for my information let's go see if it pulled my birthday in no it didn't that's weird so no it didn't pull my birthday for my profile even though I clearly have my birthday in my profile so yes it's a great point I hadn't really dig that deep into those specific fields so here is oh man this screen is so slow so here's a lot of this stuff in there contact information that's what office they're in and you know their address and stuff like that this is where the manager field gets set but it definitely don't have see an ad when you're directly in Active Directory actually have a whole tab that has like extra information like their birthday and stuff if I go to Azure Active Directory users that's not my real phone number but that is my real birthday so you can send me a present okay so here's their profile in Azure Active Directory let's see all users I'll go to mine identity so it's got a lot of the same stuff I just don't see yeah I just don't see that particular that particular set of information interesting well yeah good to know Oh minors and consent that that's interesting to then we've also got the SharePoint profile go to SharePoint alright and then so we've got they actually notice that they they have this classic features thing now which remember a couple of weeks ago when I did the beginning SharePoint administration sort of theme for Power Hour and I went over everything in here this didn't exist then so that they've actually added that screen now takes you to all these specific classic features so here the user properties and profiles in the SharePoint profiles now these should be all combined to be one thing though like the azure one exchange and the one in the users list in in office 365 so it should all automatically sort of be synchronised together but apparently the birthday and the anniversary got left out that's so this one is this is really old-school right this is not something that people would ever go to nowadays so that's all my stuff that I filled in in my profile so here's my birthday yeah and that's all that other stuff that you know when people go and modify my profile that's that's where it is it's just not making it over to anyway okay so then another thing you could do in in this directory is like instead of having that list of people as your directory you could do that SharePoint list now you could create a whole new app for that you don't have to use like all this stuff that they have built in but they have you know this sort of interface is already there for you could kind of tweak it if you wanted to I've got it where's my list I lost it oh here it is that's the site that I'm going to and then my the one called directory notice again it's a I created as a contact list just because I was lazy and didn't want to create all those fields so it's not listed here because it's not a custom list so I'll just do directory like that alright so now I've got my directory and let me just copy this whole people screen and actually let me just create a new one so I'll just do another new screen and do people and then instead of showing in this gallery instead of showing the person somebody's searching for let me make it appear it's going to show from that SharePoint list so for items here if this blank I still want to do if it's blank I just don't want to do office 365 users anymore I'll do my directory other if it's blank if it's not blank basically show the directory okay so this is the whole directory so now but all the fields are now called something different so it just kind of randomly picked some fields to show in here so I can do like let's display name a full name so that's gonna be full name and then so now see now it shows the full names and then that is all confused the button the on select is now all confused because it's you know was based on that collection that it was doing so now we've got the email address field which is in here somewhere let's see the subtitle with this item dot email email address see so now we're kind of getting somewhere and then it also has I'm not collecting that person's photo in in that SharePoint list but I still could reference the image in a similar way I would just have to I don't really have time to tweak their code but I would just go reference the way they did it in the other one so then now I've got my whole list here and I actually don't even have to search for it I can just show this whole list of people and filter it by department and just say I could just say items directory filter directory where Department equals ITA or something like that and there we go so now I have a filtered list of just IT people which I couldn't do with the office 365 users one so this is something that you could have one app and have a drop-down box maybe and that lets you pick the department and have it filtered by according to what they pick in the drop-down box or have a screen in your app that says you know the birthdays today and have it filtered so even if you just have this SharePoint list in a single place in you know just one SharePoint list in your whole environment that you're basing this power app off of as long as you give everybody read access to that SharePoint list you can display this power app anywhere using the power app web part just display it on any in anywhere in your environment and just use that same one list so yeah any last questions about this concept pretty interesting I don't think it's anybody's birthdays today but I could say like birthday birthday is not a date field hmm it seemed to be a date field because when I picked it in the flow Eileen when I was in the flow and I was filling in this birthday noticed that it only showed me said this is a date field and share point it only lets me pick from things that are date fields from this array over here so it I think it knows that they're both date fields that it's structured like a date cool all right and why'd you all liked it oh and also we have I have a we did a whole other Power Hour about this but this is something that could be tied in to the whole directory concept is the org chart so this is a power apps org chart that I have that is for sale but that in the link link in the chat window too and it's just an app that we've already built that you could buy and download and then have all this and so you could have your directory list of people and then when you click on a person maybe you could have it take them to take you to this screen that's got more details and the whole org tree-like based on that person so you can kind of add on to that too but that is also available I'll flip back over here all right thanks everybody for coming that was a that was a fun one not not as many technical issues as last time she loses what about the email and meeting menu well you yeah you would just add those to it yeah well you'd have to collect those so what it's doing Shelley is it's collecting them as you click on people it's putting them in this collection oops you could add you can keep that concept but you'd have to just collect them into that same collection that it's doing when you pick people over here so I'll click click somebody and it adds into the collection and then I click somebody else and it adds into the collection so you would you would make your on select you can make it also do that and so this collection is called my people and that's where it's putting those people so then it's using the my people collection when it's you know when you go to the other screens they're all referencing that same my people collection so you would just have to kind of make sure you're using a similar structure and don't get it all confused but oh yeah tonight yeah it's show you what I was just saying so it's when I click on the people to select them I go collections and it's this my people collection so that's where it's putting them so you could add that that collect function that it's doing just out of the box in that template you could use that same syntax for your own and you keep using that concept it's just going to have different fields when it collects them so pay attention to the different structure or collect them and like a more manual way by doing a collect inputting each field inside of your collect and populating them in using that exact same structure that they already have so yeah enough bandwidth to go over all that in the in this power hour but as long as you can kind of you know know your way around power apps and tap into what they're doing in there you can you'll be able to figure it out we also also have another live power-ups and flow online class coming up in September it's five days it's advanced three days advanced power apps and two days of advanced flow and so that is also out on item intercom check it out and I will see you all next week thanks for coming over and out

Channel: Laura Rogers

Views: 14,346

Rating: 5 out of 5

Keywords: SharePoint, Office 365, PowerApps

Id: _KRKwAAZoao

Length: 61min 44sec (3704 seconds)

Published: Wed Jul 17 2019