Author Archives
I am a software engineer, business and systems analyst, program manager, and technical architect with a passion for delivering business strategy and technology. Over the past 15 years I have partnered with dozens of employers and clients to achieve goals across the corporate landscape.
-
MongoDB Update With and Without Set Operator
MongoDB Update A quick update to the developer notebook: have you tried using the MongoDB update command with-and-without the $set operator? Generally, when you want to update a document in a collection, you will select from: updateMany: updates multiple documents… Read More ›
-
Angular – Return Multiple Results from Custom Validator
Angular Custom Validator This is a quick addition to the knowledge base, answering: how do I return multiple validation results on the same control from my custom validator? For supporting documentation on how to add custom validators to reactive and… Read More ›
-
Microsoft PowerApps – Tickets in SharePoint and SQL – Append Text Fields
Our PowerApps canvas app currently reads customers from a SharePoint list and also provides a way to contact customers with a “Send E-Mail” screeen. In this post, we expand the app once again so that it now includes a ticket… Read More ›
-
Microsoft PowerApps – E-Mail App for SharePoint Contacts
The customer directory app started in the previous posts will now be enhanced by adding integration with SharePoint and providing a lightweight interface to contact customers via e-mail directly within the app. SharePoint Data Source in PowerApps Customers will now… Read More ›
-
Microsoft PowerApps – Filter Collection using List Box Control and Distinct
Let’s continue building on the customers list from the previous post by demonstrating how we can filter the collection that drives our customers data table. Our simple filter UI will be built using a List Box control and will also… Read More ›
-
Microsoft PowerApps – Customer Data Table with Collections
This post covers how to use Collection functions to work with a list of business customers, displayed in a Data Table control, in Microsoft PowerApps. Future posts will refine this example into a real-world final release which integrates SharePoint as… Read More ›
-
Microsoft Dynamics 365 Advanced Find
This is a quick post to highlight the default location for Advanced Find in Microsoft Dynamics 365. I’m taking screenshots from an on-premises tenant. I was compiling documentation and wanted to cover the topic, “How to find the Microsoft Dynamics… Read More ›
-
SharePoint – Issue with Hidden Title Column and Quick Edit Mode for Lists
I ran into an unexpected issue today working in Quick Edit mode on a SharePoint List. Specifically, I couldn’t add new items based on a custom content type where I’ve hidden the Title column. Quick Edit is requiring a value… Read More ›
-
Power BI – Sales and Expense Report – Negative Numbers with DAX CONTAINSSTRING
When looking at sales income versus expense values in Microsoft Power BI, you can easily turn expense / cost values into negative numbers using DAX formulas. I’ll demonstrate a scenario using CONTAINSSTRING to convert numerical values imported from Microsoft Excel… Read More ›
-
Power BI – Sales and Expense Reports – Prepare Excel Tables from Office 365 SharePoint
Power BI can connect to Microsoft Excel files in your Office 365 SharePoint sites to produce powerful reports. You can then publish those reports and create dashboards using the Power BI Service in Office 365. In this first of two… Read More ›
