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.
-
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 ›
-
Microsoft Project – Change Project Start Date and Move Deadlines
Microsoft Project has a few ways to update a project start date, but if you have Task Deadlines, your project schedule could incur an unwanted side effect if you don’t choose the right method for making the project start date… Read More ›
-
Microsoft Excel – Quick Day Trading Averages using NETWORKDAYS
This is a post on how to use NETWORKDAYS in Microsoft Excel to help you track your average profits over your total number of trading days. In practice, Microsoft Excel is a great tool for tracking your day trading gain/loss… Read More ›
