The Algebra Teacher Powers to B.I.

 Often times after showing how you can delete a record in Power Apps I will see some nervous faces in the crowd.  Even if that crowd is all virtual nowadays.  I always assume they look nervous because they realize the power their end users have with being able to delete records quickly, easily, and sometimes by mistake within the application.  If this is you, I've got several ways how to safeguard against this. I have recorded two previous videos on how to handle these issues.  The first video walks you through how to set up a confirmation screen before the user executes the deletion of a record.  My second video shows how you can delete it from one table, but then insert that same record in an archive table.   In this video, I show how to make it seem like the user has deleted the record, but in actuality, the record is just hidden from the gallery view and we change the value of one of our columns attached to the record.  This approach is u...

 Power Apps is great for allowing users to create new records that get submitted to a data source.  A question I normally receive after someone learns how to use Power Apps is "Can I send or receive emails after a record has been created?"  The answer is a resounding yes.     There are a few different ways to send emails through Power Apps, but I want to showcase how you can set up an automatic email process through Power Automate that is connected to the same data source that your app is connected to.   In this first video, I am going to showcase the basic method of how to send an email after a record has been created.   Depending upon the data source you may need to make a few modifications to the basics.   I will troubleshoot first how to change the display of a date value that you have stored and are reporting over.     Keep a lookout for my next blog/video where I will show how to deal with the pesky issue of having a lo...

 As a former Algebra and Algebra 2 teacher, I dealt with summing up numbers on a daily basis.  In Power Apps, we might forget that you can sum numbers as well.  Summing values is not just for Algebra teachers, Power BI users, and Excel users ;) In this video, I show how you can do a basic sum of a column from your data source.  I then go a step further and show how you can sum up a column with a filter applied to that table. Later in the video, I show how you can sum up numbers from the inputs of your users in the application itself.  Finally, I show how you can collect that sum from your user and then submit that value back to your data source. If you enjoy this video, my other videos, or any of my blogs and are interested in formal training on Power BI, Power Apps, Azure, or other Microsoft products you can use my code "Matt20" at check out when purchasing any private training or On-Demand Learning classes from https://pragmaticworks.com/pricing/

 During my training session with Power Apps, I'm often asked if you filter the records shown in a gallery to only show based on either who created the record or who the record is assigned to.  The simple answer is "Yes!".  To do this, however, there are a few things to keep in mind. 1) In your data source you will need a column that contains some kind of identifying information of who is assigned the record. 2) If you are filtering based on email addresses you could run into a delegation warning. 3) You can filter your records either based on the currently logged-in user or by having a drop-down selection of the individual email addresses/identifiers assigned to your record. Take a look below and how this can be accomplished in your app.