Author Posts
As part of a project I needed to change the permission on an item just after it is created to only be visible to people based on column values in the item. The building the flow included lots of topics from using REST api, extracting information from a previous step ...
Plotting data onto a map is a regular request when a company has data that is location based. In this post, we will look at some simple tips to plot data onto a map. The final map will show a bubble for each location, the size will depend upon the ...
Maps are awesome and adding a map to an app (even a static one), adds that special touch. This post is an introduction to adding a Static Google map to a PowerApp. Create your Google API Key In order to connect to Google and request a static map image, you ...
For many companies, January is a month of reporting how well the previous year did or didn’t. In this post, I will walk you through a very simple method of adding conditional formatting to a column chart. Adding colours to indicate performance is a very quick method of giving a ...
Every year we all hope for or hate the idea of snow over Christmas I thought we would look at snowfall data for the UK, apologies to all my international readers. The data is on a web page in small tables that need appending together ready to be put into ...
In this tutorial, we will see how to use a timer control along with a touch of maths to scroll a text message across the screen. It’s a very simple example but illustrates some basic animation which can be used in many applications. First, add a simple message to a ...
It seems appropriate to build a Power BI calendar on New Year’s eve ready to plan 2019. So this post walks through the steps of building a calendar in Power BI desktop using DAX. The aim is to have a calendar that has columns for all the variations you quickly ...
This post is going to show an alternative for conditional formatting using lookup. If you want to see another approach please read ‘How to do conditional formatting in PowerApps’. I often get asked how to do conditional formatting or asked to help change existing conditional formatting that is not based ...
Following on from yesterday’s post about Power BI dynamic titles this next post is to navigate to the filtered page using bookmarks and buttons to show a page filtered differently. The report used in this example is based on ice cream sales of different flavours. We will create a bookmark ...
In this tutorial Power BI, I want to cover one of my favourite topics to teach dynamic titles. These titles are created using a measure that contains the values selected in a filter. Simple One Value Title This title will show which single value is selected in a filter. In ...
Tabbed forms are ideal when a form has more controls than screen space. It really helps to use a tabbed form to group items and keep the visible size of your forms manageable. Unfortunately, PowerApps doesn’t ship with a tabbed form so we need to create one using a gallery ...
For the second day of my Christmas series, we are going to build a simple dialog box. When designing an interface you occasionally want to explain the consequences of proceeding to the user and ask for confirmation using a dialog box. For example, this will delete all records relating to ...
We start my Christmas series with my favourite new thing I found in the past few weeks, Enhanced Groups. This post does a quick overview of a great new feature in PowerApps, Enhanced Groups. This feature is currently set to “Experimental”, so might well vanish at any moment. For now, ...
This tutorial will show you how to change the look of individual rows (in a PowerApps Gallery) based on logic you specify. The data is based on the theme of Queen Boadicea and managing her expenses within a SharePoint list. BTW, before we continue, you should also check out how ...
Getting Responses from called Flows In the previous parts of this series we have built 1 main flow and two called flows. If a flow calls another flow it shows a success unless the called flow includes a response, even if the called flow fails. In this last post of ...
In part 3 of this series we built a reusable flow to add contribute permission to one item for one person. Most examples found will give you the most common permission level ids. This post will walk through finding the roleDefId needed for any named permission level and will modify ...
In parts 1 and 2 we built a flow that broke inheritance on a list item and then gave a person contribute permission. Both of these functions are useful and we might want to use them again. Rather than rebuilding the REST api strings every time we need them, this post ...
Master Office 365, Power Platform & SharePoint & Teams With 200+ Hours Of Training Videos in the Collab365 Academy. This offer is insane and is only available for a limited period.
