Showing posts from March, 2019

Microsoft Flow - Convert AND Format DateTime from SharePoint for Australia

Using DateTime fields from SharePoint can be a royal PITA.  Here's the simplest way I've found to do a quick conversion from UTC time to AUS time.

Using Flow, when you pull dates from a SharePoint list, even if they look right in SharePoint, they come out wrong in Flow.

SharePoint Lists store DateTime values in UTC format behind the scenes in the database.  This means even if you have Regional Settings set up in SharePoint to show the correct DateTime in the list, when you pull the data out using other applications, it spits out in UTC.

We want to fix that.

The expression I use to quickly convert the timezone AND format it to the correct dd/mm/yyyy format is ConvertTimeZone().

This function expects the following information:
ConvertTimeZone(DateTimeString, SourceTimeZone, DestinationTimeZone, Format)

Here's an example I've used in an Email Action in Flow:
convertTimeZone(triggerBody()?['DateTimeFromSharePoint'],'UTC','AUS Eastern Standard …

Office 365 Groups - Quickly find the GUID of a O365 Group

Looking for the GUID for a Office 365 Group and finding it slightly painful with PowerShell?

Here's my trick for quickly finding it.
I use Microsoft's Graph Explorer: Navigate to the Graph Explorer & click the Sign-In button in left-navigationClick the 'Show More Examples' link in the left-navigationSelect 'Groups' from the right-hand popoutNow you should be able to click 'All Groups in my organization' on the left hand nav.  (You may need to add the permission 'Directory.Read.All' to your account.Use Ctrl+F in the response pane to quickly find the group and grab it's ID

Microsoft Flow - Create a Teams Message from an RSS Feed

This is a nice simple Flow that I love!  If you work with a lot of different software and want to keep up to date on the latest changes without having to save all those pesky favourites to various RSS feeds/blogs, this is for you.

The great thing about this is, when you start posting it to Teams, now everyone can see when there is an update! 

It's only 3 steps, here's how:
Create a Blank FlowAdd the Trigger 'RSS - When a feed item is published'Add the 'Data Operations - Compose' action to create a nicely formatted message to send to teamsAdd the 'Teams - Post a Message' action, select your team & channel, and put the Compose Output into the Message box
I use this flow to keep up to date on all the latest Microsoft PowerApps news, see the screenshot below for my flow setup.