Flow: Try, Catch on User List Till You Get A Match.

Hi everyone, so "Template Tuesday" has come and gone and what a lovely little offering the Flow Team have packaged up for you. The scope action is one I don't see in use too often, but when you consider it's power it really is one for the watching, and the using! The fundamentals behind Try, Catch, Finally is how it has been dressed up and it works a treat. Have a look at the tweet below and see more details of the template there too.

Read More

Flow: Testing Various Date Formats From Any Source

As a Flow community contributor, I regularly assist Flow users with the creation of their Flows. The great thing about a community like the one you can find at this link is that when I need assistance with an expression, an Odata filter or the use of a connector, help is never too far way. You just can't beat support like that when working with technology.

One of the common queries that comes up relates to the use of dates in a Flow. Dates and times are an essential part of application building, business processes and day to day life so we may have to say something like the following.

If due date is next 7 days do X, If not do Y.

If current date is 2 days before user 1's birthday (taken from a SharePoint List perhaps) send me a reminder so I can get them a present.

Get all tasks for the next 14 days from a SharePoint List and send a Monday email with these tasks.

The above examples, are merely just a snippet of some of what comes up relating to the format of the date or the expression required to match a date requirement.

But what methods are suitable to test these scenarios if it's just not working is not working for you?

Read More

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