You're like...a mind reader, Shane. I was facing the challenge with one my large apps where I was a getting an error can't divide by zero; no idea what control was producing it. And then your video comes and that OnError under the App with FirstMessage record...mindblown. Thank you!
This is great and I think this information is what I needed to switch off of using Forms, I don't like that they can auto-layout etc if fields get added/removed etc.
Love this Shane! I've got a new page with galleries which change template size on the count of items.... Division by 0 errors all over the place as it takes a second to load... Probably should pre load, but... I am where I am and this looks great! Think I'd add it to add to a list via automate and then flag to me on teams of its a new fault, not previously in the app. Thanks for the building blocks!
Thank you for this informative video, Shayne! This can help us to debug any error that is not showing on the end-user. Just curious if this OnError includes problem on network or internet? Many thanks!
So I implemented logging in my app. My data source is SQL. Once I implemented this, when a user was editing a form, some fields on the form that the user had filled out, the data was erased. When I removed the error preview feature, the data stayed. I still have the Code evaluating my errors table to see if it is blank on submission after my patch. Have you seen this issue?
@@ShanesCows I mean, I have some questions in different rows in Gallery, for example: 1st have an combobox that can't be empty, 2nd have an txtbox that need be filled with numbers... How can I block the user to patch and show him all errors? Do you Have a way to show me? Thank you
Hi Shane, I think I'm having issues with users ignoring the 'there's a new version of this app available, please refresh...' banner. What are your thoughts on storing the latest version in a SharePoint list, then OnStart: compare the SP stored version to the one hardcoded in the app, and if they are not the same prevent users from doing anything, unless the two match? Or is there a better way?
Another very informative video. I was about to ask how do you find where random error message are coming from but I see that the on error property in combination with Notify will give the location in the notification message. Done and Done. That was starting to bug me. PUN!
Good explanation! But I wonder and did not find ANY information about concurrent patch or form submission for SQL server data. How to handle changes made by other users? ((
@@ShanesCows Thanks for quick respond !) Yes. One user changed data while other users see unchanged (old data) without refreshing Datasource. Yes it about locking record (optimistic or pessimistic). You can open your any test app in two copies and in one change any data. Without refreshing second app do no see changes . The data source should be SP List or SQL db.
You will have to create logic to handle that. You can use the Refresh function on a timer to periodically refresh the data in the app. Or use my check for duplicates logic to check for changes before locking a record. Power Apps isn't going to do anything for you automatically, you will have to code it. 😑 ruclips.net/video/Ap3_Ea9H8b0/видео.html
My problem is that in production one SQL table is not getting patched. However, in my development environment it works perfectly. Development environment has a copy of the production tables but both production and development environments use the same lookups in the production environment. I'm using the set statement, so it looks like the situation where Power Apps handles the error but does not notify that the patch failed.
Sorted that error out but now getting a bizarre error on another app I developed. I have a date table from which I retrieve a diary number this is then used to filter a much larger table. I used the date as int solution to overcome delegation issues with filtering the date table with the date picker. This works fine I then used the diary number returned from the first table to filter a much larger table. However, I am now experiencing a bizarre problem. Every second time I use the date picker; it returns no data in the larger table. For example, start the app and pick 4/1 I get data pick 5/1, and no data is returned. Pick 3/1 data returned pick 4/1 no data returned but then pick 5/1 data returned. Using SQL as the data source. Shane your video on setting up an error log will be very useful in hopefully working out why this is happening.
You're like...a mind reader, Shane. I was facing the challenge with one my large apps where I was a getting an error can't divide by zero; no idea what control was producing it. And then your video comes and that OnError under the App with FirstMessage record...mindblown. Thank you!
Awesome Brendan. I had Chewy keeping an eye on you for you what you needed. :)
Oh Wow!! I wish I had seen this before, but glad to come across this. Thank you very much for posting Shane!!!!
Happy to help 🤩🤩
The god of Power apps, thank you Shane!
Glad that it helped you 🤩
Great video Shane and very needed! Question, would patching to a Sharepoint list for errors be more or less efficient than patching to SQL?
Sql is probably better but to use sql as a datasource requires premium license. If you have that DataVerse is probably the best option. 😎
Thanks Shane! This really saved me. Was exactly what I was looking for
Great to hear!
This is great and I think this information is what I needed to switch off of using Forms, I don't like that they can auto-layout etc if fields get added/removed etc.
Always happy to help someone leave forms. 😎
Thank you again Shane, Exactly the info I was looking for.
My pleasure!
Thank you for your help! Was curious if instead of Patch to SP list can you also send to Power Automate?
Love this Shane! I've got a new page with galleries which change template size on the count of items.... Division by 0 errors all over the place as it takes a second to load... Probably should pre load, but... I am where I am and this looks great!
Think I'd add it to add to a list via automate and then flag to me on teams of its a new fault, not previously in the app.
Thanks for the building blocks!
Thank you for this informative video, Shayne! This can help us to debug any error that is not showing on the end-user.
Just curious if this OnError includes problem on network or internet?
Many thanks!
So I implemented logging in my app. My data source is SQL. Once I implemented this, when a user was editing a form, some fields on the form that the user had filled out, the data was erased. When I removed the error preview feature, the data stayed. I still have the Code evaluating my errors table to see if it is blank on submission after my patch.
Have you seen this issue?
Hi Shelly, I have not. :(
Great session. Thanks a lot 👏
My pleasure!
Great video Shane!
Have u any video about concat errors from gallery before patch to sharepoint list? or something like that?
Thank you in advance
I don't exactly follow. Can you give me more details about what you want to see?
@@ShanesCows I mean, I have some questions in different rows in Gallery, for example: 1st have an combobox that can't be empty, 2nd have an txtbox that need be filled with numbers... How can I block the user to patch and show him all errors? Do you Have a way to show me? Thank you
Hi Shane, I think I'm having issues with users ignoring the 'there's a new version of this app available, please refresh...' banner. What are your thoughts on storing the latest version in a SharePoint list, then OnStart: compare the SP stored version to the one hardcoded in the app, and if they are not the same prevent users from doing anything, unless the two match? Or is there a better way?
ruclips.net/video/Z-5OMRy7G_M/видео.html I have a video that show basically what you described. 😀 I think that is a great way to go.
I've been looking for documentation on what information is available on the AllErrors or FirstError record? Perhaps you have that information?
Sorry Megan I don't have any cheat sheet for it.
Another very informative video. I was about to ask how do you find where random error message are coming from but I see that the on error property in combination with Notify will give the location in the notification message. Done and Done. That was starting to bug me. PUN!
Glad to help!
Yes, I enjoyed it. Thank you Shane
You watched a lot of videos today. Thanks for the nice comments. 😎
Really useful. Can we utilize trace in onerrror property to send each error to Azure app insights?
Yep, that would a great idea Robin :)
Can we access Error.Message outside the notify scope ?
Hello Shane Young. Can we record the Allerrors into SharePoint List
Yes, using Patch.
What are the chances for Multiple errors?. can you please help me with some test cases for creating multiple errors
Hi Shane Young. How To Customize this message "No item to display" ?
Is that the intended behavior for the Set(x,Patch(...)) errors, or a bug? Seems un-PowerApps-ish.
Fair question, I haven't had time to ask them yet but I have it on my list.
Thank you Shane, learned a lot
Good explanation! But I wonder and did not find ANY information about concurrent patch or form submission for SQL server data. How to handle changes made by other users? ((
Are you looking for locking? So 2 people can't edit the same record in SQL? Or something different. Sorry, not sure what your challenge is. :)
@@ShanesCows Thanks for quick respond !) Yes. One user changed data while other users see unchanged (old data) without refreshing Datasource. Yes it about locking record (optimistic or pessimistic). You can open your any test app in two copies and in one change any data. Without refreshing second app do no see changes . The data source should be SP List or SQL db.
You will have to create logic to handle that. You can use the Refresh function on a timer to periodically refresh the data in the app. Or use my check for duplicates logic to check for changes before locking a record. Power Apps isn't going to do anything for you automatically, you will have to code it. 😑 ruclips.net/video/Ap3_Ea9H8b0/видео.html
My problem is that in production one SQL table is not getting patched. However, in my development environment it works perfectly. Development environment has a copy of the production tables but both production and development environments use the same lookups in the production environment. I'm using the set statement, so it looks like the situation where Power Apps handles the error but does not notify that the patch failed.
Sorted that error out but now getting a bizarre error on another app I developed. I have a date table from which I retrieve a diary number this is then used to filter a much larger table. I used the date as int solution to overcome delegation issues with filtering the date table with the date picker.
This works fine I then used the diary number returned from the first table to filter a much larger table.
However, I am now experiencing a bizarre problem. Every second time I use the date picker; it returns no data in the larger table. For example, start the app and pick 4/1 I get data pick 5/1, and no data is returned. Pick 3/1 data returned pick 4/1 no data returned but then pick 5/1 data returned. Using SQL as the data source.
Shane your video on setting up an error log will be very useful in hopefully working out why this is happening.
Thanks Shane 🙏🙏🙏
Happy to help 🥰
Great knowledge.
Thanks. 😎
Make a video Using Dataflow how to add data to Dataverse Table when a new file is uploaded Model Driven App
Noted.
Does anyone else say "Heeeeeerrrrs our intro" with Shane? Please let me know that I am not alone.
Thousands of people are with you Brandon. 🤪 In person when people meet me for the first time that is a very common lead off. 😎
@@ShanesCows Thank goodness I am not alone.
Ohh Its really Angry! Its mad😆😆
😎