Power Apps Errors Function when using Patch and other data source changes

[@AdiCristea]

Holy Mole Guacamole, now I can even collect and save those errors back to my DB so when users tell me they've got an error message (which obviously now is gone), I know EXACTLY what the issue was. But what if there's an error when patching back the errors, hmmm, that's an inception situation. Thank you, Shane, fine as wine as always!

[@ShanesCows]

Adi I ♥ your feedback on these videos. Thanks!

[@MichaelDeBlasis1369]

I was just thinking the same thing! =)

[@shaantoshholaay3310]

Purely practical example. Thank you very much Shane. You are the legend of the powerapps

[@ShanesCows]

Glad you liked it.

[@MichaelDeBlasis1369]

The errors table is so much more informative than the monitor or error messages themselves. I love how you can easily find errors that way. Also I'm def not filling the gaps here so your class is needed. I also JUST learned that you can set blank value as a property in a dropdown hahaha! yet I was able to create an HTML doc and link it to a flow earlier this week. GEEEZ lots to learn still.....

[@tamarawattenberg3454]

You rock! I watch a ton of your stuff. You are practically a co-worker. :) Thanks for all you do!

[@n2datasolutions443]

Perfect timing releasing this video, literally what I'm looking into now! Good content 👌

[@ShanesCows]

Glad to hear it!

[@ArohShukla]

awesome video Shane.. something I was struggling in my app. You explained the concepts so well...

[@ShanesCows]

Awesome 😎

[@RobFahndrich1]

Awesome! This makes me want to create a SUBMIT ERROR button that sends the error contents, page, user, time, etc to an "Issue Tracker" SP List. heck, do away with the button and have it happen automagically in the background! Thanks again Shane!

[@ShanesCows]

That is perfect Rob! I do that in some apps. If they get an error in a way that I never imagined should be possible I email me automatically. 😀

[@umarfarooq2813]

Hi, I have a text field, in which, I am getting the value using the Sum function outputs the total number of virtual machines present in the gallery. Now, on the onChange of this this text field, I have put the Patch function to update the SharePoint list. However, when the total value changes it is not updating the SharePoint list. What do you think I could be doing wrong?

[@TyRey]

Good one. I like these quick hit videos as well as your longer ones.

[@ShanesCows]

Thanks Tyler. Glad you like them!

[@nandhineesundaresan3961]

Hi. How to stay in the same screen with error messages when we dont submit a form but patch few records? I have submitted another form and validated by using the mail and navigate function in the "Onsuccess" of the form. However in the current form, I dont use SubmitForm rather Patch the records for which I could not make it stay on the same screen and prevent it from sending mails if all required fields not filled. Tried using !IsBlank in Onchange of the textboxes, tried Errors function too but nothing works. Please help Shane..

[@golfnutt8]

What if my fields in my SharePoint list are set to "not required" and my DataCard(s) in Power Apps are required, based on a condition when data is added to certain fields? If I dont fill in the required field, my patch still submits the data using the Errors function even though I have DataCard's that are set to required. If I go into SharePoint and set those fields to required and run the patch again, the errors' function traps the errors and doesnt allow the patch to complete.

[@ShanesCows]

If you want to have it so they can't submit if the field is empty then disable the button instead of looking for an error after they do. kzbin.info/www/bejne/jZ26hWOijLl6i5o

[@golfnutt8]

@@ShanesCows Thanks Shane thanks for your response, I now hide or show the submit button only if the formula produces a true result

[@raulrossi8248]

Hi Shane, my PowerApps has a semicolon instead of a comma, where can I change that setting?

[@ShanesCows]

You cannot. It is because your region uses a , as the decimal separator instead of a . You will also need to use ;; where I use ;

[@raulrossi8248]

@@ShanesCows THX

[@Mx81]

Short and helpful. Love it! I prefer Patch over Submit, so I really often use the errors-function. But concerning user experience, don’t use notification with 3 (milliseconds) that’s too fast - even for your followers. ;) I would love to see more of this kind of videos... maybe concerning table „modification“ like Addcolumns, Showcolumns and also group and ungroup.

[@ShanesCows]

Glad it was helpful! And thanks for the ideas.

[@wendymason3263]

Thank you yet again, just love your videos 🥰🥰🥰

[@ShanesCows]

You are so welcome!

[@mikegc3816]

Hi Shane, if you had say 10 fields, would you still validate all of them all in the displaymode property -thanks Mike

[@pal828282]

Perfect! Just what I was looking for! Thank you!

[@ShanesCows]

Glad it was helpful!

[@ernaniramos9221]

Hi Shane, good day! tried doing this but may patch function created the item even my columns are set to be required. Thanks

[@ShanesCows]

Sorry I am slow. I am not sure. :(

[@escobark4153]

Hi, how if i would like to show a success message if the data is patched successfully in the excel file in my one drive? Thank you

[@ShanesCows]

Use the Notify function kzbin.info/www/bejne/hKvLqIeojaZgmbM

[@cynchleeminho7245]

Hello Shane, I am having a problem in my "Patch" formula..this is the error message.."Invalid argument type (Boolean), Expecting a Record value instead." What should I do? Thanks

[@ShanesCows]

This video should help. kzbin.info/www/bejne/naTOYmd6YqiMiKc you are trying to patch a complex column.

[@cynchleeminho7245]

@@ShanesCows Thanks again.

[@akshaynm]

One more great video Shane .....!!!! Thanks a lot.... 🙂🙂🙂

[@ShanesCows]

My pleasure!

[@galinagolant]

Thank you!!! Need to use more Errors function in my apps. Also need to learn how to email errors to a developer.

[@Toyworld2018]

I am getting below error when my app loading “Network error when using patch function: you don’t have permission to create this row”. I have permissions and able to patch the values. Can you please help

[@simonball5602]

More great stuff Shane. Many thanks.

[@ShanesCows]

Thanks Simon :)

[@dichternebel01]

Nice one but what if there is instead of a data source a Flow which is triggered by the button. Could I use the errorfunction for this as well?

[@renemartinez8322]

I have a question? how can validate if a procedure was execute correctly, it is procedure is into powerautomate and is a store procedure sql server, thank you for your videos

[@ShanesCows]

You would write logic in the flow to check things are good and then respond to Power Apps with the yes or no

[@renemartinez8322]

@@ShanesCows, thank you for your answer, I would like to see it in your video.😁

[@bobleach]

Hi Shane, this is great thank you very much. However I'm getting a problem with this. If I try and Patch a new record, the error pops up, however if I'm trying to Patch an existing record, the error does not popup. I'm mainly interested in People Columns, and showing when the person does not exist (they have left the company). Also to hopefully show ETag Mismatch errors too. Any way of getting this to work with existing records? Am I doing anything wrong?

[@gwenmac1601]

I've waited patiently - thank you

[@ShanesCows]

Hope you like it!

[@mozgus79ify]

Thank you Shane! Life saver i didn't have a clue about.

[@ShanesCows]

You are welcome. No idea why it took me so long to make this.

[@marienaalvarez8235]

Thanks Shane you are the best! I am having an Issue with a table in SQL it does not allow me to change any rows: “ the target table cannot have any enabled triggers if statement contains an output clause without into clause” Do you have any videos referring this topic?? Thanks so much

[@ShanesCows]

Tables with triggers are not supported for write operations 😔 There isn’t a workaround. You will have to write to a different table or remove the Sql triggers

[@edobaria]

@shane Any recommendations on selecting a backend data source for PowerApps? Which data source you would prefer for the large data set, Azure SQL server or SharePoint?

[@ShanesCows]

Sql if you have a premium license for Power Apps

[@edobaria]

Thanks a lot, ​@@ShanesCows! and what about data verse vs Azure SQL for the same (large data set)?

[@BokyJ]

Hi Shane, again :) I have a problem with Patch function. When I wrote the code (all names are spelled correctly) I got this error - the specified column '_' does not exist. The column with most similar name is 'ID'. I have SP list with basic names for column, FirstName, LastName, Department...etc. I never use '_' in the names for this list. Anu suggestions please, I spend hours and hours for this error.

[@sohananahid5302]

Hi @Shane , Good day! There is a Power Apps App at our work we are developing now for users to book/schedule different Training events for their teams. It uses 3 SharePoint Lists of Training activities to organize [add a new event, edit an existing event already scheduled]. The Add a new booking event [using the same SP lists] works OK. But when I try to edit an existing event [like change the start and/ end date, etc.], as the Power Apps tries to update the info [using Patch() function] in the existing record in the Share Point List of training events - I am getting a "network error when using Patch function. An error occurred on the server." The update doesn't happen. Not sure what is this error pointing to. I would appreciate it a lot if you could advise something. Many thanks, Sohana

[@sakshi4369]

I’m facing a save conflict error randomly when editing a record in Sharepoint list. It just comes up randomly, I’m submitting multiple forms in patch. Please help 🥺

[@rothaem9140]

This works perfectly with my dropdown menus. How do I get it to check for empty Text fields before submitting or navigating to next page.

[@vijaydesai20]

doesn't works when used with ForAll. can you please guide

[@lfish894]

Your a don Shane! Learnt a lot from you! Thank you

[@ShanesCows]

😎 Glad to help 😎

[@golfnutt8]

Hi Shane, Thanks for the videos you post! They are very helpful to us who continue to learn how to use Power Apps. What should I look for if my error message is obscure like "network error when using patch function the requested operation is invalid"? I've posted to the forums and not getting any help there. Is my SharePoint list corrupt? I hate the thought of rebuilding everything.

[@ShanesCows]

YOu are patching the control and not the value Errors - Patch(DataSource, Defaults(DataSource), {Title: textinput}) Works - Patch(DataSource, Defaults(DataSource), {Title: textinput.Text}) ControlName.Text or ControlName.Value etc

[@aagautham9239]

This was a really helpful to me , thanks!!

[@ShanesCows]

I'm so glad!

[@emma6596]

Hi Shane, thank you for this video. I have a custom form on SharePoint list and I tried you approach to handle: 1) If the user don't have the privilege to modify record 2) If a field is not duplicate (there is a unique costraint on SPO list). The app catch the different errors (code 1 and code 8) but if I dont't refresh the page making some test switching between the two errors I see the correct error only the first time. The following times I always see the error with max code - 8 - (both using Last(MyList).Message and First(MyList).Message)). I see the correct error only if I close the form and refresh the page. Any suggestion?

[@aarondeimund9511]

Another great video. Thank you!

[@ShanesCows]

Glad you enjoyed it!

[@michaelseerup]

Great video, learned alot. But what if the error is in a connected flow?

[@ShanesCows]

That is a different can of words. You would add logic to flow to deal with its problems.

[@AnandAnand-ii6ef]

Hi Shane.. thanks for the tutorial. Is it possible to get error details when patching gallery items using ForAll.. I have a bulk update and unable to identify the line item which got failed

[@ShanesCows]

Not sure, I haven't tried. Maybe collect the failures in a collection?

[@AnandAnand-ii6ef]

@@ShanesCows Thanks Shane.. yes, Adding a collection is working to get the desired result👍💥

[@lauramay1494]

Another great learning video. Have you seem the Patch error "network error when using patch function: conflicts exist with changes on the server, please reload" I am saving a bunch of metadata into a collection. User selects one record fromthe collection. This is presented back to the user in a meaningful way by populating the fields/dropdowns of an Edit form with the content of the record they selected from the collection, so the user can see what they are are about to save to the dataverse table Then I patch a new record to the Dataverse table from the EditForm Ive used this method before we success, but all of a sudden im now seeing: "network error when using patch function: conflicts exist with changes on the server, please reload" Any ideas very welcome Thank you Shane!

[@lauramay1494]

In writing this out, I seem to have found my own answer. Posting incase anyone else comes across this issue Nothing to do with the method of patch or data sources or network. It was simply that I was patching a field with a fixed value and this field was a 'key' column so cannot accept non-unique values. Not a very helpful error message from microsoft, nevertheless it's working and I learnt how to put error messages on patches - thanks Shane!

[@ShanesCows]

Glad you got it figured out and Thanks for sharing. 😀

[@rockstar-g5p]

Great Video! How would you trap an error when calling the Office365Outlook.V4CalendarPostItem function?

[@deividspiv6659]

Hello everyone, i need help when i try to save info in a table of sharepoint i get an error it says that the serever has an error can someone helpme please i can save info from mi pc app but no in the mobile app

[@ShanesCows]

I am not sure why, that doesn't make sense it would work from one but not the other. Are you logged in as the same account.

[@deividspiv6659]

​ @Shane Young i solved this error it was an error in my licence of microsoft, but thanks Shane!

[@juansepowerplatform]

Thank you Sensei, in your example above will the error prevent you from patching incorrect data to your source, or will it just stop you from moving forward but bad data will still be patched. or another way to ask the question, if it finds an error then the patch as whole won't happen?

[@ShanesCows]

In my example the Patch fails. So nothing is written to my Data Source.

[@meryemgazanayi5665]

"This App Stopped Working. Try Refreshing Your Browser "im facing this error after publishing my app ,Shane plz do u have any suggestion to fix this error

[@ShanesCows]

No, I haven't ran into that one :( Sorry

[@stanleym69]

i didn't realist ifError was a preview. I thought i had watched a video ages ago where you used it in a patch of a collection to sharepoint. However, cant find it now. I have used it in a solution i built a while back. Might have to revisit my approach. Thanks

[@ShanesCows]

I don’t think I did but who knows. I have so many videos. 😂

[@subbub8826]

There's a problem with power Apps Studio right now. Please try again later Failed to obtain authoring session token from RP. Cannot read property payload of null That type of error is occurring. So if any reason can you please reply to me.

[@ShanesCows]

I don't know. Sorry

[@derek_shannon]

Awesome, Shane! My eternal error is when using Office365Users.UserPhotoMetadata or Office365Users.UserProfileV2 -- Basically a user isn't found any longer, and there is a red banner runtime error that scares app users even if the only app impact is not being able to load a profile picture. UserPhotoMetadata -> HasPhoto to make sure the picture exists seems to throw an error in and of itself. I've also tried to filter using !IsBlankOrError on the email address collection, but to no avail. Any thoughts? I wouldn't be able to clear out the outdated users within the app as they come from different source systems. But I do have a trick where I maintain a SharePoint list used to lookup the Office365 user profile from source system text string names, which vary First Last / Last, First, etc., maybe mentioning that workaround will help others ;-D

[@ShanesCows]

If(!IsBlank(emailaddress), show image formula, false) should do it?

[@derek_shannon]

@@ShanesCows Thanks so much for taking the time to reply, Super Shane! I have tried various combinations of IsBlank and IsBlankOrError--The departed colleagues tend to still have an email (so not blank) but a runtime issue with the Office365Users call, and checking for an error seems to trigger the error--So I am actually reaching out to my MS contacts to just suggest a feature where this runtime red banner be turned off on a per app basis, perhaps?

[@mblherry]

Hi Shane, nice video - thanks. Have ever had an issue with your edit form formName.Unsaved always true?

[@ShanesCows]

Yes, if you have something dynamic in your form. LIke a formula or a variable then it will always be "unsaved" :(

[@ZorroZoroZ]

Thanks a lot for your content, I became a pro in a couple of week following this channel. For a new entry in my team I am looking for a similar channel easy and well organized about Dataverse Customizatios: develop plugins, custom workflow, entity datamodel and so on do you have something to suggest?

[@ShanesCows]

I don’t. Sorry

[@JD-lx3cx]

That is wonderful, thank you for sharing! I wonder how to support bilingual in Canvas app. If you could make a video for implement bilinguals in Canvas app, that would be greatly appreciated.

[@ShanesCows]

I have this on my list of to do's. I build a couple for clients so have the logic all done. Just need to build an app.

[@JD-lx3cx]

@@ShanesCows Looking forward to that. Thank you Shane!

[@IntellezyLearning]

Great video!

[@ShanesCows]

Glad you enjoyed it

[@charlesgranberry4785]

Good stuff! Subscribed...

[@ShanesCows]

Thanks for the sub!

[@MrTonyradford]

Nice one. Thanks.

[@ShanesCows]

You bet

[@aarondeimund9511]

It would also be great to see all the errors in one screen if there are more than one.

[@ShanesCows]

Good suggestion

[@AdeebAbuAlrob]

Hi Shane, How are you doing? This Adeeb, Im a big Fan for your channel. I wish to have a video about two collections with multiple columns in each one of them but both collections have one common column (eg. User Email) so I need you to develop one canvas powerapps screen to find the delta records (using loops). I hope my request is clear.

[@ShanesCows]

What you want to do is covered in here. It is a different scenario but the same logic. kzbin.info/www/bejne/j4rMq5SOa8yLjZI

[@sundrapillay6668]

Thanks Shane

[@ShanesCows]

😀 Happy to help!

[@louisbertini]

Thank you!

[@ShanesCows]

You're welcome!

[@joseguzman5875]

this is awesome! this reminds of trycatch

[@ShanesCows]

Thanks 😀

[@SAULSM17]

Gracias Chenito Joven

[@ShanesCows]

🐶

[@shuntianli9651]

perfect!

[@ShanesCows]

Thanks!

[@issiewizzie]

Goodness I remember the good old days of CBTNuggets ..lol

[@ShanesCows]

Now you get crazy people like me on KZbin 😂

[@issiewizzie]

@@ShanesCows The word we are looking for is “Evolved”😜😜😜

[@dreamweaver9962]

Again I'm the first :)

[@ShanesCows]

Love it! 🐶