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 Power Apps – E-Mail App for SharePoint Contacts
Microsoft Power Apps with SharePoint and E-Mail The Microsoft Power Apps customer directory started in the previous post will now be enhanced. This post demonstrates how to add integration with SharePoint and providing a lightweight interface to contact customers via… 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 DAX CONTAINSSTRING – Sales and Expense Report
Power BI DAX CONTAINSSTRING in an Expense Report When looking at sales income versus expense values in Microsoft Power BI, you can easily turn expense / cost values into negative numbers using the Power BI DAX CONTAINSSTRING formula. I’ll demonstrate… 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 Start Date – Change the Date and Move Deadlines Microsoft Project has a few ways to change a project start date. If you have Task Deadlines and don’t choose the right method for making the project start date… Read More ›
-
Excel Stock Trading Spreadsheet using NETWORKDAYS
This is a post on how to use NETWORKDAYS in an Excel Stock Trading Spreadsheet. Use this workbook to help you track your average profits over your total number of trading days. In practice, Microsoft Excel is a great tool… Read More ›