SharePoint Power Hour: PowerApps Form Control

Video Statistics and Information

Video
Captions Word Cloud
Reddit Comments
Captions
[Music] hello everybody and welcome to power our I'm Laura Rogers and Joelle is taking care of some family things today she's not here I might have her you know do a cool demo on Power Hour soon she's figured out a really cool thing with flow just yesterday for one of our projects we've been working on but it's just me today and if you've never been to Power Hour before this is our weekly show we do Wednesdays at 11:00 I've been doing it for six years and it's a I'm not a programmer I don't write code so we just cover all topics with office 365 and SharePoint that are fairly no code and geared towards more business users and site managers so today's topic I sent out I have a newsletter and I sent out an email yesterday asking for everybody to vote so we are we're going to cover what you voted on the concept of just power apps the form control and some things that we can do in there now we already did have a whole other power hour about form logic like making things you know disappear and reappear and doing things according to conditions and logic so but this one's not really going to be the exact same thing it's going to be more just dealing with the form control and some common things that I've been I've been dealing with one that I've been working on for a project lately that's a really long paper form that's like pages and pages of a paper form like a word document that so I've been buried in power apps and dealing with all these little weird nuance and little tips and tricks with form controls so that's what I'm focusing on is just kind of dealing with the form control and just kind of it I was under the impression Microsoft was going to improve a few things in the last few months or so but nothing like that has rolled out as far as better things we can do with the form control so I'm just going to go with it and go do my tips for that all right so fun thing about having power our live is that we have this fun chat window in slack where we discuss things and ask questions all during power hours so hi everybody head over to the little power our channel and slack and roll call and I'll go ahead and get started so make sure my screen okay this is a SharePoint site it is a generic SharePoint list just a custom list and I just called it request form and I just created a bunch of just generic just different types of columns some text fields and some yes/no fields and choice fields and things like that and just really just think of it as a generic just any kind of request form and we'll go through just some of the trials and tribulations of what we're doing in power apps with that so I will see I might be adding more later but you know we'll see alright go back to the list so this is I have not customized this with power apps yet this is this just the generic form so one thing I can do is I can hit customize forms and customize this with power apps and this it this customizes my list for the whole blog posts just a few weeks ago about basically I have a sort of some pet peeves with customized lists I don't like them I don't use them I don't customized list forms but there's this big misconception so and so people say well people think that customizing a list form is the only way to customize a SharePoint list with power apps but that's not true so I was just going to kind of go over how to not do this so when I customized a list form and this one I actually had customized before so apparently I even though I clicked to delete it before it's and I changed a few things it's all confused now but so this is a customized list form and all you get when you customize a list form and I swear I had deleted this right before I started I deleted the original actually i'ma show you where to do that so I'm going to show you where to delete because I might have I might have clicked to not use the custom list form and then forgotten to click to delete it so I go to form settings and I do use the shirt default SharePoint form I have to remember to click see it was like this with power apps and I switched it back to the default SharePoint form and then I forgot to click delete custom form for the power apps y'all just ignore that InfoPath stuff like just don't do that ok so now it's back to SharePoint form and the other thing that I've been doing the power EPS is deleted so we're starting from scratch so I go and customize my form and it's doing this all over and then it's so just the main benefit of customizing this form is then when people go to the list the default form they're using but I wrote a whole blog post about how you can just not do that and just not have people go to the list and all the different ways you can lock it down so that you're not people aren't using the list and going to it directly and also you can just you have to give him permission to list but you can just create a whole site that's got lists like this for you know your business your whatever your forms are you don't even have to give people the users access to the site at all you can just give them access to just the lists just give them contribute access to the list don't give them site permissions and that will like no one will be navigating to the site if you do it that way so that's just just another tip so when I customized a list form just by clicking the customize list form directly from the list this is what I get I get one screen called form screen and I get one form called SharePoint form one this is the form control this is just a control in the list of all the controls that I can add to my form this is this thing so and that so that's that's your out of the box once you when you click customize list for him so I don't ever do this I'm going to go back to SharePoint and I'm gonna go back to I'm just gonna go to web power-ups comm and that's where I usually go or you can click the little tile especially if your government tenant you're not gonna head it's not web power-ups or comets like gov web power-ups comm or something so if you just go to the power apps icon in the tile here that's how you can get to the Manion power app screen and government and tenants don't have the customized list form yet but that doesn't matter you can still do this well I don't know what your licensing levels are that's gonna make a difference but you can still get there all right so I usually go here and I just do create a new app this way I want to point out you all should try this these power apps training apps it's a whole app that is built just to talk to walk you through doing things in power-ups it's pretty cool so I'm just gonna do a canvas app from blank everything I do is canvas apps that's another misconception a thing that people are confused about model-driven apps are a completely different things so it's Dynamics CRM that's like old-school dynamic microsoft dynamics dynamics 365 that is nut has nothing to do with canvas apps there are two completely different things I don't even think they should both be called power-ups at all canvas apps is what we're dealing with all right and the the other ones the model-driven that's the ones that actually have that all the cost all the licensing changes they've made lately the per app and per user and all that stuff that's all for those that's not for the canvas apps on SharePoint you need a link to the blog post let's see can somebody post that I just posted it it's Wonder Laura com I just wrote it like a few weeks ago I'm gonna do so I'm gonna do generic request form I already created application whatever okay so I'll just do a new one so this one this is what I usually do is I usually start from here they're just a lot of benefits that I list and that another blog post that I wrote called can't called standalone apps versus customized list forms and that's where I go over the differences and then my other blog post is how you can make use of these standalone apps and lock down kind of the SharePoint lists and not have people go there just depends on your requirements and what you're trying to accomplish I mean if you're just doing pretty something pretty simple that's just a real quick like changing a few colors or something it's perfectly fine to just customize your list form it's just you know get away the benefits so here now I'm in a blank canvas app and I go to data sources and this is where I add SharePoint already have SharePoint in here I don't need to add it multiple times I don't need to have multiple connections called SharePoint in here I already have one so I'll just pick that and then I'm going to go to my demo site and pick my request form list if you have a list that's not created as a custom list or it's one of the other created from one of the other templates that you don't see it here you can just type the name of it here so I'm gonna go to my quest form so now I have my request form has been added and I can now I still have a blank screen this is where I can insert my form control and connect it to my data and then this is taking me to the screen that I get to when I first customize a list form where it's having me fill out it lets me pick all my fields so that's where we are now so this is where I can see all my fields that it's automatically added to my form I can remove them so I can either let me go ahead and just make this bigger I can either remove them by like clicking on it and hitting delete I can delete them that way or I can go back to edit fields and I can remove them from here either way and I can also rearrange them over here so all right so here so it's put my it's put columns 3 so you can see that it kind of put two columns back to three columns and it just adjusts all these these are all the cards so it suggested all my cards to three columns and you know kind of when you're looking at when you've got like a paper form like these ones I've been dealing with where with people just you know they've got them kind of lined up already and they need them to look in a certain way then you're gonna probably have you know three fields here and maybe two fields on the next row and maybe have one that needs to be wider so you're gonna they're going to need a very write so before I go any further I want you need to add a new button because when I try and preview this and try it out there's nothing on here unless I then the new form command to it so I'll go ahead and stick a button at the top now a lot of times this is going to be just on another page you're gonna have like a welcome page and a button that says to fill out a new form but I'm just gonna stick this on on this page and click new and then it really helps to rename your form control I just call it a request this is since this is my generic request but if you have a bunch of them all throughout your app then you definitely need to give them better names okay so then this power hour is about dealing with this mess and dealing with kind of moving things around and rearranging them and getting them kind of the way you want them to look and to kind of look more like your end users expect that particular form to look if you all experienced that where you know people need things to be lined up a certain way so I can just rearrange things like this by dragging them around but probably one of the first things you're going to do is first of all if you need to switch any of these to be a different type so let's see I've got this one's like a description this one's that these are all descriptions I'm going to add one I'm going to call it just like notes and that's going to be kind of one that you'd expect people would expect to be bigger towards the bottom of the form so I'm going to just go back to SharePoint and just add one called notes like that and make it multiple lines of text and plain text and then when I'm doing this then I need to go refresh it in here let's see mark says you get permission to list library the user doesn't have at least read access to the site where those is located you'll get errors creating saving new items when the list has certain fields like lookup or management oh well just avoid using lookup and managed metadata so yeah if you have those than that that would be something to watch out for yeah I haven't come across that and so I've done a couple of implemented a couple of these where the users don't necessarily have access to the site and I guess I just avoided all those those field types that you mentioned so that's that's good to note though mark thanks definitely test your apps all right okay so I went ahead and added a field so when I'm in the middle of designing my app and I had a field I have to go to my data source and refresh it so that'll recognize any changes that I make in the SharePoint list or fields that I add or remove I have to go refresh this while I'm working if it's still open while I'm working on it just so that it'll know what I added so now when I go edit fields and do add field it will have they're my notes that I can add so now it's added my notes to the end so now we're going to be customizing and break unlocking these cards but before you unlock the cards there are a couple of just easy things you can do in here that are just easier to do on this little pretty user interface than they are after you just slightly easier than they are after you've unlocked it so like this one is notes and I can do this little drop-down I can change it to edit multi-line text so that just makes it a little bit bigger and it gives it gets the setting on it that's got text mode multi-line so it does just a couple things for me automatically this one is okay I usually don't use a try to avoid using choice fields in SharePoint because in this case I'm not sending people to SharePoint they're not going to be going to the list they're not going to be doing quick at it so anything that's like a lookup or choice field any of those type of fields I just make them all text fields or like a choice field I could just make it a text field a lookup field even I'll just make it a number and just store a number in there just to avoid those more complex types of fields so this one I called it more options and I made it a text field in SharePoint because all it really needs to do is store the text of what option they choose but I'm going to have them do a drop-down box in here allowed values so I can switch this to be allowed values like this and then turns it into just quickly turns it into a drop-down box and then I can just hard code my values in here or I could even point it to another SharePoint list to pull in the values without having to have it be one of those complex types of fields all right so so those kind of things those just kind of little quick easy things like switching it to one of these other types are going to be things you can do before we start unlocking all the cards just to save a little bit of time and then like for more options I've I've switched it to be a drop-down but it's not going to have any options yet see it doesn't have anything in it yet because then it that's still something I have to manually do so just for the more options the real quick way of doing that is to go you have to unlock the card and go to this items thing and I can just type just put them these little brackets and then I have and that's the one of the first tips I'm going to show you is kind of how to deal with these so that doesn't automatically have whatever your first thing is listed on here you want them to have to pick something all right so when something's required in SharePoint it'll automatically have this little asterisk next to it when I'm doing these big long forms with like a hundred fields and I just I haven't basically I'm not making anything required in SharePoint in the less list settings I'm just going to control all of that here in the cards and and so that I can do maybe conditions and things like that on whether they're required and then not have to worry about having that setting on the list and in here in two different places so like and we kind of talked about the required setting property when we talked about the logic but when i unlock a card then i can go to the car-boot now I have the card selected not the control inside of the card so required is a property on the card so I'm just going to make them all if I want to I can just put true here and then that way see the asterisk immediately shows up when I do that so then I can just make basically just unlock each card and set required on here and that's just another little tip now another thing we're gonna do is be is we're going to be realigning things so I usually just go to let's see I've got to select my whole form control and you're right Lisa I just let those end-users test it that's fine yeah and I can turn off the snap two columns and that will let me you have more freeform control over things now watch this did you see what happened does that happen to you all I try to drag this card to expand it and the whole cart completely disappeared that is so annoying and it's it's a bug I mean it's been doing that for a while though with the cards just as soon as you try and grab the edge of it and expand it the whole card disappears the width goes down to nothing and it disappears and it's gone you have to click undo to get it back so what I usually do is I get I turn off the snap two columns kind of what once I've got them sort of in the general area that I want them and I am going to be unlocking all these cards I'm just go ahead and unlock them all now I also wrote a post about a blog post about forms that go across multiple screens like if you have you know a hundred different fields like this on that piece of paper one I just showed you and you're having people click next and go to across multiple screens about how to configure that how to make that work so that one's already unlocked I'll unlock that one so then let's try so you can also drag them around so obtain budget approval let me drag it down here so notice the width the width will kind of be weird when you start doing that so look I try to drag in and it's still shrunk down to nothing move it down there and then I'll take sponsor yeah wouldn't it be nice if you could lock unlock all of them at once Pam you're so right there are a lot of things it wouldn't it be nice to be do to do across all the cards at once a lot of things I think that's something that they announced that they were working on but it you can't even select multiple cards at once or anything like that so it's not doesn't appear to be something that they've fixed yet so you can see I can kind of drag things around if you look at the advanced properties of these you've got the X is this isn't in pixels so usually everything you deal with in here like x and y are in pixels but in the cards the x and y are not pixels they are like the row number and the column number so like I don't know why X says negative 2 so that seems kind of maybe that's what one of the buggy things about it is that it's putting negatives in those C so that's the X is gonna be the order across the page and then Y it's going to be the order down the page so this is it starts with 0 so this is on row the first row so it starts with 0 what happens if I just move that down there see now it's X 2 so 0 1 2 out with 0 1 2 and then Y is 0 1 2 3 still sits as a 4 there so that's out of whack 2 so I'm going to go like what if I just change this to X is 0 then it moves it over and then put Y is 0 then it changed puts it back up here okay so I've moved a couple of those over and then I want to move my obtained budget approval down and I want to make my sponsor I want to make it wider and it keeps doing that let me go to the width that's one thing you can do look have you ever seen numbers do like this before to where it'll just a type of 500 and it just like it doesn't recognize it just thinks that I typed a 5 in here um let's see art says does lock apply to all properties that lock is really just letting you know you're unlocking it really just letting you know that you're configuring that you're customizing it configuring it out of kind of what it was out of the box if you unlock one of these and you mess it up and you break it you can always just delete the whole card and and just add it back and just add that field back so yeah in so Terry the X&Y it that so the x and y of the card is not the X&Y inside the car but there is an x and y inside of the cart so the controls inside of the card have the X is just relative to where it is inside that card you're right so I found that when this happens this is a really weird one too my little workaround is watch it I'll do like 500 plus and I put math in there and all of a sudden it it fixes it and then it's back to or not so that's just an odd one so that's just kind of a way that I found to work around that let's see I've got obtained budget budget approval here let's see I got priority over here and then um obtained budget approval needs to be here up one there we go see a little gray thing that shows kind of right as I'm dropping it down they up there there we go and then it puts it way over here so it's like it's it is once you start doing this and your form needs to look a certain way it is pretty time-consuming it's kind of annoying so let's see this one is needs to go in front of that one and every time still these are every time I try to drag the width they're still just completely disappearing so if you're coming across this this is not you this is buggy that was one of the main things I wouldn't do convey yeah so the X&Y inside of the card is here like I'm clicked on this drop down inside of this card and it's automatically going to have a width of the parent width which is the card minus 60 and then it's X is 30 that's 30 pixels inside of this card bye-bye its Y which is relative here to the card that it's inside so a lot of that is out of the box that's going to have little relative settings in here relating to the card that it's inside so um my priority card I'm going to change see I made a little wider and then it still does that okay so tame budget approval I have obtained budget approval description I'm just fighting to make obtained budget approval wider and it's disappearing to hold on we see there is a point where I feel like it you mess with it so much that it kind of releases and lets go and stops doing this on your form but I feel like you have to there are a lot of just working in it and changes you have to make just before it kind of gets to that point so okay something undo now another setting is wit fit so I can with fit is where it's going to expand across so it's this row already has two other fields inside of it so it's only expanding to like this whole row is now they're all filling up the width of it but me see if I can move this oh yeah let me move it okay and then this one seed since it's got wit fit it's just filling in all the empty space between it and this other card like that and then so if they choose let's see I want this to be over here though so I want this to be a little narrower so let me just go change the width to like I'm gonna change the width to I want to change this ones width and I'll show you kind of some way of doing like sections and stuff like that now make it wider 800 there see I want it to be like when they change this to yes I want this to appear so that kind of goes back to some of the logic so I want them to change this to yes so right now it says off so the toggles when you're dealing with yes/no fields by default they're gonna say off and on but I have to unlock the card to be able to change this to no and true text is gonna be yes so you have to manually go into each one of these instead of off and on change it to knowing yes so now it's not showing oh there it is oh the font is covering it up see it's like behind there so let's see what that one is doing um show label true true fill and yeah so one of these little Phil Phil's is covering up the word yes let me just expand that out a little bit see I'm going to change it to when I click and this is selected it's still covering up shut up either way and do that so I'm going to mess with that in a minute so another thing I common thing that we do is do little sections right so the way you do a section is to stick a that's gonna make the form look really nice to it like to have these little sort of segments to kind of break the form up a little bit so I stick a rectangle in here and I want the rectangles X is going to be 0 and why it's gonna be 0 and then its height is gonna be like two so now I've got this little small short thing but then for the width I just want it to be whatever width the card is that it's in so parent with so now it expands out so now this is getting close so then I can take this little rectangle how do I get to again I want to select that it's really tiny and I'll just rename it and called it tingle divider or something and then I'm going to copy that and just go to this other card now the card has to be unlocked before I can paste this in here that's a mistake I make sometimes so I'll just go paste it in there now when I paste something anywhere pretty much it resets the X and the y 240 which is really annoying so what I'm going to do is change my X to be have it go look at the divider and have it go get the X of that original that first one and then the same thing with the Y that way I don't have to go fix these every time I paste them in there so then see I can now I've got this line going across and so the second one that I've got the references I can have like the color referencing the first divider and all these different properties referencing that first divider so then now when I copy that second one and paste it to other places in my app now it's just automatically putting at the top so then I can just go paste paste and it's just pasting a line across the top of all of them so then what I want to happen is when I don't I want this second field over here to only appear when this is yes but I want it when they change this to no I want this to go away so I'm going to do that's some of the logic that we talked about last time and I'll just use my visible property of this one but it's going to help to have a good name for this one this little toggle so I'll call it T G budget like that so because it just helps whenever you're using these in formulas to just have a good name for it so just go this whole card the second one and the visible is now these toggle fields are just bully ins so the value of this toggle field is just true or false but guess what the visible property is just true or false so notice that since I had that that width fit so look at this this thing is going all the way across the screen so since I have the widt fit to true it's stretching all the way across the screen even when that other one disappears so then this second field I want them maybe if for the required property if that toggle is true then I also want it to be required so then change it to no and yes and that appears and it's required nice you like that and you like the the lines across it so then if you want the lines to go all the way across you're gonna need to use that width fit thing so that it will fill it so we'll stretch all the way to the end all right and then this is board policy update so this one's me see if I can move this down here so that one doesn't I didn't put a little rectangle in that one so let me go grab the rectangle for these other ones and just paste it in here and then board policy update up see no I tried to expand the width in it now I want this the width of this one to be C I don't want this to roll up see I moved it I had moved it down and then when I moved one another one out of the way this one just rolled right back up to be after this other one so I can make want you know something else you know stretch all the way to the end I can actually just go change this y23 oh it changed itself to look at that change itself to zero that is weird there and I want the X to be zero zero one - I want the Y to be - so that's how you can kind of control where things are on here let's see it's kind of jumping up and down it's all out of whack let me see so you want to move it there then it jumps all the way up so let me see if I can make this one a little wider and then I'll take like this other I could take one and make it stretch all the way across so this is like my life for the past few weeks a couple of weeks like working on this form okay so when I made this have a width fit then it's not that other one's not going to roll back up to that so this looks the way I want it and then the board policy update is here move these out of the way and then this one I want its width to be the same as this one so this is obtained budget approval data card so the width I'll just see if I can make it a tame budget approval data card got width and then so now see it matches and see now this width is just going to line up with this width alright so then this one again I have to manually go in here and change the true text to yes-and-no instead of on and off which is annoying alright so so I could do that same concept of taking this little divider and copying it and just pasting it and for one I have just lines across every single row I can just paste it to every single card but sometimes you want to have just like little sections on the page another thing that I do when okay so this more options field this is a text field in SharePoint remember I just kind of made it a drop-down and just type these options in it but when someone is filling this form out I don't want this to be the default so I'm going to put pick one I'm gonna put pick one as the first thing in here so now they have pick one but when they submit this to SharePoint I don't want it putting the word pick one in the SharePoint list right so another thing about cards that's really useful is they have this update property and the update property is important on a card because that is what the data is that it sends to SharePoint when someone clicks submit that tells it what data from what control it's getting and sending to SharePoint so this little drop-down is called data card value 20 I'm just going to rename it I'll call it DRP more options so this card when someone submits this to SharePoint it's sending whatever's in the more options drop-down box all right so I don't want it to send if it says pick one so here's my little trick is I'm going to say if this selected value is not equal to pick one then then send that value so if someone's filling this form out and it just says pick one and they haven't picked anything and they hit submit it's not going to send this pick one yell like that does that make sense I'm going to show you again so update is always what it's sending to SharePoint so for example if I have let's see my priority so priority I want this to be radio buttons I don't want this to be a drop-down box and it automatically is getting the choices from SharePoint so this items field of what you know what the options are for the priority it's getting that from SharePoint so maybe I do have a drop-down I don't want to mess with I just want it to be a choice field from SharePoint I don't want to make it a text field that's possible so let me just grab this value here and copy that and then I can delete my drop-down box but see now it's broken it's that update field it's the update field and it's another one that's got that's looking for like the width of it or something so it's just confused now the card doesn't know what data to send a SharePoint but as long as the cards unlocked I can go insert some radio buttons in here so then for the items property in the radio button that's where I can put just my choices from SharePoint so you see that I can also make it my radio box it's got my line yeah my alignment but it's got the horizontal versus vertical yeah layout so if I want them to go across I can go horizontal like that and then I just have to make this wider so then this is gonna be it stupid you make it a little wider so that it fits 320 mm it's still not stretched across there hold on my card properties art says pick one can't be a selectable value right but it's gonna be there first before yeah I don't want them to click pick one and then submit the form I don't want it putting the words pick one in in SharePoint now if this field is required that's then it's automatically going to since it's not sending any data to SharePoint when I click when pic 1 is selected here it's automatically gonna give a validation area error if it's required because it's nuts when I click Submit it's not sending anything chances gonna show how to resolve power-ups forms accessibility label errors yeah we'll look at that so let me go back to let me select this card again and just go 400 still not stretched all the way across make this one a little more narrow it's such a pain so that one's still not there we go okay so then I can make like this a little shorter maybe no anyway okay so now the priority is a radio button instead of a drop-down box and I but I haven't tied it to see any of these errors I still haven't tied that to to send that data to SharePoint because that's the important part so I'm going to call it our do priority just because it's a radio button and then I go to the error here and the update has got an error so I'm going to say I want this to be our do but I already got selected dot value maybe it doesn't want the dog value okay and then this other error is it's still looking for the width so the Y of the card this card property is looking for the width of the control inside of it so that's where it's just lost because I deleted the data card value to which was the drop down box so I'll just put I can just put the RTO priority in both of these if I so choose and then the error goes away data cards don't have a hint text property but text boxes do so like text box like type your notes see there's my hint text here but I do have a I don't have hint text for a drop down but I do have a tooltip so instead of having the tooltip be the parent display name which is just the name of the SharePoint field I can just have the tooltip be pick oops pick your option and just so just like in other form products like an info path too you can easily spend hours of your life doing all these little tweaks to customize it once you've just you know dropped in and out of the box of warm control so it that's that's just one you know that's to be expected all right so that's the hint text and then was the other thing I was going to say is the his hint text thing reminded me of it oh okay so I have a SharePoint list where that there it's like again it's like a hundred fields and I have a feeling that the business users are going to want to easily be able to maybe change some field names because there's a lot and they're there some that have like really long like questions and things like that so when you first plot this form control on here it has this like this title here so this title this thing right here is a it is just a label let's see where's this one called data card key something so that's just a label and it's showing the parent display name well the parent is the card here so the card has got the display name now when I first put the form control on here it's automatically just gonna grab whatever the display name is of that field from SharePoint and this is the system name from SharePoint so if I change the name and SharePoint the name of the column later since this is not dynamic it just put itself in quotes here it's not automatically going to change what's listed here so if you want your list column names to always stay up to date and change in your cards sometimes you might not sometimes you just want to go type in here and just type the names of them all just in the cards but if you want them to stay synchronized then so here's the trick so I'm gonna go change this more options one and I'm going to call it something else so I'll go to my list settings and I'm just gonna change the name of something so let's put the word test on here so even when I go refresh mm-hmm it's and this was kind of odd to makes it I thought maybe I didn't refresh it well enough or something this first happened and when I hit refresh it didn't change my name but that is that so there were a few power hours ago we talked about the data source info it's setting in here that's the data source info so for the text the display name now this control inside of here this thing is using its referring to its parent so it's looking to its parent for the display name oh sorry this thing it's looking to the parent so I'm just going to go to the parent and make this change so display name I'm gonna use the data source info data source info I have to tell it what data source it is and this is the name of my list request form so it's kind of a pain and then what do I want to get from SharePoint I want the display name and then what field do I want to display name of it doesn't know what field it's in that's kind of annoying so to get the display the field that's this thing I need the system name right here so paste that in there in quotes so now let's see now it says see now it says more options tests and now it updated itself so that's the that's the data source info dot display name which is getting the display name from SharePoint um let's see so you're asking about accessibility error so the accessibility errors are like missing accessible label so accessible label is this is the label that it's going to show when people who have I guess any kind of disabilities are using like special you know large text or disability like settings and their browser their computer this is the label it's going to show for the accessible label so accessible labels not always something everyone's going to see but that's like data card value one that's on data card value one which is my little text box in here and I can make the accessible label equal the data card value 1 dot hint text in that way just I could just type something in here but I could make it equal whatever's in the hint X so it's just saying that for accessibility for people with accessibility problem if you have people in your organization that you know that you expect we'll be using this app and you need to address all the accessibility issues then you would go through every single one of those and fix the accessible label it I mean it's not always required that you do that though so this is just suggesting that I revise my screen name because screen one isn't a good screen I usually give it like screen welcome or something like that so that's just a suggestion but accessibility is not gonna it's not errors it's not going to be a problem with your app all right um let's see what else what other kind of little trials and tribulations do all have with dealing with these you can do what so you can do a a border around the whole card but then that just wouldn't give you the lines just like division lines through your like sections in your app if you want it to but I thought that was a good little tip with the being able to do the width fit and then that way even when it's set to no this card is still going all the way across and that way the little line will show all the way across and then dealing with the dropdowns to remember what else it was with a drop-down that I was I was going to mention any other questions Oh art says if you wanted them to force them to pick one and then that would be if it was required so true so if that was required is true so now this is true so let's add a submit button here another thing I do sometimes with the submit button let me just get rid of this is I will go into whatever the very last thing is the last card and I'll just like add an extra space down here and stick the submit button inside of the last card that way if your form ever Scrolls down down the page then the submit button will just stay with the form and also if you have any kind of logic that hides and shows the form like if the form itself you have is like a little small pop-up then that logic would just apply the button would just go with it and you wouldn't have to worry about doing separate logic on the button so I'll just say submit and then on select submit form a request form I'll go preview it so I already did a new form so what happens when I click Submit so it needs a title it needs a sponsor because remember this isn't the only one that was required in SharePoint was this title and I made these other ones required just with rules and just by using that required property so remember that this one is when I click that remember the update property so since in the update property it is only sending data to SharePoint if the currently selected value is not pick one so therefore I'm just getting a regular old validation error if I don't pick an option so now I go submit it and of course I didn't do anything any actions after the submit so now it's just gone but I could do let's do a new form okay so let's go look at SharePoint we got to wrap up in a second so now this is the one that I just created and so this is just the sheer default SharePoint form because I didn't customize the SharePoint form but see now the more options test is just it says for option first option that was the text that I selected from the drop-down box and the priority says normal that's the radio button I had selected so then when I go so then you're concerned about what is going to show later when I go edit that same item so after I submit I don't ever put anything after don't ever put anything after submit form right here because you wanted to make sure that it's submit successfully you want them to be able to fill out any fields that were required any errors they have so go to onsuccess and that's where you do your stuff that you want to happen afterwards so I'll set a bear record to whatever f:r whatever I last submitted so I can set this variable so that I have a data of whatever I last submitted and then I could just go to the item property and have that be my variable selected record okay let's try doing another one let me reset this so that's weird I thought I had I thought this was a new button whatever new form okay so let's see submit and so I had it I didn't have it navigating anywhere after I submit it so let's go see if this another one is in SharePoint yeah there it is so and then the value is third one so now notice that this is showing the one that I the last one that I am the thing that I picked so if I I've only got like it's time to stop but next time I go to this forum and I go to this particular item it is still going to show the text of the thing that I picked in it when I filled it out so I mean it still works um that answer your questions Terry says sometimes read for me said doesn't clear everything hmm no I don't think I've seen that happen that's weird is it putting like default values in some of the fields or something hmm anyway I think I got think I've got care took care of all your questions I'm kind of scrolling through but some of the main things I wanted to show you where the you know the ability to do the lines across and just some of the common things with drop-down boxes and I wrote a whole blog post about the validation stuff this stuff so I'll put that link in here and that's going to have some similar concepts in it too about how to do the pattern validation which I can just show you one real quick so like this one I can say it's gonna be is is match so I can say is match like this one I want it to be like two digits or something like that so I'm just going to do this on the fill color just to keep it super basic so like fill color if if is match and then that is this this text box which is called Hadley names dot text if is match and I'll just put digit like two digits you see oh yeah ampersand sorry not a plus did you did you did you did you then then I want it to be that caught then I want it to be the color that it was already otherwise I want to be red I gotta close my parentheses so if it matches this pattern digit digit it's just gonna be fine it's gonna be normal color otherwise it's gonna be red so now automatically it's red so I can go like four-four and then it goes away so that's like the basics of see it just doesn't match so I'm just doing it with a fill color just so you can see that you can use that logic but in the blog post I talked you through doing it with the like the required property and with you can do it with you know the border color whatever you want and you can make it so it's tied in with the form validation by using that update properties so yeah now when I also wrote another blog post about how to do tabs a tab form so you could just have one big form let's see tab SharePoint form with one one screen and not have to have a bunch of different screens the one I'm dealing with has who it's got feels to fill out fields to fill out a sub table with like child items another sub table some more fields to fill out another sub K let's go like eight sub tables and all these so it's like you couldn't there's no way that you'd be able to put it on one screen because you can't put a little child sub tables like inside of a form control or anything so I'm gonna go back to the grind of building my form and all the logic so thanks everybody for coming and again go to the ideas Channel and I'll kind of see if I can send out another poll next week to get your ideas I'll see if I can get that team's template thing the downloadable one working but it's really complicated so I'm not sure if that's the best topic for power to get you this is a lot of azor stuff that I don't really know what I'm doing and there I have no idea how to troubleshoot it yeah so we'll do it we'll do it maybe we'll do a Power Hour about staying away from InfoPath and stop using it and figure out why y'all are still using it I think some people still over thanks everybody for coming over and out
Info
Channel: Laura Rogers
Views: 4,909
Rating: 5 out of 5
Keywords: SharePoint, Office 365, PowerApps
Id: pKDRKKCzjUg
Channel Id: undefined
Length: 64min 12sec (3852 seconds)
Published: Wed Aug 14 2019
Related Videos
Note
Please note that this website is currently a work in progress! Lots of interesting data and statistics to come.