🍬 Get my free Power Apps Crash Course, access to our free community, and, if you would like, you can book a call with me here: go.superpowerlabs.co/superyoutubelanding ⬅
Brilliant explanation of the Patch function Darren. So easily demonstrated. Thank you Darren! Really appreciate these short videos of each of these functions in PowerApps.
Thanks so much for the kind words! That type of stuff keeps me going. 😁👍You should use the Default property of the Gallery and set it to a variable that you SET() right after you do the Patch(). I hope that helps! 😎
Darrens video is the one video that made me understand what Patch does and how to use it in Power Automate. Very clear and easy / fun to watch. I took notes because the instruction was so easy but very powerful This one video will help me in my current job
Excellent patch demo video. Seen many, and this was very clear and easy to follow. I liked that he was showing how the code links up with the list and controls. Going to use this for my work.
This is outstanding. The information presented was easy to follow--no guesswork on my end regarding how you got from A to B. As a new coder just learning Power Apps for the first time, this delivery method is invaluable.
Excellent job! I have watched a number of your videos and just registered for your "Power Apps Masterclass." I'm eagerly awaiting the email to the portal. I like the way you explain things and operate with an assumption that some people have built application in different environments and only need some syntax/development environment guidance. Kudos!!!
Hello, @ericgamble8605! I just resent your credentials. The spam filters almost always will snag those emails. Here is the link to the course: www.skool.com/power-apps-community/classroom/90da163d?md=8ab56687c2cd49f6af7169162aa55e47
@@PowerAppsTutorial Smth related to Project Control and/or People Performance. I think those are so embracing as Ticket System. If you could include dashboards with graphics would be nice!
OMG! Wonderful, you made it so easy to understand. I clearly understand to use a Patch( ), and you mentioned and covered the minute details aswell like changes in the save button that should be made after getting your Set( ) variable along with adding the If( ) statement. Highly recommended for anyone who is struggling with patch function especially for beginners. Thanks alot Derren for the video.
Thank you Darren for sharing this info. Just a very small remark, (and I know I am a person that can be really on the details 🙂), nothing big, not really important...but here it is: The camera that is recording you is slightly moving from time to time. Maybe you have putten the camera on the desk that you are working on and is moving sometimes a little bit while typing? That's it....but certainly a great video, you are a real master in taking the audience step by step through the proces! Thank you so much! 👍
Crappola! After watching this short and excellent tutorial I feel like my patches are all very sloppy. I never thought to use the same patch for new and edit. Thanks for the info!
After I patch the record that I was on doesn't update with the new or revised data until I click off that record and then click back on that record in my gallery. What can I do to "refresh" the record data without having to click off and on the record after I patch?
You explained everything so nicely. I am new to Powerapps and built my first app looking at this video. A small suggestion if I may, please try to zoom in on th code while you are typing in the video, so it becomes a little easy to read it. Thanks again.
If you're looking reduce your learning curve in the shortest amount of time, you can join my accelerator program for one-on-one mentorship. Book a call with us if you need this: calendly.com/super-power-labs/student-interest
Thanks for the video, and just a small question, how to keep the text stay on the new save item rather than the gallery selected before after click on the save button? Thanks.
I am proficient at patching, but still find I like forms in some instances better. This is mostly because of the form.valid property you get with a form. Have you found a way to enforce required fields similar to a form with a patch on a button other than setting conditions on the display mode of the button?
Sometimes I use that method actually, along with providing a label which tells them which field is keeping the button from being enabled. Is there a reason you don't like this method? It's always worked well for me. Thanks for the feedback! 😃
@@PowerAppsTutorial I haven't thought to add a label. The other reason I sometimes prefer a form is it is much easier to create a responsive app with a form, especially if there are a lot of fields.
I have used patch function cool ,but tried it for dataverse file column to make a new row. But while deleting/editing file with submitForm it doesn't delete it? Thanks
I am very new to Power Apps and learning as I go, your video has been very helpful but am stuck on one thing, I am attempting to use a Combobox instead of a text field but am not able to to update the field based on the selected item in the gallery, how do I change this? I have modified the formula to Patch the info to the SP List but cannot get this working for the selected item, can you please help?
HI, thanks a lot I really appreciated; I have one question please if you could make a tutorial about this query. can we make many-to-many relationships in power apps through the share point lists? I already see the one-to-many relationship tutorial
@@PowerAppsTutorial thanks a lot i see the live that u made it was a little bit difficult for me but i will see it again. Really I appreciate your effort and your way to simplify the information.
@@PowerAppsTutorial thank you. I found a video that helps me understand how to write patch codes for choice columns in lists. Can you please do a video on this function?
Great tutorial. If I wanted to set a text box to show an error if the user enters the data incorrectly, for example an extra digit in a phone number, could that be done?
Yes you can, you can update a variable state on the OnChange property of the textbox, then also set the visible property of your label to show error message ☺️
excellent video. really good. explains very easy. as a video suggestion, I don't know if it addresses this non-course content, it would be "send files to sharepoint library". I would like to know which method you use. thank you very much
Hey Mr. Neese! Loved the video and have a question: When adding a gallery and the text input corresponding with the Title column and it pre-populates with everything that is currently on record within that column. Is there any way to limit these to one specific item in the column? Using the example you have, is there a way to ONLY show one name and it's phone number instead of all the items and rows showing up?
This is a good question, but it's hard to help with technical details here. Feel free to join my free community here where it is easier to help: www.skool.com/power-apps-community
Very nice! Thank you. I've done some Power Apps work, still find the video very useful to demistify Patch even further. I also have a question if I want to have a full sync bet. Dataverse tables and SPO lists - what stragegy would you recommend. I can have the lists for simplicity to be RO, and the actual DV act as the storage for the app. The sync I want to achieve is when the data is modified, i.e. a record added/deleted/updated - the app saves it in the DV and the lists reflect the changes as well. I am contemplating two options: A). Using flows in SharePoint and listen to DV tables change or B). Patching the lists directly from the app (which make this video very relevant). What's your suggestion? Thanks again! Subscirbed. And Liked! 😊👍
Nice tutorial. I have questions. Using SQL View as Data Source, How to update a specific table only? I am new to Power Apps. I have an empty vertical gallery with sql view as data source. Let say I have a view name SampleView created at SQL. This SampleView has table1 and table2 joined.If I use Sampleview as data source for empty vertical gallery. How can I update record on table2 only? Let's say I put Text Input named TextInput1 in the gallery. Its value came from table2. If I modified the value of the first row of TextInput1, how can I update it back on table2?
@@PowerAppsTutorial Thanks. What if I want to update multiple columns and record in table2? Let say I have TextInput1 and TextInput2 with its data coming from Table2. What to do if I want to top update this two TextInput1 and want not send data back to table2?
@@ojsojs6004 Yep, that code would do it, just add in the other fields. For example: Patch(Table2, ThisItem, {field1: TextInput1.Text, field2: TextInput2.Text}) That code can be in a save button inside the gallery. Does that make sense? Are you in the Facebook group? learn.powerappstutorial.com/InsidersGroupSurvey
@@PowerAppsTutorial you are awesome. One last question. What if in these TextInput1 and TextInput2,I want to update multiple records/row let say row1 and row2 of table2? I am not a member of that
This, but with a drop down list instead? I am looking for something super simple like this, but want it to be a set list of pre-determined names so we don't end up with multiple versions of the same words for reporting purposes.
Man I really want you to give us a better insight regarding, what if i have more power apps lists ? Let's say I want to have 3 lists, I want to patch data in all of them, they get also linked with each other via a column and then when i want to update them to select 1 item from the gallery and then i will have a flow of screens where i edit each screen of the specific list. Atm i have a big trouble with this issue and would love a tutorial.
I love it! This is how real applications are. I do have lots of videos here on my channel that go through all this while building real world apps. Here's a good example of just this: ua-cam.com/video/KgP2S_fwxJE/v-deo.html
I really love using patch. I prefer it to using Edit Form field. Although using Edit Form can be a lot easier because all you have to do is create the columns on SharePoint list. But with patch, you can be more dynamic in your development.
Question, how would you go about implementing a scenario we’re the user has to enter their current password, then new password while confirming the new password?
I've decided to finally make the switch to using Patch instead of Forms. It ends up taking a lot more work when you're working with tables that have over 20 rows and needing to write a new line for each row, as well as keeping track of every single field and making sure they're pulling the correct data. But I definitely prefer the flexibility it allows. One issue I'm facing with this method is figuring out the best way to do attachments. I know I can rip the attachment control from a form and use that with a power automate flow, but I'm wondering if you know of a better solution for attaching files without using a form.
Hi there! Thank you for watching the video! If you could join the "Learn Power Apps" community and ask your question in our board, I will be able to give you a complete response for your question: tinyurl.com/PowerPlatformCommunity
Patch is a good function. But what if your datasource has 15 columns or more? You’ll need to hardcode all these columns and this might be a problem in future. And you always need to check if there are any errors or check if all required fields are filled in. So there will be more code. While using the form it will all be checked. But for such simple two column solutions this might work
Thanks for sharing! I will admit, it is extra work. Almost all my apps have 10-30 fields per screen for edits, and yes, it is a lot of work to add validation and error checking. However, if someone needed an app that had close to 100 or more fields, I'm not going to lie... I'm going to consider using a form! 😂👍👍
Here's an example app I build that has many edit controls across tabs in a screen, if you're interested: ua-cam.com/users/livee7lgFxx-43E?feature=share
Hi all, this only works nice with classic controls. However with modern controls the Save Button won't receive the current TextInput, except you click outside the input first...
Hi I am building a voting app. Very simple 10 animals names and people will need to vote a decide which animal they would like to have for their university. However, the problem comes when we want to show after people submit their vote the results. like which animal is winning like a racking who is winning and who is losing. Could you help me please?
Patch isn't the only option available in PowerApps for saving your records to a database. The patch function has a sort of customizable behavior that makes it stand out from other options.
sounds good but really isn't. form has the on succes property where you can make sure that the user receives a notification on screen if the entered data is truly saved to the backend. unlike with patch, you would have to recreate this function witch adds more complexity to it. i tried it and it's a pain in the ass. it also gives a false positive even if the data is not saved. as good and simple this sounds, for my usecase it's not.
While SubmitForm is excellent for straightforward form submissions with built-in validation, Patch provides superior flexibility, efficiency, and control for more complex scenarios, making it a better choice when you need partial updates, custom logic, or operations that don't rely on a form control. Also, Use the Errors function to check if there are any errors related to the DataSource: If( IsEmpty(Errors(DataSource)), Notify("Record saved successfully", NotificationType.Success), Notify("Error saving record: " & First(Errors(DataSource)).Message, NotificationType.Error) )
🍬 Get my free Power Apps Crash Course, access to our free community, and, if you would like, you can book a call with me here: go.superpowerlabs.co/superyoutubelanding ⬅
This is a great video. It was the piece I was missing with using forms. This is clearly the way to go.
Glad you found it helpful! 😎 -- You may like our new community here: whop.com/free-access-56/
You are an excellent instructor. You style is perfect.
Thanks so much! 😊😊
Good job, not rushing through the content. You explain things very well and take the necessary time to go over everything.
Thanks so much!
Thanks a ton!! i went through several videos for using Patch Function - but yours was lucid and really helpful. Keep it up!!!
Thanks so much for the kind words! 😁😁 Join me over in my community, if you haven't already! www.skool.com/power-apps-community
Brilliant explanation of the Patch function Darren. So easily demonstrated. Thank you Darren! Really appreciate these short videos of each of these functions in PowerApps.
Thanks for the kind words! 😊
The best video about the patch. I just search how to focus the gallery on the last item created or updated ? Thanks a lot
Thanks so much for the kind words! That type of stuff keeps me going. 😁👍You should use the Default property of the Gallery and set it to a variable that you SET() right after you do the Patch(). I hope that helps! 😎
@@PowerAppsTutorial Thanks for your answer. with what value do I set my variable when I do the patch?
Darrens video is the one video that made me understand what Patch does and how to use it in Power Automate. Very clear and easy / fun to watch. I took notes because the instruction was so easy but very powerful This one video will help me in my current job
Glad it was helpful!☺️
Excellent patch demo video. Seen many, and this was very clear and easy to follow. I liked that he was showing how the code links up with the list and controls. Going to use this for my work.
Glad it was helpful!
This is outstanding. The information presented was easy to follow--no guesswork on my end regarding how you got from A to B. As a new coder just learning Power Apps for the first time, this delivery method is invaluable.
Glad it was helpful! 😊😁
Be sure to check this out next! ua-cam.com/play/PLMgWds5p226lp-4vyqzEvdB5Oozbu2ELF.html
UA-cam viewer….love your work mate
Thanks so much! 😊👍
Excellent job! I have watched a number of your videos and just registered for your "Power Apps Masterclass." I'm eagerly awaiting the email to the portal. I like the way you explain things and operate with an assumption that some people have built application in different environments and only need some syntax/development environment guidance. Kudos!!!
Hello, @ericgamble8605! I just resent your credentials. The spam filters almost always will snag those emails.
Here is the link to the course: www.skool.com/power-apps-community/classroom/90da163d?md=8ab56687c2cd49f6af7169162aa55e47
Darren, nice explanation. Wiaitng for the next project like "Ticket System".. 🤣 👍
Cool! What system would you like to be seen next? 😃
@@PowerAppsTutorial Smth related to Project Control and/or People Performance. I think those are so embracing as Ticket System. If you could include dashboards with graphics would be nice!
OMG! Wonderful, you made it so easy to understand. I clearly understand to use a Patch( ), and you mentioned and covered the minute details aswell like changes in the save button that should be made after getting your Set( ) variable along with adding the If( ) statement. Highly recommended for anyone who is struggling with patch function especially for beginners. Thanks alot Derren for the video.
You are so welcome! 😃👍👍👍
Thank you Darren for sharing this info. Just a very small remark, (and I know I am a person that can be really on the details 🙂), nothing big, not really important...but here it is: The camera that is recording you is slightly moving from time to time. Maybe you have putten the camera on the desk that you are working on and is moving sometimes a little bit while typing? That's it....but certainly a great video, you are a real master in taking the audience step by step through the proces! Thank you so much! 👍
Yeah, I need to fix that. 😭😭
Always on point with great concise, easy to understand tutorials. Thanks Darren!!
Glad you think so! Thanks! 😊
Crappola! After watching this short and excellent tutorial I feel like my patches are all very sloppy. I never thought to use the same patch for new and edit. Thanks for the info!
Glad to help! 😋👍
Wow thanks for the video help a lot in its simplicity ❤
Glad you liked it! Thanks for watching!
As always amazing content and explanation 💪
Appreciate it!😊
Excellent !!.. Thanks for the tutorial
Its my pleasure😊
Great job 🦅. Enjoy the vids. Form control can def be a pain when you need to customize the user interface.
Thanks! Very true. 😋
Love your style!
Thank you! Cheers!
After I patch the record that I was on doesn't update with the new or revised data until I click off that record and then click back on that record in my gallery. What can I do to "refresh" the record data without having to click off and on the record after I patch?
Are you trying the see the recently submitted record on the Patch form UI??
@@PowerAppsTutorial
Yes
Get on to my free community for quick help www.skool.com/power-apps-community
You explained everything so nicely. I am new to Powerapps and built my first app looking at this video. A small suggestion if I may, please try to zoom in on th code while you are typing in the video, so it becomes a little easy to read it. Thanks again.
Thank you for your suggestion. I'll zoom in more for sure.
Love your crash course what’s next ?
If you're looking reduce your learning curve in the shortest amount of time, you can join my accelerator program for one-on-one mentorship.
Book a call with us if you need this: calendly.com/super-power-labs/student-interest
Can we use the Patch function to update two SharePoint lists that share a common column along with a few other unique columns?
Thanks for the video, and just a small question, how to keep the text stay on the new save item rather than the gallery selected before after click on the save button? Thanks.
Can you post your question to my free community for quick help: www.skool.com/power-apps-community
I am proficient at patching, but still find I like forms in some instances better. This is mostly because of the form.valid property you get with a form. Have you found a way to enforce required fields similar to a form with a patch on a button other than setting conditions on the display mode of the button?
Sometimes I use that method actually, along with providing a label which tells them which field is keeping the button from being enabled. Is there a reason you don't like this method? It's always worked well for me. Thanks for the feedback! 😃
@@PowerAppsTutorial I haven't thought to add a label. The other reason I sometimes prefer a form is it is much easier to create a responsive app with a form, especially if there are a lot of fields.
Dito. I still use form simply bec. there’s still no better way of patching attachments.
very nice.. thank you so much..
Most welcome 😊
I have used patch function cool ,but tried it for dataverse file column to make a new row. But while deleting/editing file with submitForm it doesn't delete it?
Thanks
Thanks for commenting! :) Here you go: ua-cam.com/users/liveWYBfigNtpkA
Great video
Thanks!
I am very new to Power Apps and learning as I go, your video has been very helpful but am stuck on one thing, I am attempting to use a Combobox instead of a text field but am not able to to update the field based on the selected item in the gallery, how do I change this? I have modified the formula to Patch the info to the SP List but cannot get this working for the selected item, can you please help?
Use Combobox.SelectedItem.Value. Did that work?
Yes that worked thanks 👍🏻
HI, thanks a lot I really appreciated; I have one question please if you could make a tutorial about this query. can we make many-to-many relationships in power apps through the share point lists? I already see the one-to-many relationship tutorial
I was actually thinking about this morning as I was waking up! ha. Thanks!
@@PowerAppsTutorial thanks a lot i see the live that u made it was a little bit difficult for me but i will see it again. Really I appreciate your effort and your way to simplify the information.
Welcome! 😊
Question: For patch function to work correctly, do all of your list columns need to be formatted as text or will it work for drop down columns?
Absolutely! It will work with almost all column types!
@@PowerAppsTutorial thank you. I found a video that helps me understand how to write patch codes for choice columns in lists. Can you please do a video on this function?
@@mararamitchpeace I'll add it to my list. Thanks! :)
Great tutorial. If I wanted to set a text box to show an error if the user enters the data incorrectly, for example an extra digit in a phone number, could that be done?
Yes you can, you can update a variable state on the OnChange property of the textbox, then also set the visible property of your label to show error message ☺️
excellent video. really good. explains very easy. as a video suggestion, I don't know if it addresses this non-course content, it would be "send files to sharepoint library". I would like to know which method you use. thank you very much
Are you trying to create a file from poweraps and send files to sharepoint library?? ☺️
Hey Mr. Neese! Loved the video and have a question: When adding a gallery and the text input corresponding with the Title column and it pre-populates with everything that is currently on record within that column. Is there any way to limit these to one specific item in the column? Using the example you have, is there a way to ONLY show one name and it's phone number instead of all the items and rows showing up?
This is a good question, but it's hard to help with technical details here. Feel free to join my free community here where it is easier to help: www.skool.com/power-apps-community
Very nice! Thank you. I've done some Power Apps work, still find the video very useful to demistify Patch even further. I also have a question if I want to have a full sync bet. Dataverse tables and SPO lists - what stragegy would you recommend. I can have the lists for simplicity to be RO, and the actual DV act as the storage for the app. The sync I want to achieve is when the data is modified, i.e. a record added/deleted/updated - the app saves it in the DV and the lists reflect the changes as well. I am contemplating two options: A). Using flows in SharePoint and listen to DV tables change or B). Patching the lists directly from the app (which make this video very relevant). What's your suggestion? Thanks again! Subscirbed. And Liked! 😊👍
Yes, I would use a Power Automate flow for that to synch the data! 😎😎👍👍
Nice tutorial. I have questions. Using SQL View as Data Source, How to update a specific table only?
I am new to Power Apps. I have an empty vertical gallery with sql view as data source. Let say I have a view name SampleView created at SQL. This SampleView has table1 and table2 joined.If I use Sampleview as data source for empty vertical gallery. How can I update record on table2 only?
Let's say I put Text Input named TextInput1 in the gallery. Its value came from table2. If I modified the value of the first row of TextInput1, how can I update it back on table2?
Easy! 😋😋
Patch(Table2, ThisItem, {field1: TextInput1.Text})
@@PowerAppsTutorial Thanks. What if I want to update multiple columns and record in table2? Let say I have TextInput1 and TextInput2 with its data coming from Table2. What to do if I want to top update this two TextInput1 and want not send data back to table2?
@@ojsojs6004 Yep, that code would do it, just add in the other fields. For example:
Patch(Table2, ThisItem, {field1: TextInput1.Text, field2: TextInput2.Text})
That code can be in a save button inside the gallery. Does that make sense? Are you in the Facebook group? learn.powerappstutorial.com/InsidersGroupSurvey
@@PowerAppsTutorial you are awesome. One last question. What if in these TextInput1 and TextInput2,I want to update multiple records/row let say row1 and row2 of table2?
I am not a member of that
Sure, just use two Patch statements for that. The Lookup should pull up the right row to update. 😊👍
This is good content!
Appreciate it!
Much appreciated thanks alot
Welcome! 😁😁
You are perfect 🙂
No, you are! 😂😁👍
This, but with a drop down list instead? I am looking for something super simple like this, but want it to be a set list of pre-determined names so we don't end up with multiple versions of the same words for reporting purposes.
Instead of TextInput.Text, it would be DropdownList.SelectedText.Value. Does that solve it for you?
Man I really want you to give us a better insight regarding, what if i have more power apps lists ?
Let's say I want to have 3 lists, I want to patch data in all of them, they get also linked with each other via a column and then when i want to update them to select 1 item from the gallery and then i will have a flow of screens where i edit each screen of the specific list.
Atm i have a big trouble with this issue and would love a tutorial.
I love it! This is how real applications are. I do have lots of videos here on my channel that go through all this while building real world apps. Here's a good example of just this: ua-cam.com/video/KgP2S_fwxJE/v-deo.html
I really love using patch. I prefer it to using Edit Form field. Although using Edit Form can be a lot easier because all you have to do is create the columns on SharePoint list. But with patch, you can be more dynamic in your development.
Totally agree!
Amazing!
Thank you! Cheers!
Question, how would you go about implementing a scenario we’re the user has to enter their current password, then new password while confirming the new password?
You could have a hidden control that looks up at the selected user and returns the password from the password column ☺️
perfect , Thanks
Thanks
Thanks Mate
You're welcome!😊
I've decided to finally make the switch to using Patch instead of Forms. It ends up taking a lot more work when you're working with tables that have over 20 rows and needing to write a new line for each row, as well as keeping track of every single field and making sure they're pulling the correct data. But I definitely prefer the flexibility it allows.
One issue I'm facing with this method is figuring out the best way to do attachments. I know I can rip the attachment control from a form and use that with a power automate flow, but I'm wondering if you know of a better solution for attaching files without using a form.
Have you tried patching the image directly to a sharepoint image column ?? ☺️
How to patch the lookup column to SharePoint, please help?
Hi there! Thank you for watching the video! If you could join the "Learn Power Apps" community and ask your question in our board, I will be able to give you a complete response for your question: tinyurl.com/PowerPlatformCommunity
How would I patch a checkbox that sits inside a gallery?
You can have a true/false column in your datasource.. In your patch statement, use Checkbox.Value on the column to patch to
Patch is a good function. But what if your datasource has 15 columns or more? You’ll need to hardcode all these columns and this might be a problem in future. And you always need to check if there are any errors or check if all required fields are filled in. So there will be more code. While using the form it will all be checked.
But for such simple two column solutions this might work
Thanks for sharing! I will admit, it is extra work. Almost all my apps have 10-30 fields per screen for edits, and yes, it is a lot of work to add validation and error checking. However, if someone needed an app that had close to 100 or more fields, I'm not going to lie... I'm going to consider using a form! 😂👍👍
Here's an example app I build that has many edit controls across tabs in a screen, if you're interested: ua-cam.com/users/livee7lgFxx-43E?feature=share
@@PowerAppsTutorialthank you! Will check
Welcome! 😊
Hi all, this only works nice with classic controls. However with modern controls the Save Button won't receive the current TextInput, except you click outside the input first...
Found solution: Change TextInput TriggerOutput "FocusOut" to "Key pressed" (or "Delayed")
👍
Hi I am building a voting app. Very simple 10 animals names and people will need to vote a decide which animal they would like to have for their university. However, the problem comes when we want to show after people submit their vote the results. like which animal is winning like a racking who is winning and who is losing. Could you help me please?
You could do a filter and a count/sum function to get the highest submission per animals ☺️
it didn't work for me and i don't know why. they keep telling me "There is an error in this formula."while it's correct
Feel free to book a call with us: calendly.com/super-power-labs/power-apps-success-planning
I've never used forms
Good to hear. 😂
I actually started with forms. My first few apps where based on forms.
Can anyone provide me with mentorship on how to monetize power apps and power automates?
Feel free to book a call with us: calendly.com/super-power-labs/power-apps-success-planning
@@PowerAppsTutorial alright thanks in anticipation
You're Welcome ☺️
super long video but explained well
Glad it was helpful!
But why use patch?
Patch isn't the only option available in PowerApps for saving your records to a database. The patch function has a sort of customizable behavior that makes it stand out from other options.
No. Not patching 49 fields.
Post your questions to our free community here for quick help: www.skool.com/power-apps-community
sounds good but really isn't. form has the on succes property where you can make sure that the user receives a notification on screen if the entered data is truly saved to the backend. unlike with patch, you would have to recreate this function witch adds more complexity to it. i tried it and it's a pain in the ass. it also gives a false positive even if the data is not saved. as good and simple this sounds, for my usecase it's not.
While SubmitForm is excellent for straightforward form submissions with built-in validation, Patch provides superior flexibility, efficiency, and control for more complex scenarios, making it a better choice when you need partial updates, custom logic, or operations that don't rely on a form control.
Also, Use the Errors function to check if there are any errors related to the DataSource:
If(
IsEmpty(Errors(DataSource)),
Notify("Record saved successfully", NotificationType.Success),
Notify("Error saving record: " & First(Errors(DataSource)).Message, NotificationType.Error)
)
Totally agree. Forms should really be discontinued, they create confusion and are really limited.