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 ›
Office 365 and O365
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 ›
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 ›
Office 365 SharePoint – Content Approval – Critical Non Repudiation Security Flaw
This post covers a critical security flaw in Office 365 SharePoint with the Content Approval feature and version history. I’m hoping it’s fixed by the time you read this, but I was told it is “by design” first by the… Read More ›
Power BI Expense Reports – Global Currency Support in Office 365
In this post, Power BI Expense Reports will be created Office 365 using SharePoint. You’ll see how to create an expense report solution that easily accounts for your team’s global presence and globally accrued expenses. Below I demonstrate how to… Read More ›
Office 365 SharePoint Usage Report with Microsoft Excel PivotChart
Recently, I posted how one can use the Microsoft Excel WEEKDAY function to help clean-up and provide a tabular report on monthly Office 365 SharePoint Usage. This post is a follow-up where I’ll demonstrate how you actually create the visual… Read More ›