Latest Posts
GCC solution: “Your org doesn’t allow Microsoft Flow. You’ll need to use your personal email to sign up and get access.”
I’m currently on an adventure into my first GCC (government) tenant. When I went to https://flow.microsoft.com in this new GCC tenant, I got the following error: “That didn’t work. Your org doesn’t allow Microsoft Flow. You’ll need to use your personal email to sign up and get access.” I was in the habit of using …
Add or subtract hours from date/time values in Power BI using M formula in Power Query Editor
Previously, I shared how to transform date/time values in Power BI using DAX. But I’m working on building more using M formulas as those are less resource-intensive and improve report performance. The following was my solution for correcting a time zone issue in which the original data’s date/time column was 5 hours ahead. =[#”Date/Time”] – …
Show/hide fields conditionally in PowerApps forms based on dropdown selection
I’m working on digitizing a form to improve the user experience and our data collection and availability efforts. I decided to do this one in PowerApps as we begin to pivot organizationally toward the modern experience. During building this particular form, I needed to hide fields unless the user indicated “Yes” to corresponding dropdown fields. …
Continue reading “Show/hide fields conditionally in PowerApps forms based on dropdown selection”
Alertus integration in SharePoint via Microsoft Flow
I’m by no means an HTTP request expert, but the requirement of being able to integrate business applications is common and, in this case, important. I took some time to figure out how we could implement Alertus integration and am sharing what worked here. Background Alertus is a program we use at LMH Health to …
Continue reading “Alertus integration in SharePoint via Microsoft Flow”
Capitalize whole words or first letters of each word in Excel cells
Since Excel doesn’t have the same set of robust text transformation tools as Word, we need creative ways to get the same effects sometimes. When it comes to auto-capitalizing whole words or first letters of words, there are two functions you can use: =UPPER() will capitalize the entire cell contents =PROPER() will capitalize first letters …
Continue reading “Capitalize whole words or first letters of each word in Excel cells”
Get Involved
Where's Nate
Your Membership
or log in if already a member.