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. Categories Flow/Power Query
6th September 2019 Power Query in Microsoft Flow – Joining Tables In this post I will introduce one of the most powerful parts of Power Query, joining tables. Its the vlookup part of Power Query. Categories Flow/Power Query
26th August 2019 Power Query in Microsoft Flow – An Introduction This is the first post in a new series regarding Power Query in Flow. In this post I will cover the basics of connecting to SQL Server, filtering and sorting the data and finally adding calculated columns. Categories Flow/Power Query
8th July 2019 PowerApps – Using JSON Function to save Pictures In this post I will be explaining how to use the JSON Function to simplify the saving of multiple pictures from a PowerApp to a SharePoint library using Flow. There have been many wonderful workarounds to do this, finally we now have a slightly less Heath-Robinson method. Categories Flow/How to/PowerApps