Power Hour: Power Apps "Save & New" Button

[Music] hello everyone and welcome to power hour i'm laura rogers and this is joelle jobson here in the corner and this is a show we do on wednesdays at 11 central doing this for about eight years and we used to it used to just be called sharepoint power hour but with microsoft 365 everything in the cloud we have sharepoint we have powerapps power automate teams um all those different apps that you're dealing with in microsoft 365 and power hours gear geared towards more business users it's not usually super technical we're not programmers so um it's all kind of geared towards more of like a power user type level so we send out a newsletter the day before and everybody gets to vote out of three topics so you all voted this time for the concept in a power app when you have a powerapp form of creating a button that does save and new so in the scenario that you need your end users to be able to fill out a lot of forms and just quickly rapidly fill out forms all in a row you want to just instead of having to click save and then go click this new button and then start all over just a quick little save and new button in the in the form itself so that concept will i'm going to really kind of instead of just showing you that one little thing i'm going to show you why it does that first or why kind of the different settings are in such weird places first because it is the way to get this set up and working there are several different settings and several different controls in the power app so i'm going to demonstrate to you how just a form control works real quick first and but before i do that i'll show you what the end result looks like so i'll go ahead and share my screen and i have and by the way we're all in teams we're chatting that's the fun about having you know this as a a live online session is that we can you know ask questions and chat as we go so there's a link below this video that you're watching that you can request to join okay so here's a quick little demo that i set up to show you what this functionality is and i have just a a list in sharepoint it's an issue tracker it doesn't really matter what the list is but the idea is that we're going to be able to save versus do save and new so i'm just going to do a few just test items so i just i'm just filling out this form blah blah blah click save and it goes away like it always does and then i fill out another new one and blah blah blah i'm filling out this form real quick and do save a new so when i do save a new it just leaves the forum on the screen and it goes ahead and adds the item to the list but then it's it's ready for me to start filling out another thing here so i can fill out this form and do save a new again and i can do yet another one um and then i can just close this form of course at any point and i can just click save if i don't want to do another new one so that's the concept that i'm going to be demonstrating and the way you do this is pretty different depending on if you've got a customized list form like this one versus a standalone power app so for pedagogy sake before i start digging into all these little weird settings inside of this customized form and power app i want to show you just some quick basics about how the form control works so i've got just a blank screen and a power app and i have a sharepoint list that's called a time sheet and this is a an app that i have that i've done several demos on so it's got kind of a lot going on in it but this i just want to show you this on a blank screen so a form control i'll go ahead and just do an edit form it has a data source so i'll just make my data source be this timesheet and then um again it doesn't really matter what's on the form right now for this demo but what i'm gonna do is show you what it does by default when you are saving the form so first of all you have it needs to know what type of um mode that it needs to be in so if you have a new form you need to send the new form command and if you had it in edit form it needs to know which form you're editing and it needs to know um the edit form command so if like if i just preview this it doesn't know what to do yet i have to do this new form command so i'm going to create this button that does a new form and then i have to tell it what form it is so it's going to help to have a good name for this form frm test time is what i'm calling it so i say new form frm test time and then i'm previewing it and then that way now at least i know it's a new form but then someone's got to fill out the form and then someone needs to be able to submit it so then i create another button and all this stuff is built in like everything i'm showing you so far is built in when you customize a list form directly in sharepoint but i want you to understand the mechanics of how they work first so i'll just do a submit and then on select i want it to do the submit form and i tell it the name of that form okay so now what happens just by default i've got a new form i don't think i have any required fields in this uh list that i'm working in so i don't see any little asterisks next to any of these i'll just go click submit and see what happens so i submit it and it just goes away and it doesn't know i didn't tell it to do a new forum i didn't tell it anything else to do i didn't tell it to navigate anywhere but i just submitted it so when you're submitting a form if you want something else to happen after you submit the form you would tend to want to put it just right after the submit form say submit the form and then do something else but the best practice is to never put it here don't ever put what you want to happen next right next to it and i'll show you why so i'm going to go ahead and real quick make this description field required so i'm just going to say required true and this of course if it if it's required in sharepoint by default it will have a little asterisk next to it but i just manually made it required just in this form so if i make this required and i say submit and i'll just navigate somewhere else i'll just navigate to another screen on this in this app okay i'm filling out a new form description is required but i don't fill it in i just put some hours in here and fill out some other stuff but don't fill out the required field and i click submit look at that okay well so it makes me it kind of gives me an error a sort of vague error up there at the top and then the error goes away but it goes ahead and takes me to the other screen so it did not stop the end user from just from filling out all the required fields it just takes you it just navigates you away so you don't want that to happen which is why you don't want to put it here so usually um you you're going to be using usually always you're going to go to this form control and the form is called frm test time so go to the form control itself and i go to the on success property so on success means when the form is successfully submitted then what do you what do you want it to do and then you can have it navigate or you know just do whatever you know take them to a screen that says thank you or do any sort of notification across the top telling them thank you but whatever you want to do after they submit it you want to do it in the on success so therefore um in the on success um let me go make sure yeah i took it out of the submit button so now i do i'll just do another new form let me reset my form two before i do a new one just so you can see a new blank one and that's my reset form command okay reset it do a new one and then i'm not going to type in my my required field and then when i try to click submit it stays here because i'm not navigating it until after i make sure that it's successful does that make sense so far okay so then i if i put a description in here then it's all good and then it will submit it and then navigate me away whatever i wanted it to do afterwards so now with that said let's go to a sharepoint list and i'm just going to quickly create a new list so you can just see me doing this from scratch so i'm going to go to whatever this is work progress tracker template it doesn't really again it doesn't matter what the list is i'm going to go ahead and customize it in powerapps customize the form this is what the form looks like by default and i'm going to customize it in powerapps so that we can build these buttons so i'm customizing forms and this will take a second for it to spin up the power up so let me look over and see what we got going on any questions so far while it's generating i know it kind of went quickly through that part um but that was just kind of getting some basics out of the way to make sure we're all level set zach i'm glad you made it okay so my form it by default it doesn't put much on here so i can add some other fields to it just so there's so there's a little bit more to look at here okay and then another thing i like to do just in what i'm doing these customized list forms is i like to [Music] give it like a different orientation to make it have better take up more real estate on the page like that so you know that way you can rearrange your fields and make them you know have different columns and things like that so all right so here's my form and then what i want to do is add those two buttons so i'm going to go ahead and just one thing you can do if you have a form that scrolls that people are going to be scrolling down kind of a habit i like to get in is to go to just whatever the last card is on that form and actually put the buttons in that card so that your buttons aren't just sort of floating on top of your form so when people scroll the buttons actually are scrolling so i'll go ahead and go into this card and insert a button another button and that's going to be my save and my save and new okay so this let's let's look at what happens just by default with a customized list form notice that this form didn't even have any buttons on it it just by default it works fine without any buttons just um as a customized list form and sharepoint because it's got the little built-in buttons it's got the little built-in save and cancel those buttons at the top of the form so it works fine without any buttons being added to it but what i'm going to do is i want this one to kind of just do the same thing that that built-in one is going to do and this is one that's going to have the special functionality but let's look at what happens automatically by default with a customized list form when you go to sharepoint integration this little object on the left side you're not going to see anything on the properties by default when you go to advanced that's where you're going to see all these little built-in settings so this is something that doesn't exist when you have a standalone power app like the one i previously showed you so this tells you the these are based on the that sharepoint functionality that's built in so the on new that's the new button in the sharepoint list the on edit that's when someone clicks edit button in the sharepoint list to open up this item on view is when they just click to look at it on save that's that little default save button at the top in in sharepoint and on cancel that's the cancel button so these are all correlated with those buttons um let me move this out of the way okay so what i want to do is let's let's see what it does automatically so i mentioned that the uh that you don't want to do something right after you're doing the submit form so notice that their their built-in save button does the submit form action and then well how does the form go away after someone has clicked saved because when you're in you know a sharepoint list filling out a form and a power app and you click save the form goes away and then you know then you're just looking at the sharepoint list again so the trick is to go see what they're doing out of the box with the on success so the on success is where that magic happens that makes the form go away so it's doing that this is that reset form command that i mentioned a few minutes ago so it's always resetting the form and then request hide that is special just for customized list forms and that hides the form that's what's going to move it away to the side so this is important to know because when you're in a sharepoint list that's customized with power apps you're when you click the new button or when you're opening an item in there you're not running like the usual onstart that you have with a cust with a with a standalone canvas app the the app is already open so a lot of times when we're defining things that we want to happen on start in a power app and we put them in the onstart when you're dealing with a customized list form the onstart happens as soon as someone goes to the sharepoint list they haven't even opened a form or clicked new or anything so the app is opening behind the scenes it's hidden in the sharepoint list so that's why that control is called request hide because when someone's filling out the form and they're done the power app is still open it's still running it's just hiding so it's not going from screen to screen it's not running the onstart you can't necessarily rely on the on visible so you have to kind of understand that those these built-in functionalities and this request hide thing that's what's drastically different so that's why i wanted to show you that basic form submit functionality in the other in the canvas app before kind of getting into all this built-in weirdness with a customized list form so what we had a question what was that uh a good question um if so if they did the customized list form and say they had external users that didn't have licenses would they be able to access that form no is it uh carolyn asked is this useful when your users don't have licenses to power apps no so the answer would be do you remember and zach remembers because he was here i did a power hour about external users in power apps and we actually did that live in the power hour and zach let me use his email address and i invited him into my tenant and shared the you know shared a standalone powerapp with him and then also did it in a sharepoint list and he was able to use the form but he was using his microsoft 365 account from his tenant where he's already licensed for power apps in his tenant so if it's somebody that's like a gmail address or somebody that's not it's like not a microsoft 365 email there you actually have to apply your own licenses for them to be able to use it so yeah all right so our save button is just going to do the same thing that the um that the built-in save button is going to do so if i go to save i just want it to um submit the form submit form i am going to add a couple things in here but see my form is called sharepoint form 1 and i can tell that because i can see it's called that here so i'm going to submit the form now it's going to submit the form and as soon as it submits it it's going to the on success so i what i have to do is i still need to make sure that the form is successfully submitted so i can't just say submit form new form that's kind of like what you think would be the easiest way to do this i can't say submit form new form because they might not have filled out required fields it might not have been successful so what i'm doing before i do the new form i have to make sure that the form is successful so that therefore i'm going to go to the on success but i need i do need this button to do something slightly different so i'm going to create a variable and i'm going to call it just something really obvious ver save and new i'm going to call and i'm going to say true it's just going to be a boolean and then submit form so it's going to set a variable so then i've got this variable saved that's going to know if that one is one that needs to go ahead and open up a new form so that once the form is successful then it will know whether or not to create a new form so then i go ahead and go to the on success i select this form control go to the on success so this is what it has in here by default now i do want it to reset the form so i do want it to reset the form either way that just clears out all the fields and starts over so i'm going to leave that in there and let it do that first but then i'm going to say if there save and new now since this is a boolean variable it inherently just equals true or false then i don't need to say if varesave and nu equals true because the value of the variable is going to be true in this case so if their save and new then new form and then that's that same form otherwise request hide and there we go okay so this is the magic that gives that button a different functionality is that it's it's setting a variable and then therefore when the form is successfully submitted then it's looking at that variable now there are a couple of other things to do um if i just leave this like it is uh i'll just you know what i'm just going to go ahead and save it and publish it now and then show you a couple of things that i haven't done yet that i still need to add to make this work correctly so i'll go ahead and just say back to sharepoint save and publish okay so i'm going to notice that um it still has my sharepoint form because it's it's gonna need refreshing once or twice before i can get to this powerapp there we go and another another thing that i'm going to add is that it's really frustrating when you're dealing with a customized list form because after you've made changes and edited your form and then you open up here sometimes you're testing it and you don't realize that this form hasn't refreshed and it isn't the one that you just edited and published so another little tip that you can do is to add just a little number down at the bottom or just something that you change so you can visually be able to tell that that's the that's got the changes that you just did and i'll do that in a second okay so i'll do test blah blah blah and i'm not going to spend a bunch of time filling out fields but i'll go ahead and click save and then there's my item go ahead and do another new one save a new okay so then it see it cleared out the form and then i've got um another thing and i can do save and new and then i can keep filling out the form but um then if i click save see this is the problem this is what i haven't finished doing yet i click save and it's the variable is still set to true so i have to have a place or two in here where i set the variable back to false so that it will make sure that you know it's not always going to think that it's a save and new if i after i've done it once you don't want it to perpetually think that it's supposed to be save a new so let's go back to edit it that integrate button still throws me off i keep i still keep wanting to look for the powerapps button oh yeah pamela a good yeah what did carolyn say that she was profoundly disappointed about hopefully it was something that exists in the product and not something i did i think she's talking about the um not being able to access maybe from external users oh yeah okay so this is that little trick i was talking about i'll just do that real quick so i'll put a label and i'll just put it down here and just type a 2 in it because this is my little my second version the next time i edit i'll just change it to three just manually change it to three just so i can tell what's going on okay on the save button i'm going to set go ahead and just before i submit the form set my variable my verisavenew to false okay and then also there's that other place people could be clicking the save button at the very top of the form right so we can't forget about that one so we go to the sharepoint integration setting and then we have this on save down here so we want to do the same thing down here well let me just pull it up over here there's my there's a little shortcut i don't know if y'all know this when you click the actual words over here on the right it jumps straight to that formula up here in the formula bar it's a nice little quick tip set their save and new to false okay and then i don't know if i can stretch this one to an hour we'll see okay i'll go back to sharepoint save and publish oh yeah i did i have a whole other i forgot i have a whole other part of the demo that i put together okay and then when i go new let's see if it's got my new version of the form first come on power-ups okay it says three all right that's good i'll add another item category progress priority blah blah blah okay i'm gonna save that one it's fine go five save a new saving new seven i misspelled six um and then do save and look at that and that worked and then um the save button would do the same thing since i have the save button also resetting that variable back to false yay okay all right so hopefully that makes sense um so those were all the different spots where i had to go you know make a few little tweaks in that customized list form yep all right so now i've got my other my power app here that i was looking at a few minutes ago when i added this little screen down here and i want to show you in my task list screen now you're you might be a little overwhelmed by the screen but um i put a link in in case you're wondering what all this amazing coolness is i put a link in the um the resources little section i put on the post tab in teams with a link to the power hour that was about this it was um it was called powerapps conditional formatting galleries so the conditional formatting has nothing to do with what i'm about to show you but um anyway this is the nice little pretty gallery that we're going to be using okay so right now i have this new task and the form pops out on the right and i can open existing one and the form pops out on the right and again i built this in another power hour but what i want to do is and this is a standalone canvas app this is not a customized list form so i'm going to add the save a new concept to this form that i've already created so it helps when you're doing a um when you're working in a power app to go ahead and do something in preview mode that will open up the screen that you need to see so like create fill out the new as if you're filling out a new task and then go back out of preview so that then you have the form pulled up because other than that you're kind of flying blind and you're working on something that isn't even showing on the screen so let's look at my save button here and it helps i don't necessarily do this all the time in demos because i'm kind of going quickly but it helps to give these better names like btn save task and then i can add another button in here and notice that i put this button i didn't put this button inside of the form control it's just kind of floating above it and so if this form had more fields in it and you needed to scroll down it the button would just stay in this one spot it wouldn't scroll with the form so that's kind of the concept that i was pointing out a minute ago um okay so let's go ahead and insert a new label and i'll just not not a label sorry button and i'll just put it here and i'll say save a new and then this save button it actually has some special functionality because in this case because it's a canvas app i have the end users only going to the app and they're not going to sharepoint they're not interacting in the sharepoint list and everything they're doing is they're looking at the list of items here in the power app they're looking at the form in the power app so this is how they're getting around in everything so that's kind of my favorite way of building power apps is to not have the users go to sharepoint at all and only just do every powerapp as a standalone canvas app so that's the idea here is that they're just clicking on a task and since a task is sort of a short form we just put it right there on the same screen now this is going to vary because a lot of apps have really big forms so when you click the new form button you've got a whole screen that's just for the new form so for example i've got like for my projects this is my project screen so when they are filling out a new form the form is the whole screen so that's why i wanted to point out to you the concept of the on success because however you built your power app if the form is just popping up or if it's just static next to a list of something or if the form is by itself on its own screen it's important to understand the principles in making sure that it's whatever you're doing in the on success is really going to be the thing that makes the difference and you might have all you know all of you might have completely different things that you want to happen on success you might like i mentioned you might want to navigate you might want to do a notify you might have some sort of pop-up that says thank you so there are a lot of different ways that people have a sort of success concept in their forms so let's go back to the task list i just i like this one it's kind of pretty because it's just nice and concise and just pops up on the side but because it pops up on the side this is what i was getting at i've got again it's just a submit form on the already existing save button but when i select my form my frm task and i go to the on success this is when it's successful it's hiding the form so i'm submitting the form and then it's on success is just that the form goes away so i could do something like a really nice easy one is is called notify thanks for submitting and they have little color codes you can do if you want so if i um xyz just another concept of what you can do in the on success and then save that say thanks for submitting so you can put dynamic data in there whatever you want to do so now that's what the uh what that's what the on success is already doing so i need to go ahead and add that variable so i'm creating variables so on on select i want it to submit the form i'm just going to copy that and set the variable but i'm going to set the variable first set there save and new to true and then submit the form okay and then in the on success in addition to making the form go away and having a little notification then that's where we need to do that additional thing that looks to see if that variable is equal to true so um it's always going to do these two things now if you if you don't want it to well hold on let me just start writing my if statement if and then that's my verse even new that i just created that's a boolean if they're saving new then i'm going to do a new form of and that form is called frm task otherwise it the forum is going to pop up is going to go away and they're going to be notified now if i want them to be notified no matter what i can just take that notify out of there and just put it before the if statement so it's always going to tell them thank you for submitting but that might be kind of annoying if people are filling out a bunch of forms and this thing keeps coming across the top so you know it's kind of up to you if you want if you want that to happen okay let's try this out um let's see what do i have that hold on what do i have that little uh is this error oh look at that if they're saving new oh i didn't put look at that i didn't put my semicolon that's what the problem was okay i thought i saw an error there i want to make sure i caught that okay new task okay and then do save a new okay so see that's kind of annoying to have the thanks for submitting showing but at least it's letting me know that it has gone in so thanks for submitting and then i can do another one and waiting on someone priority and then save a new and yet another i'll do one more but what i didn't do i'd better do this before i try and click save what i didn't do is set the variable to false right because that's the additional step you want to make sure that it sets it back to false so that it doesn't just always stay true once someone has submitted the form click save and new so their save and new to false all right okay let's see any que anything um groundbreaking going on now i think some people might be having issues seeing the chat i don't know if there's just something going on with teams today oh yeah i think there is there is a little refresh button in teams i don't know if that's going to make a difference but i do think that something is going on in teams like you know because right before we got started the tabs were just shifting around before my very eyes so yeah i have no control over that but um i think yeah i mean that's that covers just all the concepts in the customized list form versus the canvas app and then you know when i was building this demo it made me think of the concept of save and copy or basically taking something that exists and doing copy and new is that something you've ever had people need oh look another thing that i did is i forgot to put the the on visible i forgot to change the visible property to have the same one as the other one so joella do you ever have a project that you're working on where people need to have take existing things and just quickly be able to copy them um not recently but i think i have in the past sure so i was trying to think through you know maybe that potentially being something that i could add on but then it depends on you know if people have that functionality it depends on where they want to be when they click the button do you want to have to go open an existing item and then click a button that says copy this to create a new one so i kind of got stuck on you know it being the functionality would vary greatly depending on how people wanted to go about that what do you all think um so kimberly though so she says that would be great but they copied a new but do you want people to have to go open an existing item the item that they want to copy to new and then click a button that says to copy it and then it just pulls up a new form that's got all the fields filled out just like the old one is that is that where you they would expect to go to be able to do that because i mean i can kind of show you some concepts and how that could be accomplished but i just kind of want to make sure that i'm addressing like the most common place people would expect to be able to do that like this task would i want a button just here on the row of the task that says copy to new and then a new form pops up or anyway so i can go ahead and try that since we've got 20 minutes left okay so i've got some projects so this is my main list of projects and when i click on a project it actually just goes to a completely different screen and i have a new project button too but do i want to i'll go ahead and just add a button next to each project so that i can quickly take everything that's in that project and it'll take me to a new form but it'll have it pre-populated with stuff about that project does that sound like a common ask okay so this is the part of power hour towards the end where i just kind of make something up and i don't know what's going to happen because i didn't pre-plan it okay so let's go to this gallery and i'll add a new button i'll just do like a little copy button let me see i like searching over here for the right icon there just put a copy button and then when i click that button that's going to take that project and and take me directly to a new form filled out with all the data from that project okay so on select i'm going to set i'm going to do a variable bear um now i think i i actually already have a variable of the record of the project itself so let me see what that is real quick their selected record yeah so i can just use my veriselected record anyway because um what i'm doing is i'm just taking this whole record the entire form in sharepoint and i'm just setting that entire thing into a variable so it's going to set the variable and then it's going to do a new form and where is it navigating for these other ones it's going to scr project form okay so new form form um frm projects navigate to scr project form yeah let me make sure that's the right um project form because i i've this is an app that i've got like i've got a whole bunch of different forms and things going on in here so i want to just make sure i'm going to the right one um frn projects yep okay okay so it's setting the variable doing the new form command and navigating but i also need to have an additional variable i need to know if i'm currently copying something to new so i'll say um set fair copy to new true all right so i'm going to take this second one right here and okay so i didn't do a reset form so let me go back one um because i think what it did was it it didn't necessarily run the thing that i clicked on it ran the on select for the whole row so there he caught bear copied a new true and yeah i need to do a reset form reset form [Music] i'm just kind of cramming all this in here huh it looks much nicer when you do format text and it makes it nice and neat like that okay so let me try that again let me get rid of the i think it's just doing the on select for the whole gallery when i'm doing that see it's not letting me do just that one button so i'm going to take this whole thing and just comment it out for now and yeah it's taking me to that item but it's not sending a new form command what what form am i on hold on it might be the wrong form oh yeah frm projects print is the one that it's taking me to okay so i have to be resetting the correct form so it's taking me to frm projects print but like i said i've got a whole bunch of different project forms in this app because it's a demo app okay so frn projects print i was just resetting the wrong form okay reset form projects print and this is actually one that i did i did a power hour um um probably a couple months ago about that print function so that's kind of what that was is working on the print taking a look at what you could do with the powerapps print function okay all right so this is a new form so i haven't told i've told it to set a variable and i've told it that i am going to be doing a new form but i haven't filled in the form yet so that's going to be very time consuming let me show you what that's going to entail so the project name um so every field you're going to have to tell it what data it needs to have in it by default now the project name you might want to leave that empty and not mess with that because you might want people to have to type a new project name for each each time they do this copied a new concept so we could just leave that one alone and not um you know not mess with that one but let me go ahead and just go to a really um simple one like hours planned and i'll go to the default property of this card and by default when when you're on a form control this is just got this property this item.hoursplan but what we're going to have to do in order to make it pre-populate with something from the thing that we clicked on to copy to new is that we're going to have to put a if statement in here if they're copied and new yeah they're copied to new if i am copying something to new then i want this box to equal their selected record dot and then this one is my hours hours planned otherwise just do what you're already going to do and show this item dot hours planned okay so look at that so you understand this concept so if let me shrink this down a little bit if there copied a new i'm going to dive delve into that variable that i just set and go find the hours planned field and default this box to the hours plan field that i just you know click copy to new next to otherwise just leave kind of what was already listed here so that's what you have to do for every field so let me go like to the project start and i i can copy this but it's going to be like very very different for every field it's just going to be a lot of work but it's still probably less work than people have to do filling a big form out multiple times and having a bunch of the same data in it so so i'm going to put this down on a notch there selected record dot and that's project start otherwise this item.project start so you can see it says 51 2020 now all right so that's going to be very tedious it's going to be a matter of going through all you know all these different fields and doing that on each one and it's going to be a more complex syntax for the more that the complex types of fields so if you have a choice field a people picker or a look up you have to write that big long ugly weird syntax inside of each of these to be able to have it pre-populate correctly what do you all think about this so far does that make sense so kimberly the trick to that is so when you are in on when you are in an edit form when you're editing an existing item there's actually a field um a property of your form control called item and so when you're clicking like in this case when i'm clicking on an existing project in a gallery and it's taking me to an existing item and i'm editing it it's it's obviously it's got all the fields filled in because i'm editing an existing item so item being that variable does exist as a concept but the problem is when you send the that is only with an edit form when you're using the new form command it's always going to be a blank new item and there is you can't populate it with something in the item property and have that have all the fields be showing so a sort of another way that you could go about doing the copy to new would you probably wouldn't want to do this but if you have people click copy to new and it actually patches to sharepoint behind the scenes and creates the item and takes copies the current item and patches to create a new one and then it takes you to an edit form of the new item it just created then that would be a way to get around having to go to each field and do this but i'm thinking in the real world that you wouldn't want to have that item just get created without the the person necessarily like tweaking it and clicking save and doing all that so that would be one way to do it that would be faster when it comes to filling out all the fields but probably won't want to so i'll go try and do one of these like project type i'm going to unlock that and go to the default and let's see if they're copied to new and just like i did with the vare um save and new you're going to somewhere you're going to have to set that back to false so just make sure that if somebody's just clicking on an item or they're they're going back to the home page or they're starting a new form or something you're just going to have to make sure and set that back to false at some point so that this form always doesn't perpetually think that it's doing this copied a new concept in that session that of the person using it okay so if they're copied and new now since this one is a complex field i can't just do just straight up you know the value of whatever it is and the project type is a complex field i'll show you it'll give me an error when i do that um that doesn't seem right because it usually has to have that little value thing now maybe if microsoft fixed this yeah no see it's going to look like it's showing the project type but if you try to save it the the value that it's trying to save it's not going to be in the right when you click the submit button it's not going to be in the right format so you'd get an error so that looked like it worked but you have to do the curly brackets so it's going to be value colon very selected project type and i think the capitalization makes a difference yeah there we go okay so that's what it looks like for i did three of them so far hours plan project start and project type and then again you just have to kind of you do that on every single field which i'm not going to do what do y'all think um i think i keep having to click refresh to get teams to understand um to show me all the oh my mom okay any last questions i can wrap up seven minutes early it's fine okay cool um if you ever want to know when the next power hour is we have a schedule here at iwmentor.com and here's today's power hour next week we're not having power hour because we're having our interactive online course so this is three days of advanced power apps and two days of advanced power automate and so we're going to be doing busy doing that all week but check that out if you'd like to get this advanced training and interactive what does that mean it's not a full live online class like me talking with you the whole time to the live students online interactive means that all the students are going through the same modules in this online training it is pre-recorded online training and all the students are going through the same modules each day and but we're having just two q and a's um each day of you know just the labs they went through and and the modules that they went through and just any questions that they have it's just it's pre-recorded so the interactive part is the part that everybody stays together and you're doing the same thing and you all get to um meet with me and ask questions just multiple times during the week so that's what that means all right well i think i'm going to wrap it up and thanks everybody for the lively um the lively questions this time and um i don't know what the deal is with teams it was being a little weird but you never know thanks joelle thanks laura we'll see you all next time which will be september 29th have a good afternoon sounds good have a good have a good one everybody

Channel: Laura Rogers

Views: 670

Rating: 4.7777777 out of 5

Keywords: Microsoft 365, Office 365, SharePoint, Powerapps, power apps, forms

Id: fslEn0lvjiA

Length: 56min 5sec (3365 seconds)

Published: Wed Sep 15 2021