This is the first time I have left a comment for a UA-cam video. An EXCELLENT video. I modified my App to remove patching for Combo Boxes in my save command (about 20 lines of code) to one line of code (Submit Form function). After I made that change, the backwards and forwards navigation in my app went crazy - this video clarifies why. Thankyou - a fantastic easy to understand video.
Perfect! I missed a few steps the first time, but when I watched this video again and followed your precise instructions, it worked exactly like it should. Also, using Patch for the combining of records is quite a big deal. The missing piece of the puzzle in some use cases I'm working on. You don't have a lot of videos on UA-cam (yet?), but the ones you posted are absolutely awesome and every PowerApper should see them. Don't hesitate to post more of this great content 👍
Besides the incredible and very useful information uou share, your teaching skill and the way you speak are outstanding! Thank you and keep the excellent work
Great work, very clever use of the master form and I like the fact this is very simple. Learned a lot from watching this and have replicated for some projects. Keep up the good work. 👍
this is an underated tutorial. absolutely genius. it was the answer to my problem. i had one form split between two screens. every tutorial, to return the last submit to make a "Review" screen said i had to .lastsubmit. but that only works with one screen. shear genius. i like the use of one variable. i did disable and hide my gallery though
Great video, helped me with my App alot, but I have a question on how to get this to work with attachments. it doesn't seem to be carrying over to the master list
This is fabulous and very close to what I need. I have a list that is completed by one person when a NEW item is received but a second person needs to add one field only that would then trigger some planner tasks. Can this be done? I haven't been able to find answers to this and I'm so green with power apps.
Thanks, I got an answer to my question about 1/3 the way in - so Edit Forms are never going to work as 'New' forms if you break up the form? So how do you add a new item form to this example, make 3 additional forms? When there's a lot of fields that in itself is a daunting prospect. Can you please explain how to do this with a SharePoint Integration example and how you would create a new form too? I'm trying to do something similar as a SP form and, as many people have recommended patch, that's what I've used - that part actually works fine (for editing/submitting updates) but the handling of 'new' vs 'edit' vs 'view' is turning out to be a diabolical nightmare.
I'm getting the same thing! Do you have a People/Group column in your SharePoint list? After googling I'm sort of suspecting that might be the issue in my case.
I've just gone through this step by step and I receive a 'Network error when using Patch function: The requested operation is invalid'. Any idea if the process has changed since this video was made?
Hello! first of all, this video is fantastic and very well explained! I am beginning working with Power Apps and it helped me a lot do exactly what I needed. So big thanks! I have one question though: I am working with a Sharepoint list and, when I want to remove a register, it's not working. I can see the item disappear in the gallery but not in the actual list. I wonder if it has anything to do with the way the form is split but it shouldn't, right? Thanks a lot in advanced!
I had something similar and it turned out I forgot to set the global variable (glbCurrentRecord in the video), so it was still blank, which makes the form go blank as well. Maybe this happened in your scenario as well?
Randy, i'm using Microsoft Lists and created custom form using your teqnique but instead of creating the gallery, I had the data go to the Microsoft list, but now when I click on an item on the list, it doesn't pull the data to edit. Is there a way to fix that?
Normally forms do not have a collective on the final screen as you demonstrate. In the case, how can you submit all the collected data using the SubmitForm command if the fields are not present on your final screen? To get around this, I added all the fields used in the previous screens but turned off their visibility. Curious to know if you have a recommendation.
Thanks Randy! as expected, my users didn't want Attachments on the last page, so I used Patch(,Last(),AttachmentForm.Updates) and it worked ok. Is that safe?
if anyone need this is the solution: if the data card from the attachment field is named datacard1 you need to place it in the main form attachment field in the item property of the data card like DataCardValue1.Attachments and it will work, hope it helps anyone.
This is a great video, it helps me so much. But I have one question, I'm using SharePoint as data source and I'm using lookups, it works everything for me and I can patch the list, there is just one thing I can't find a solution for. If I chose a value from the dropdown of the primary lookup column, I'm not able to make the values of the secondary lookups visible. Do you have any Idea?
Do you know if this works with attachment fields? It works flawlessly with everything else, but it isn't working with my attachment field for some reason.
Hey I found a way, if the data card from the attachment field is named datacard1 you need to place it in the main form attachment field in the item property of the data card like DataCardValue1.Attachments and it will work, hope it helps if you still need.
@@victornassiff7578 No, I wasn't able to get this working with attachments. I might have found the right syntax, but I had already moved on with a different approach so I didn't have a chance to test it. I was able to get a little more flexibility with the standard form using custom datacards as lines to separate things. It doesn't provide all of the flexibility, but it worked well enough.
It would be the same thing pretty much. The only difference would be that you would be using the SharePointIntegration (SPI) object. And, for simplicity, set the glbCurrentRecord (referenced in the video) in the OnStart of the app to the Selected of the SPI, plus a little logic for a new record (still setting it to Defaults). I was going to put that into the video as well, but I thought it was getting too long to still qualify as a "quick tip".
@@randyhayes891 Thanks. I set the gblRecord in the OnNew, OnEdit, OnView of the SPI. What is not working for me is getting data entered in frm1 to show/reflect in frm2 (master). I set it up the way you state in the video but nothing. frm1 has a single Combo Box linked to a Choice field. The same ComboBox exists on the master. For the master I do the Patch with the gblRecord and frm1. No change. I tried doing it in the OnChange for the cmb on frm1, no Change. What am I missing?
@@stevenperry2491 What do you mean by only one screen? Are you saying you are splitting the form on one screen? If so, that is actually a simpler scenario to resolve.
@@randyhayes891 Hi, I also got it to work for App only but not when I use it with SharePoint New. I tried the following App.OnStart Set(varFormData;Defaults('MyList')) SPI.OnNew I put Set(varFormData;Defaults('MyList')) frm_Section1.Item varFormData frm_Section2.Item varFormData frm_Master.Item Patch(varFormData;frm_Section1.Updates; frm_Section2.Updates) Finally now it works from New in the SharePoint list.
This is the first time I have left a comment for a UA-cam video. An EXCELLENT video. I modified my App to remove patching for Combo Boxes in my save command (about 20 lines of code) to one line of code (Submit Form function). After I made that change, the backwards and forwards navigation in my app went crazy - this video clarifies why. Thankyou - a fantastic easy to understand video.
So happy to be the first post for you!! And glad you enjoyed the video!
Perfect! I missed a few steps the first time, but when I watched this video again and followed your precise instructions, it worked exactly like it should. Also, using Patch for the combining of records is quite a big deal. The missing piece of the puzzle in some use cases I'm working on.
You don't have a lot of videos on UA-cam (yet?), but the ones you posted are absolutely awesome and every PowerApper should see them. Don't hesitate to post more of this great content 👍
Besides the incredible and very useful information uou share, your teaching skill and the way you speak are outstanding!
Thank you and keep the excellent work
Wow, thank you very much! I am glad you enjoyed...more to come!
Great work, very clever use of the master form and I like the fact this is very simple. Learned a lot from watching this and have replicated for some projects. Keep up the good work. 👍
Love, love this video! This solves what I am trying to do (break long records into multiple cleaner looking forms). Thank you for sharing! 💚❤💛🧡
this is an underated tutorial. absolutely genius. it was the answer to my problem. i had one form split between two screens. every tutorial, to return the last submit to make a "Review" screen said i had to .lastsubmit. but that only works with one screen. shear genius. i like the use of one variable. i did disable and hide my gallery though
THANK YOU!!! This was a lifesaver.
Very nice Randy
Great video, helped me with my App alot, but I have a question on how to get this to work with attachments. it doesn't seem to be carrying over to the master list
This is fabulous and very close to what I need. I have a list that is completed by one person when a NEW item is received but a second person needs to add one field only that would then trigger some planner tasks. Can this be done? I haven't been able to find answers to this and I'm so green with power apps.
Thanks, I got an answer to my question about 1/3 the way in - so Edit Forms are never going to work as 'New' forms if you break up the form? So how do you add a new item form to this example, make 3 additional forms? When there's a lot of fields that in itself is a daunting prospect. Can you please explain how to do this with a SharePoint Integration example and how you would create a new form too? I'm trying to do something similar as a SP form and, as many people have recommended patch, that's what I've used - that part actually works fine (for editing/submitting updates) but the handling of 'new' vs 'edit' vs 'view' is turning out to be a diabolical nightmare.
Great help. Thanks!
I have received this error.
Power Apps network error when using patch function. the requested operation is invalid
I'm getting the same thing! Do you have a People/Group column in your SharePoint list? After googling I'm sort of suspecting that might be the issue in my case.
I've just gone through this step by step and I receive a 'Network error when using Patch function: The requested operation is invalid'. Any idea if the process has changed since this video was made?
Hello! first of all, this video is fantastic and very well explained! I am beginning working with Power Apps and it helped me a lot do exactly what I needed. So big thanks! I have one question though: I am working with a Sharepoint list and, when I want to remove a register, it's not working. I can see the item disappear in the gallery but not in the actual list. I wonder if it has anything to do with the way the form is split but it shouldn't, right? Thanks a lot in advanced!
Randy, What's the trick to get this to work with file attachments? - Ken
When I try to play the app, the form on my first page is blank. The Default Mode is FinalForm.Mode, like you said to do, which is set to Edit mode.
I had something similar and it turned out I forgot to set the global variable (glbCurrentRecord in the video), so it was still blank, which makes the form go blank as well. Maybe this happened in your scenario as well?
Any tips on creating a multiform app with two repeating sections?
Great video!! Thank you, is it possible to activate and desactívate bottoms depending your selection in a form dropdown card? Thank you again
Randy, i'm using Microsoft Lists and created custom form using your teqnique but instead of creating the gallery, I had the data go to the Microsoft list, but now when I click on an item on the list, it doesn't pull the data to edit. Is there a way to fix that?
this keeps showing the form in view mode or nothing showing, can you update with a sharepoint datasourse please, integration
Normally forms do not have a collective on the final screen as you demonstrate. In the case, how can you submit all the collected data using the SubmitForm command if the fields are not present on your final screen? To get around this, I added all the fields used in the previous screens but turned off their visibility. Curious to know if you have a recommendation.
Hi: EditForm(frmMaster); Navigate(srcnSection1), in power apps, the semicolon appears red, I mean, it gives me an error, why?
Thanks Randy! as expected, my users didn't want Attachments on the last page, so I used Patch(,Last(),AttachmentForm.Updates) and it worked ok. Is that safe?
Thank is AMAZING!!!!
What about the attachment field, how can we make it work?
if anyone need this is the solution:
if the data card from the attachment field is named datacard1 you need to place it in the main form attachment field in the item property of the data card like DataCardValue1.Attachments and it will work, hope it helps anyone.
This is a great video, it helps me so much. But I have one question, I'm using SharePoint as data source and I'm using lookups, it works everything for me and I can patch the list, there is just one thing I can't find a solution for.
If I chose a value from the dropdown of the primary lookup column, I'm not able to make the values of the secondary lookups visible.
Do you have any Idea?
Many Thanks.
Do you know if this works with attachment fields? It works flawlessly with everything else, but it isn't working with my attachment field for some reason.
did you got this working with attachments?
Hey I found a way, if the data card from the attachment field is named datacard1 you need to place it in the main form attachment field in the item property of the data card like DataCardValue1.Attachments and it will work, hope it helps if you still need.
@@victornassiff7578 No, I wasn't able to get this working with attachments. I might have found the right syntax, but I had already moved on with a different approach so I didn't have a chance to test it. I was able to get a little more flexibility with the standard form using custom datacards as lines to separate things. It doesn't provide all of the flexibility, but it worked well enough.
How would this be changed if this was a SharePoint list form instead of a straight Canvas app?
It would be the same thing pretty much. The only difference would be that you would be using the SharePointIntegration (SPI) object. And, for simplicity, set the glbCurrentRecord (referenced in the video) in the OnStart of the app to the Selected of the SPI, plus a little logic for a new record (still setting it to Defaults). I was going to put that into the video as well, but I thought it was getting too long to still qualify as a "quick tip".
@@randyhayes891 Thanks. I set the gblRecord in the OnNew, OnEdit, OnView of the SPI. What is not working for me is getting data entered in frm1 to show/reflect in frm2 (master). I set it up the way you state in the video but nothing. frm1 has a single Combo Box linked to a Choice field. The same ComboBox exists on the master. For the master I do the Patch with the gblRecord and frm1. No change. I tried doing it in the OnChange for the cmb on frm1, no Change. What am I missing?
Also, I am only using 1 screen.
@@stevenperry2491 What do you mean by only one screen? Are you saying you are splitting the form on one screen? If so, that is actually a simpler scenario to resolve.
@@randyhayes891 Hi, I also got it to work for App only but not when I use it with SharePoint New. I tried the following
App.OnStart Set(varFormData;Defaults('MyList'))
SPI.OnNew I put Set(varFormData;Defaults('MyList'))
frm_Section1.Item varFormData
frm_Section2.Item varFormData
frm_Master.Item Patch(varFormData;frm_Section1.Updates; frm_Section2.Updates)
Finally now it works from New in the SharePoint list.
This just confused me even more.