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

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