Skip to content
Recent
  • Create a Mailbox Monitoring Solution
  • Launch Native iPhone Apps from Power Apps
  • Simple and powerful single screen app for new Office 365 group requests
  • Nesting Functions in Power Apps
  • Format Text as Currency in Power Apps
Tuesday, March 02, 2021
Easy Power Platform

Transforming ideas into amazing business solutions

  • Home
  • Home

Create a Mailbox Monitoring Solution

November 25, 2020December 3, 2020 N. Milligan1 Comment on Create a Mailbox Monitoring Solution

Self-paced Workshop I wonder how many of us use shared mailboxes to funnel work? How well does a shared mailbox, on its own, work. Do all team members do their fair share of the work answering messages from the shared mailbox or does social loafing run rampant? Maybe it is time to consider moRead More…

Tagged Microsoft Outlook Power BI

Launch Native iPhone Apps from Power Apps

October 26, 2020October 26, 2020 N. Milligan

When I made my first app with Microsoft Power Apps, I was so excited and impressed by the relative ease to quickly create a useful and functioning app. It was great getting an app in the hands of co-workers and other users, fast. As I create more and more apps, I have learned that it is not alwaRead More…

Tagged Make phone call from Power Apps PowerApps PowerApps on iPhone Send Text from Power Apps

Simple and powerful single screen app for new Office 365 group requests

September 14, 2020September 9, 2020 N. Milligan

In a previous post Embed a Power App on a SharePoint page, I shared how I like to deploy apps by embedding the apps in SharePoint. I find it to be one of the easiest ways to distribute an app to a wide audience for access on primary devices with very little need for end-user training. A few commentRead More…

Tagged collections display mode PowerApps

Nesting Functions in Power Apps

September 7, 2020August 28, 2020 N. Milligan

I love Excel and sometimes I wish I could use all of the same Excel functions in Power Apps but I can’t so I nest (enclose one function within another function) a lot of functions instead. In my example Technology Loaner Request app, users are able to request laptops and phones. There are severaRead More…

Tagged CountIf IsBlank PowerApps SharePoint

Format Text as Currency in Power Apps

August 31, 2020August 31, 2020 N. Milligan

One of the greatest things about Power Apps is that app development is more accessible to process owners and process workers. Whoever may be closest to a problem or inefficiency has an opportunity to make something better. There is a learning curve and sometimes documentation is not available and sRead More…

Tagged currency format PowerApps

Embed Power Apps on a SharePoint Page

August 24, 2020August 28, 2020 N. Milligan

It is worth taking the time to add some functional features to SharePoint pages. SharePoint is already a wealth of information and an obvious search starting point but by embedding Power Apps onto SharePoint pages, SharePoint becomes the starting point for workflow as well. There is less need to knRead More…

Tagged PowerApps SharePoint

Send Automatic Power BI Notifications to Email, Mobile Device and Microsoft Teams

August 20, 2020August 28, 2020 N. Milligan

Power BI is becoming an indispensable enterprise tool for re-imagining business processes, monitoring work flow and reporting. Adding automatic notifications makes this good thing even better. Power BI Here’s what you’ll need: Access to Power BI service (free license works)Access to an alrRead More…

Tagged Microsoft Teams Power BI

Filter for “Not In” Scenarios in Power Apps

August 18, 2020August 28, 2020 N. Milligan

Power Apps is equipped with a lot of great functions. Unfortunately, Not In is not an available function but there are ways to get the same result. In the example below, there are a list of users in a gallery. The list is displayed by the following code entered in the Items box for the gallery:ORead More…

Tagged Filter gallery Not In Office365Users PowerApps Search

Hide Pesky Default Messages in Single Page Power Apps

May 5, 2020August 28, 2020 N. Milligan

I like single page apps. One with a little gallery and a little form, a button, a title and voila, it’s good to go. Unfortunately, Microsoft has added some not so useful text in the form. You’ve probably been exasperated by it before. The dreaded No Item to Display -or worse- Getting Your Data seemRead More…

Tagged PowerApps

Add Power BI Reports and Power Apps to Microsoft Teams

April 17, 2020August 28, 2020 N. Milligan

Teams can literally be a one-stop shop for work in a modern business. Adding Power BI and Power Apps tabs make it even more powerful and convenient. Add a Power BI Reports tab in Teams In Microsoft Teams, click the desired team.Click the + on the header bar.On the Add a tab window, click PoweRead More…

Tagged Microsoft Teams Power BI PowerApps

Swap Controls in PowerApps

March 16, 2020August 28, 2020 N. Milligan

I really enjoy working with PowerApps but I cannot say the same about the default form controls. I suppose my SharePoint list datasource is to blame but I prefer to keep the SharePoint columns as simple as possible. Unless my SharePoint list columns contain dates, people’s names, numbers or many liRead More…

Tagged Radio Control Text Control

More ways to work with errors in PowerApps

March 12, 2020August 28, 2020 N. Milligan

In the last post, Handling Errors in PowerApps, I discussed a way to prevent errors by disabling submit buttons until all required fields are completed and how to display custom error text for a data card based upon another data card’s value. That post spawned some questions which are the focus Read More…

Tagged Error Handling

Customize Your PowerApps Browse Screen with Multiple Galleries

March 9, 2020August 28, 2020 N. Milligan

I like to make each PowerApps app look like an app. A colleague of mine noticed this about apps I develop and told me that’s what I did. It had not really dawned on me. It is not enough for me to simply make the app function, I must design the app. I must think about how the user will interact withRead More…

Tagged BrowseScreen gallery PowerApps

Handling Errors in PowerApps

March 7, 2020August 28, 2020 N. Milligan1 Comment on Handling Errors in PowerApps

One of the easiest ways to deal with errors in a PowerApps form is to prevent them and stopping end-users from submitting incomplete forms is the quickest way to getting good data. Required Fields Disable Form Submit Buttons in One Step The Error property of PowerApps forms contain a builtRead More…

Tagged Error Handling PowerApps

UnPivot columns in Microsoft Power BI and your data may stop adding up

February 19, 2020August 28, 2020 N. Milligan

Unpivot Columns In Power BI, Unpivot Columns transforms columns into rows with attributes and values. In other words, it changes the data structure and as a result it can change values in a visualization. Other ColumnsApplesOrangesBananas12344212 In the table above, we can sum thRead More…

Tagged Power BI

Use Timers to Automate Success Screens in PowerApps

February 16, 2020August 28, 2020 N. Milligan

I am not the biggest fan of Success screens but I have started adding them to a few apps I developed. Why? In the right app, a Success screen can add value. For example, if I am developing an app where the end user will not receive any other confirmation of their interaction with the app? If so,Read More…

Tagged PowerApps Success Screen timer

Create Documents Instantly with Power Automate

February 7, 2020August 28, 2020 N. Milligan

A while ago, I was asked about the possibility to automate creating documents. Recently, a friend asked the same question. Her organization is hoping to develop a homegrown solution instead of purchasing a tool that fails to do everything they need it to do. I’d worked out a pretty quick solution aRead More…

Tagged Microsoft Word Power Automate SharePoint

Display an Image in a PowerApps Gallery, Conditionally

February 5, 2020August 28, 2020 N. Milligan

As I develop apps, I am constantly looking for ways to enhance the data that’s there. I enjoy using images as a way to draw attention to specific records and provide more detail, at-a-glance, In this sample app, I use a simple image (the red exclamation mark) to signify a high priority incidenRead More…

Tagged formula function gallery images PowerApps

Automatic Refresh in PowerApps

February 3, 2020November 25, 2020 N. Milligan

I prefer to remove the standard refresh buttons from my PowerApps screens. Instead, I build automatic refresh into action states like OnVisible for screens. When a screen becomes visible, data is refreshed and my app’s users see the latest data. Here are my two favorite methods for automaticallyRead More…

Tagged gallery PowerApps timer

Create a Customized Welcome Screen in PowerApps

February 1, 2020 N. Milligan1 Comment on Create a Customized Welcome Screen in PowerApps

Give your PowerApps app a bespoke feel with a customized Welcome Screen. Don’t let this concept fool you. The Welcome Screen can do a lot more than say “hello”! Consider adding in some information about the current user for more thoughtful functionality.
Add a New Screen On the Home tab, clRead More…

3 Steps to Filter a PowerApps Gallery for the Current User’s Records

January 10, 2020November 25, 2020 N. Milligan

If you have recently generated a PowerApps app from data, you probably ended up with a 3 screen app. The first page of that app probably has a gallery. Basic default gallery By default, anyone using the app sees all records. This gallery can be customized to only show the records of the user Read More…

Tagged Current Users gallery PowerApps

PowerApps Galleries Part 2

January 8, 2020August 28, 2020 N. Milligan

Use functions in a gallery In a previous post, a gallery was customized by adding a new label. The label displays the data from a field in the data source. Emphasis was added to the label by changing some of the label’s color properties. Unfortunately, there isn’t always data in the field forRead More…

Tagged function gallery PowerApps
Convert Time Zones

Convert Time Zones in Power BI Reports in 5 Steps or Less

January 7, 2020February 1, 2020 N. Milligan

Importing data into Power BI from a data source, like SharePoint, can result in some odd behavior. Date and time values often appear in UTC time instead of the local time zone. Easily convert the time zone with a custom column: Make sure Date/Time/Zone is the data type for your current colRead More…

Tagged business intelligence powerbi

When “Stuff” Doesn’t Open in OneNote Online

January 6, 2020March 27, 2020 N. Milligan

It isn’t made to. Microsoft Excel isn’t expected to open Microsoft Word files. Don’t expect OneNote to open anything but OneNote files. Although, OneNote Online is not designed to open other application files like Word, Excel, PowerPoint, audio and video files it is very common to see various fiRead More…

Go Dark with PowerApps

Go Dark with PowerApps

January 6, 2020February 1, 2020 N. Milligan

Give your PowerApps app a sleek and polished look by changing the background colors. Basic app with minimal customizations In the example below, the background colors have been changed to black giving the app a ‘dark mode’ feel. Basic app with black background The key to this look is thRead More…

Tagged background PowerApps
Get more bang for your PowerApps Gallery

PowerApps Galleries Part 1

January 3, 2020February 1, 2020 N. Milligan

Get More Bang for the Gallery PowerApps has the ability to place app development in the hands of workers that are closest to the problems at hand. This is an exciting opportunity for any organization. Unfortunately, this opportunity does have a few limitations. Citizen apps tend to lack functRead More…

Tagged gallery PowerApps
Copyright 2020 All rights reserved.
  • Home