Hat Full of Data - Page 10 of 12 - Laura GB's notes on how she made data behave

23rd November 2019

Power Apps – Animating SVG Fill Colour and Size

In this post I will introduce animating SVG by altering the colour and size of the SVG graphic using variables and a timer control.

PowerApps/SVG

26th October 2019

PowerApps – Function Component

In this post I write a simple function component that takes one value and returns a calculated value. This creates a resusable function like feature.

PowerApps/Components/How to/SVG

25th October 2019

PowerApps – SVG Introduction

In this SVG Introduction post we will cover adding a simple SVG drawing to a PowerApp screen. Future posts will show how to manipulate that image.

PowerApps/SVG

6th October 2019

Power Query Functions – SQL Procedures

This is the fourth post in my series regarding writing custom functions in Power Query. This post describes how to create a function that will execute an SQL procedure, passing in a parameter. Stored Procedure My database contains a very simple procedure that given a cost center returns all the expense records. It can be run with the following SQL...

Power BI/M/Power Query

5th October 2019

Power Query Functions – Fetch web data

Often web based data is split across multiple pages. This post describes how to use a function to fetch web data from multiple pages by using parameters.

Power BI/M/Power Query

29th September 2019

Power Query – Multi-step Function

This post describes how to build a multiple step function in M using a parameter and using create function to build the function code.

Power BI/M/Power Query

27th September 2019

Power Query – Custom Handwritten Function

In this post I will write a simple custom handwritten function to perform a calculation, which can then be used in your queries.

Power BI/Intermediate/M/Power Query

23rd September 2019

Power Query in Flow – Summarising the Data

In this post I will look at the different options we have for summarising the data using grouping and pivoting with Power Query.

Flow/Power Query

9th September 2019

AI Builder Object Detect Model with Power Automate and Power Apps

In this post I will document how to build an AI Builder object detect model. We will create the list of items to detect, upload images, identify each image and then train the model.

AI Builder/Flow/How to/PowerApps

6th September 2019

Joining Tables of Data in Flow’s Power Query

In this post I will introduce one of the most powerful parts of Power Query, joining tables. Its the vlookup part of Power Query.

Flow/Power Query