PowerApps Forms - LastSubmit, Updates, UnSaved 

Shane thank you so much for these videos. These videos are best documentation I've seen on PowerApps, including Microsoft's own docs.

Thank you!!! I never post anywhere, but your videos have helped me so much, I needed to comment. You are fantastic. Thank you for posting, thank you for your channel and thank you for the way you go through the information.

Shane, I can tell you that as a "visual learner" and "citizen developer" your videos continue to be an incredible reference for me. The Microsoft Documentation doesn't make sense until after I view your videos. One thing that I'm working on at the moment is trying to update a gallery within a gallery (from outside of the gallery) by using the "On Select" function. Do you have any teaching related to that? Thanks for what you're doing with these videos...keep 'em coming!

Another great video and I learned things I did not know such as the UnSaved and Last Submit properties

Once again i screamed "WOW".. thanks Shane

love the way you share your knowledge, you make it easy to understand , thanks

Thanks Shane for the useful bonus tips and the series itself. One other thing in Form that I was looking for is that navigating records buttons. I was an Access man, so I thought its good to show all records within the form by using First, previous, next and last buttons. Please let me know how to get that. Cheers

Hi Shane - as others have stated - I LOVE your videos. Thank you so much for taking the time that you do to make them. I am relatively new to PowerApps (hence the reason I am commenting on a 4 year old video) and have a troubleshooting question. I have a button that not only submits my form but also resets it. When I try the "LastSubmit" function with that button, it doesn't seem to work. I created a separate button with just SubmitForm and I AM getting the LastSubmit to populate. Is it possible to have a button that submits and resets my form and still be able to capture the LastSubmit data? Thank you so much.

I think your videos are brilliant Shane, and have almost built a complete Employee Development App, with your help along the way. Thanks. One question is the unsaved property not available in a gallery? Or should I use a form for updating a gallery item and not let users directly edit the Gallery details?

Amazing video! It helped me with my project tremendously!

Although it's been almost 2 year since the upload of this video it's still very relevant and has been of much help for me. I'd like to point out 2 conclusions I reached regarding forms: 1. I really think that in the aftermath PA Forms are more work than manually editing and displaying the data, although when dealing with a large amount of data entries (=DB fields) - PA Forms is an option to consider. 2. Regarding the LastSubmit function - there is something to pay attention to. When a lookup field is included in the NewForm (say a CDS lookup) - the "cache" which LastSubmit refers to - DOES NOT HAVE the record pointed by the lookup ! Therefor cascading forms via LastSubmit - will have no value in the lookup field. (this took me 3 frustrating days to understand)

You have heard this before I'm sure but you are a life saver, love the delay on the save changes and will get into the pop video next. I just wanted to ask, on my form, i have a field which is pulling numbers but its setup to show a column thats only holds names. I have it working on one screen but I would like to add to this new screen, so that when a manual entry is created, it can also be allocated to a user.

Perfect info as always!

I really appreciate all your efforts to help the community. Thank you Shane! ... regards from Peru

Hey Man, I can't thank you enough for the value these videos has provided me. Keep up the good work.

This is so great Shane you are my hero

Hereeee is the another awesome Vdo, thank you Shane as always the vdo was very informative

Thanks for share your knowledge, regards from Paraguay

Great Video exactly what I was looking for! How can you display the Last Submit from multiple forms in the 1 display form? Is that possible? so I have multiple forms which split the SharePoint List onto separate pages I use the Patch function on submission so it all submits together. How would I display the last submitted item from the SharePoint list in this case - would Last Submit be able to do that?

Hi, I love your videos. I have a question I can't seem to solve. If I wanted my power app to read an existing record, and view in edit, and then once any change in a field has been made, to then create an entire new row (as opposed to replacing the entry in the column), how can I achieve that? MANY THANKS, Jese

Hi Shane, congrats for your vídeos!!! Lastsubmit is applicable for all users or just for the user that has submitted the form? I need yo be sure if lastsubmit will work if multiple users are using the app at the same time. Thanks in advance

Thanks Shane, helping Belgium Police to organise or stuff!

Great video again Shane! Can I use any of these functions to show each instance of a value which has been saved? I'm trying to keep a log of the number of hours recorded each time a record is saved.

This video is incredibly helpful, thanks for doing it Shane! I do have one question though. On Success of my form submission, I navigate my users away from the entry form screen to a success screen, but I want to give them the option to duplicate their last submission on the success screen which would bring them back to the input screen and pre-fill all the fields they just completed. I've tried every combination of NewForm(formNewDemand); ResetForm(formNewDemand); formNewDemand.LastSubmit; Navigate(CreateNewDemandScreen) I can think of and can't seem to get it! Any help?

Really useful info, thanks Shane. This video provoked a thought though, is it possible to have a "Save and New" type feature on a form? For example, if I want to add multiple records to a sharepoint list and 9 out of 10 of the fields will remain the same, it would be very handy to have a "Save and New" type button that will submit the data but leave the entered information in the 9 fields and just blank the tenth ready for the next record to be added.

Hi Shane, thanks for enlightening us once again :) I followed your videos on Forms but I didn't find the answer to an issue I have. I have a list in SharePoint with a date column called StatusUpdated. I want that, when the items Status is changed in PowerApps, the date is recorded in the StatusUpdated field automatically. Any ideas?

Hi Shane, this is very helpful!! I land a job because of you. Big thanks!! :) just a question do you have a tutorial in using qrcode scanner or barcode with the use of powerapps?? Badly need for inventory checking powerapps application my client wants it to be in qr code. Thanks in advance! :)

Nice video, thanks Shane! What's a good way to stay on the record I've just submitted via the form? My gallery is being updated with that submitted record, but since it has the SortByColumns function and the form has Gallery.Selected reference, the gallery selection then defaults to the first item in the gallery (and so does the form). Which isn't convenient since I really want to view the form I have just submitted. Any pointers as to how I might accomplish that?

Dear Teacher, you really got my point, I want set the reminder when user leave without saving, and if he select leave anyway，he can continue navigating. May I know how to do.?

very great video! i would like to know is there any way to navigate between multiple screens of two different SP lists(reason for two lists is each have more columns close to 200+), once first list new form is submitted, data stores in sp and it moves to next new form from another list, I would like to have back button on the second form to edit the first screen values in the same session. kindly advice.

Hi Shane, I have a gallery in which data is filtered based on Status dropdown (New, Pending, Resolved) . In gallery, I have a comments column where user can enter comments in the textbox for a particular record. So, without clicking on Save button if the user navigate between one Status to another status, How can we keep the changes saved in the gallery?

Cool videi, thanks Shane! At 7:16, didn'y you want to do the other way around? If(Form2.Unsaved;DisplayMode.Edit;DisplayMode.Disabled)

Hey Shane! Great Video! Perhaps you can help me with something... I want to Summit a Form without going to the previous page. That can be done with something else that a Collect function?

Shane - love your vids! I am doing a submit form, and the onsuccess property has a patch to the same record. (change status of the request, only want to change that field if the submit is successful.) Onsuccess also navigates to a conf screen where in an email is sent to the requester indicating the request has a new status (approved, denied, etc.). I am using lastsubmit to pull out details from the record to put in the email body. However, I notice the status field with the lastsubmit does not show the new status from the patch (sharepoint does...), I'm thinking because the patch was after the SubmitForm? How can I pull the updated status into the email ?

Thank you Shane, One Question, If want to show the time and Name of the person last updated a record from the form then Which function shall I use? Will it be the LastSubmit or Office365Users. Kindly share the command.

hi shane, could you make a video of browse gallery for images?, fetching, update,upload new image? (just like a data). i have seen the upload image to sharepoint list with flow with camera. but it didn't cover up for a simple browse gallery like data. thanks

Hi Shane, the Updates would come in handy for us when we have customer details that might have changed, it's a huge amount of details and those approving it will probably only want to see what was updated instead of the whole lot. Hoping to work it into our app. Quick question: when I use the DisplayMode - If(Form2.Unsaved, DisplayMode.Disabled, DisplayMode.Edit my New Form won't respond in the same manner as the Edit Form. How would I make that Save button work on both pages? Thanks heaps for your hard work and making it available, you're a legend!!

Hi Shane Young, can you please make video on how to check for duplicate records in SharePoint list before submitting the power apps forms?

hi Shane! wondering if you have any idea why my PowerApps SubmitForm function is not working (without errors) Some users tries the submitForm function in my app but the data wasn't recorded in the SP list, however, some users dont have any problem By the way, the Permission list is set to "Everyone except external users"

Thank you for your videos. Do you have a video so that at submit, direct to a different web site or a Thank you screen?

Hi, great vidéo as usal! I just wonder what will make a form come back to "saved"? It looks like Submitform doesn't make it happen. Thanks

Hi Shane, thanks so much for all your videos, they are soo helpful. I have a question on LastSubmit. I'm trying to create an add/edit screen, where after they add a new record, they stay on the same screen, and would be able to review/edit it. Problem: My initial formmode is new. When a user submits the new record, the form changes to formmode edit and no data is displayed. I understand this is because no record is 'selected'. I was trying to use the LastSubmit property of the form to re-populate the edit form. I can't get this to work. any thoughts. fyi -I'm using SQL Server data base.

Hi Shane, great video! The LastSubmit function solved an issue I was toying over for days. Question for you on the Save/Unsaved function you present. As you mentioned the logic was perhaps incorrect in this video, but you did illustrate how the unsaved function works, specifically, the label popping up after there were unsaved changes. However, when I created my Save button and I wrote in the OnSelect properties to SubmitForm, my form reset to the first record from my datasource, and not the record I was currently working on. Any thoughts on this? Looking forward to the next video! TG

Hi Shane, thanks a lot. Very insightful, as always. I have an edit form with a couple of hidden datacards which record the last modified by and date when the user submits the form. It works fine. The new requirement is to record the last modified by/date for a specific field within the form. So if the form has two fields, A and B. The standard "modified by" works when any of the two fields are updated. But how to have a separate "modified by" for just field A?

Hi, Is there any way to show some datacards in displaymode view while others are in edit mode? (I am using "EditForm" control with a Gallery.)

Shane, thank you very much for your videos! I can always learn some new things from your videos. I'll try to watch all your videos. I have a question. How can I reset the form to new after user submits the form? My form shows "No item to display" after user submitted the form.

Hi Shane, Thanks for your videos. Is it possible to notify the user during edit mode if the other user modify the same record?

Amazing video Shane :) Is there a way to send an email from power apps to show only the data cards that have been changed on the form? I mean I only want to see the data cards that have been changed on the form. Thanks in advance :)

Shane - thank you for your great videos - but as I was following I did something wrong, I'm hoping that you can help me. My first APP went awesome - the second one though I did as a "New" record only and when I saved it - it opens from the SharePoint List - New Record (which is awesome) but it is not in the Power Apps library as a phone app - what did I do wrong?!? Hoping you can help.

Will this work with mandatory fields? If not, what do you recommend as a work around.

Hi Shane, here we are following your steps in the PowerApps world, best info out there! I started wondering if PowerApps could trigger actions on pressed keys, when I filter a dropdown control based on a text input control resulting in only one item it kind of confuses the users because they still have to go and select that one item so the control changes its value, it makes sense when there is more than one and I am not quite sure how to go about this, if result is one item can PowerApps somehow select it automatically? Thanks again :)

I wanted to share a use scenario for form.Updates. I needed a way to let users download photos from my view form directly from my app, but I couldn't find how to do that without using attachment field. So, because I was saving my data with Patch function, I just added the attachment field and adjusted Patch: Patch(SPlist, Defaults(SPlist), { ...... }, form.Updates )); It doesn't duplicate my data and works just fine. Maybe you could do a video on how to download pictures from PA app forms?

Hi Shane, great job! I was able to do everything based on your videos so far :-) Now, I got this thing -- I have two sharepoint list where the second one is inherited (list of Incidents and list of individual Calls for the Incidents) If I create new Call record how do I pass the Incident ID? I tried Patch and Last Update but it does not do do job. [Patch('Calls',Form_CallDetails1.LastSubmit,{'Incident': IncidentId})] (IncidentId is a variable)

What is your viewpoint about forms vs individual controls for collecting data over multiple screens?

Thanks for the video Sean. How would you use the form.unsaved to stop users selecting another item in the gallery before saving? Thanks!

Love your videos!! So, how can I print out a technical document of all the programming done within the App? Example: in any other languaje (old school) i just print out a list of the written program for safe keeping, trouble shooting, documentation. I tried to do this using an excell spread sheet, but its too time consuming. Now, I'm not talking about documenting your program. I already saw your video on that (great stuff). Any ideas?

Can the Update data be written to a text file or a field for audit logging? Thank for the video.

Hi Shane , Thanks for the video. I am facing an issue with Form.Unsaved . It always returns true even if I make change. I am using a OneDrive Excel DataSource . Please help!

Is there a way I could use the "LastSubmit" function to show the last time a specific user submitted their answers? Say the form needed quarterly updates and a user wants to see what they submitted previously to only make changes to the form questions?

Hello Shane, great Video! If I want to use the Unsaved property for editing a form and also for a new form, but on the new form only have the message appear if there have been changes to the new form. Right now, it works perfectly in form edit mode but if I open a new form, the message appears immediately without entering any data. Also I can't seem to figure out how to get the cancel/close icon to only be disabled when the form is in edit mode and not in new form mode. I want the cancel/close icon disabled if the form is in edit mode, but enabled in new form mode while also displaying the Unsaved Changes Message. I can't seem to figure out the correct query to use to accomplish these goals. Any suggestions or videos on these specific ideas? Any help would be appreciated. Thank you again for the great videos, they are very helpful and I learned a ton from them! Regards, Michael

Hi. I try to export the modified date to a SQL server, but it keeps giving me a NULL value on the server. The column format on the SQL is nvarchar so it should read it just fine. What settings should I use in the PowerApps form to get it to display the time/date on the SQL server?

Hi Shane, can you share me how to how to search for a particular ID of one SPO list in another SPO list and update that particular item using powerapps

Shane, I puted a icon and OnSelect --> EditForm(myform). myform has ITEM as mygalery.selected BUT, the property myform.unsaved is comming TRUE, even if i dont change nothing.... and myform.updates also is comming with the inputtext, even if i dont change nothing... Any idea?

Hi I'm wondering if it's possible that the edited form will also be logged to sharepoint? like every edit that the user will do, will be also logged in sharepoint

Great series. I am struggling with the functionality of my Form. I created an edit form, added all the fields etc. My problem is that I need to use my form in 2 ways, One, to Simply submit the form (no problem) , but, sometimes I get inventory of computers that are exactly the same, except a different serial number. So I have a "Submit And Add" button for this. It should submit the form, then create a new form with the fields being populated with the last submitted records' data (except the serial number). Is there any way to accomplish this? Ive tried reading each field into a variable, and a couple other things. It submits fine, but the newform does not populate with the data from the last submit. I enjoy your posts, I learn alot: Im very new to powerapps. Thank You Terry

Hi Shane, Great videos. I am wondering if I can use Lastsubmit to prevent duplicate records from the user. I have used DisplayMode = If(EditForm1.Valid, DisplayMode.Edit, DisplayMode.Disable) on my submit button and it works fine. I created a unique key as Title = User().Email&Datacardvalue.Selected.Value. to capture user's selection. I want the form to exit with a message if the user make the same selection. May be set the editform1.Lastsubmit.Title !=Datacardvalue.text, where the Datacardvalue is current User().Email&Datacardvalue.Selected.Value. Any suggestion? The source is SP list.

hI @Shane Young, do you have info on how can I submit data in second form to the data i submitted in first form? I have 2 screen with 2 forms. Screen1-Form1 and Screen2 Form2 so i want data on both form to be on same row in sharepoint list but when i do submit form in 1 and 2 it creates 2 records 1 for form1 data and another for form2 data.would appreciate your help

Thanks for your videos. After SubmitForm the ID resets to the first one on the list. I wanted to keep the same ID (the selected on gallery). Can you help pls?

If somebody forgot to click on sAVE button , how to display message to them, I am using patch to save the data.

I wanted my power app to modifying an existing record, and view in edit, and then once any change in a field has been made, then it has to create a new entry in the sharepoint list ...please can you help me with this....

Is there a way to save the history after you make a new row of update or resave in list at sharepoint

Great video Shane, again :) But what if you're not using Forms? I created a resource leveling app which is essentially a calculator that folks use, and when their numbers are where they want them, they 'Submit' and all answers across screens are patched to a Sharepoint list. Forms doesn't really work with the interface I needed so I'm using text inputs. My objective is to allow users to submit, but also to update if necessary. Do you have a video or recommendation of the best way to pull the data from the first submission back into the app from Sharepoint so the user can see what they originally submitted, make updates, and patch the updates back to the Sharepoint list? The goal is to have the data submitted and updated on the same line in the Sharepoint list rather than establishing a new line each time a user submits data. Thanks for any help/direction pointing you can give me!

Hi please how do I update the PowerApps columns from the SharePoint list. For example if I add new columns in SharePoint how do I make it populate on the already existing App in PowerApps?

I have one more question how to get the value of checkbox and display in label in power apps I teams. I have tried a lot it just displays false or true and how to display Created by and Modified by value in one label ??

Hi Shane How to insert Drop down list data and an attachment in Sharepoint using PowerApp Thanks,

I have a scenario for Updates. I have a user asking me for a email to be sent showing all fields that were changed. In the SharePoint list there is the Alert me function but it is only to that certain user. They want to dymanically send something like this to a the process owner of that particular item. I created a dummy PowerApp comparing a PreSave and PostSave collection to compare one at a time these fields. But this updates looks to be a better way ...maybe...hope so :)

Hi Shane ! Great video, this video helped me a lot. I have question ? Can we show a pop up saying "Are you sure you want to submit again ?" for the form which we have already submitted ? FYI : The data has already submitted to List1, again if you edit and re submit the data it should throw a pop up, can we do it ?

Greta vídeo! Tx. By the way, lastsubmit takes into account last users submission or others users as well? I mean. Let’s say another user submits a form just before I submit mine and in mine I reference last submit form. What is saved to my record? Mine or his? Tx

You could use updates for a log table...

How can we get the last submit if we have two forms to push the data using patch?

any concerns if you have multiple users using the same app at the same time?

Hi Shane! This was video 31 for me (I'm moving right along). This is some seriously good SHTUFF, my man! I'm sure that I will be hiring you when it's time for me to work on my "real" PowerApps. Normally, I can get everything to work as it does in your videos (well, nearly everything). This one is annoying me, though. On the label where you use LastSubmit (e.g., "The last name of the person submitted is: " & form.LastSubmit.LastName), I can see the correct value only for an instant and then it disappears. What am I doing wrong?

.updates can be used with patch I believe

form.update` is showing all field values except for the date; it is showing blank in the date picker. Pls help me in this

Great!

need to add a "remove record" button?

Thank-you Sir Shane for your Awesome Tutorials ! (This will be the 16th video and counting, that I'm watching.) They are the missing pieces which are not covered on one of the Online Courses such as.. (well I won't mention). Anyhow, you are way, way better than my Computer Science Professors ! Well, I go to Powerapps911 and put 'youtube' and 'chewy' in the coupon code ( as you mentioned towards the end of your video here) but it doesn't work. Anyways, Keep up the good work. I look forward to ALL your videos. God-Bless.

Does the LastSubmit function no longer work? I can't get it to come up in any way.

Survey results: 4 out of 5 dentists are okay with "Leave me a Tweet." The fifth guy is a Luddite. (Awesome series, well done.)

The .Updates is great to Patch attachments in SharePoint lists. I don't use forms in Powerapps because I find them really hard to work with (everthing resets everytime I make a change, etc). I use a single form with just attachments in it and add at the end of the Patch() function, just after the {} portion of the patch function. I found this here: powerusers.microsoft.com/t5/Building-Power-Apps/Need-to-add-Attachment-to-a-PATCH-to-a-SharePoint-List/td-p/158968 . It is great! Continue your great videos!

Love your intro!! Lol

great info, but please don't say "Heeeerre's our intro" , just play the damn intro!

Hi Shane. Your videos have been so helpful!! I'm not a tech person but have to make an app for work and these videos have gotten me through the process. QQ: Can I put in a Form from a SharePoint List into my app that doesn't require the other gallery? Basically I am creating a float tracking form where people fill out the form with their float count to populate within that SharePoint list but I'm having trouble using the Form Function. Would using a Patch work better and just make individual labels? Any guidance would be really appreciated! You rock!!

Thanks for the great video! I’m wondering how lastsubmit could be used to display inputs if we have multiple forms? Should we be using the patch function in the formula in “item”?