I have rendered a SQL view in PowerApps in the form of a data table. The table itself, is pretty simple – four columns and multiple rows. The business problem I wanted to fix was as follows:I only want to show rows where a count of a field for a given row is equal to … Continue reading PowerApps Sort & Filter A Data Table (When SQL Is Your Source)
In previous posts, I have mentioned how much I like using PowerApps and for the advanced IW/part-time entry-level dev, it is a super-powerful platform. One of the features I have wanted to use is the PDF viewer. Now, you will notice within PowerApps this is listed as an experimental feature. A quick Bing search and … Continue reading PowerApps PDF Viewer – WORKING Solution!
I’ve been experiencing a strange issue. Windows 10 on a Surface Book 3 connected to an external HDMI device (in this case an LG TV or a Samsung Series 8 TV). Picture was fine, just no audio. I finally got around to troubleshooting the issue and this is a strange one.I cannot pinpoint exactly which … Continue reading Windows 10 & HDMI Audio
I purchased a new HP printer which included remote printing capabilities (which is actually more useful than you would expect). It worked fine from my work email address, but failed from my personal email, which is a custom domain hosted on Microsoft Office 365 I have never had any kind of issue with the domain, … Continue reading HP ePrint, DMARC & Office 365
There’s a few blogs out there which try to explain the problem and solutions. I looked at them and found that they were not always the easiest to wrap your head around. So, here is my solution which is hopefully a bit easier to understand and implement in your environment if needed. The Business … Continue reading DAX & The Month-over-Month Delta
Like many others, I do not want displayed measures in my PowerBI to show (blank) – it’s generally too ambiguous and just plain ugly. I generally use an IF statement in my DAX code to replace (blank) with 0, as that is a more accurate representation of my data. There is another issue….I have experienced … Continue reading PowerBI & That Pesky (blank) & Our Friend The BOOLEAN
Off track a little for my usual posts.....I purchased some AirPods at Christmas and been having a lot of issues. Intermittent connectivity, call audio not routing properly, Siri audio not routing etc. just extremely frustrating. Spoke to Apple Support who sent a replacement pair. Pretty much the same issue. So after some researching, discovered a … Continue reading Apple AirPods & Tile
How do you bulk upload data to a SharePoint Online list? I am sure for many businesses this is a common task. For the last few weeks, I had a very effective albeit manual solution: Have a list of the data I wish to upload in an Excel file, structured to match my columns on … Continue reading The Bulk Uploading Of Data (Programmatically) To A SharePoint Online List
I am currently in the middle of creating some custom tooling and surfacing the outcomes in PowerBI. I created a DAX measure to provide some insights as to whether a trip was currently in-progress or had concluded. Writing the measure was fairly straightforward using a combination of a custom calculated column based on cross-referencing the … Continue reading Changing (Blank) To Numeric Zero
This is the excerpt for your very first post.