Power Automate

Movie Directory Part 4: Import

This continues a short series about a movie directory personal project exploring Power Apps and Dataverse. In the first three posts, I’ve laid out the data structure in Dataverse and the app itself. This post will tackle how I was able to quickly fill in the 300+ movies in our collection converting from our previous system, files on a computer arranged for use on a Plex server. This will all be done in Power Automate.

Continue Reading Movie Directory Part 4: Import

SharePoint: Overriding a Site’s Home Page

This post continues a series on SharePoint site provisioning, unpacking some of the problems I’ve faced and overcome in building solutions.

At this point in the series, we’ve now created new SharePoint sites and applied temporary site scripts and site designs. There is one big feature missing from site scripts and site designs, though: templating the home page. You can’t simply say that a project site design should always contain a home page with these specific web parts. This may not be true forever – Microsoft is steadily improving site templating – but as of working on this project a few months ago, it required a bit of a workaround.

Continue Reading SharePoint: Overriding a Site’s Home Page

Power Automate: The First Function

A scenario I’ve encountered several times in Power Automate is needing to get just one item from a data source, such as a SharePoint list, based on a specific column such as Title matching what I am looking for. Power Automate only has a function to get all the SharePoint items that match the criteria, unless you already know the specific ID you are looking for. So you end up with an array returned, even if there’s only one item in it. That then creates a bit of nuisance when you want to access that one item, since Power Automate will go ahead and put that within a for each loop structure. Knowing there’s only one item, it is a negligible difference in Flow speed, but it is suboptimal code looking at a for each loop that isn’t really looping.

Continue Reading Power Automate: The First Function

Power Automate: Temporary Site Scripts and Designs

This post continues a series on SharePoint site provisioning, unpacking some of the problems I’ve faced and overcome in building solutions.

In the last post in this series, I created a SharePoint site programmatically. Suppose you want to update site scripts or site designs onto that new site. The advantage of doing this is that it can be fully automated based on another causal event setting it off, like filling out a Power App or creating an item in a SharePoint list, and incorporate variables. My simple example will use a variable of a link that will be added to the navigation of this new site.

Continue Reading Power Automate: Temporary Site Scripts and Designs

Power Automate: Create Site with SharePoint REST API

This post continues a series on SharePoint site provisioning, unpacking some of the problems I’ve faced and overcome in building solutions.

This post will look at dynamically creating SharePoint sites using Power Automate. An advantage of doing it this way is to automate different settings that can incorporate variables, as opposed to the standard interface tools for users to create new sites.

Continue Reading Power Automate: Create Site with SharePoint REST API

Microsoft Ignite News Day

Today was the first day of the spring edition of Microsoft Ignite, the primary conference for Microsoft IT professionals. The first day always includes a lot of news for upcoming features which tend to get dumped all at once the same time as the opening keynote. After reviewing several of these news blogs and watching video sessions most of the day, here are the features which stand out to me. I will not cover nearly everything, but provided some links for more details.

Continue Reading Microsoft Ignite News Day