Welcome to AlanPs1.io

This blog documents some of what I do every day. If you are a Sys Admin, an IT Pro or a DevOps Professional you might just find it useful. The content you will find should suit the beginner, intermediate users as well as advanced users. Each post has some nuggets of joy. I hope you find some content that is useful.

The content is mostly relating to Office 365, PowerShell and Power Platform such as Flow & PowerApps. I will be sharing tech tips and tutorials mostly linked to Office 365 administration and showing you ways to automate business processes using Flow, PowerApps and PowerShell. My focus lies mainly with Office 365 and I use the necessary tools to work with data from the various Office 365 APIs and Microsoft Graph etc. You will see me use PowerShell and the Power Platform to harness data and hopefully do something useful with it. Then, as time goes on I should be able to introduce more Azure related content as my discovery of all things Azure progresses.

Flow: So Where has “Edit in advanced mode” Gone on Condition Actions

Below is an image of the new format for conditions in Flow. Look at the no code control we have here with real conditional logic. What in improvement and one I am sure the community and users will embrace overall. Well done to the Flow Team, one of several great improvements I am seeing on my Twitter time line just now.

Full detail at this link: Build more powerful conditions in flows and more

Image credit: https://flow.microsoft.com/en-us/blog/build-more-powerful-conditions-in-flows-and-more/

Read More

PowerShell SharePoint PnP: Installing SharePoint PNP PowerShell

Open Windows Powershell as Administrator.

Run the following

Install-Module SharepointPNPPowershellOnline

Type A when prompted.

To verify the version installed type the following:

Get-Module SharePointPnPPowerShell* -ListAvailable | Select-Object Name,Version | Sort-Object Version -Descending

Type the following to connect to your SharePoint Online Environment replacing <YourTenant> with your Tenancy alias, e.g alanlearnsstuff12345

Read More

PowerShell SharePoint: Installing SharePoint Online Management Shell

Once upon a time there was a need to download an MSI and to install the SharePoint PowerShell Module that way, however, as all useful and trusted modules do one day it now can be found in the PowerShell Gallery at this linkMicrosoft.Online.SharePoint.PowerShell. If you were still to need it for some reason it can be located here. But don’t bother doing that, have a read below and get started using SharePoint Online Management Shell.

So, to install the module, run PowerShell as administrator and type …

Install-Module -Name Microsoft.Online.SharePoint.PowerShell

Then to bring it in to use by sending this command …

Import-Module -Name Microsoft.Online.SharePoint.PowerShell

Now we have the module, installed and imported to the session let’s connect …

Read More

Flow: WDL – Use Multiple Functions to Make Interesting Expressions

In this post, we will once again reference back to part 8 – Call O365 Roadmap Web Service Weekly Digest where we have sent Microsoft 365 Roadmap updates via email.

The email body contains some interesting expressions and use of several nested functions using WDL, Workflow Definition Language.

A full reference on WDL can be found at this link.

Here is the section of the Flow that I am referring to:

Firstly, let’s break down the expressions in the second row of the table, the one that looks like this:

And here is the code …

Read More

Flow: HTML Email Customisation with CSS

Back in part 8 – Call O365 Roadmap Web Service Weekly Digest you will see that we are generating the last 7 days worth of updates from the Microsoft 365 Roadmap and we are sending them as a weekly digest. The emails look like below:

I like them, they are well laid out and mostly readable but there are some values missing so once I got to adding them I realised the lay out and the styling required some thought. So now I am working with an output that looks like this:

Whether or not one is better than another is elementary in this post. I am going to show you the changes I had made in order to present the email in this way.

Here is a look at the relevant completed section now that the changes to the HTML & CSS have been made:

Read More