Understanding the anatomy of a Power Automate Flow run Url allows you to be able to programmatically build the Url within your Flows. This is beneficial because it allows logic within your Flow to handle when the Flow fails to be able to send the…
It is pretty easy to modify an objects properties in Power Automate; you could simply use a Select action and configure the mapping manually by hand. This would be a good approach if you wanted to update a collection of SharePoint items properties…
Recently I was talking to a colleague, Devin Prevost, about a project where he is developing a solution for a client on the Power Platform. One of the challenges he was trying to solve was how he could ingest data from the client’s data warehouse…
Finding the differences between to arrays of objects is a common task that you may need to perform in your Power Automate workflows but you may be surprised that it isn’t as easy as you would expect, especially when you try to do it at scale on…
There are many reasons why you may want to chunk an array into smaller arrays and you may be surprised to find out there isn’t an out of the box action or expression to do this. I am going to walk you through how you can use a handful of variables, a…
Have you ever needed to implement functionality into a SPFx web part based off the current user’s permissions to a site, list or item. Luckily you aren’t the first and there are many examples out there to show you how to do this and even functions…
If you have been around SharePoint for some time you probably know that you can control whether your lists allow for attachments from the list settings page > Advanced Settings. This has been great when building solutions and preventing users from…
Would you like to replicate the news link feature in SharePoint online into your our custom solution? Well you can do it with ease by leveraging the _ api/SP.Publishing.EmbedService/EmbedData endpoint. The endpoint has 3 query parameters that can be…
This past week I was working on a project and wanted to provide a better user experience when adding a list item, dividing the form into multiple parts and custom header / footer. I have done JSON formatting in the past but never on the form so I was…
This past year has really shaken up the workplace and how people come together to collaborate and communicate in an all-digital remote way. Covid-19 accelerated companies roll-out plans for this new wave of digital workplace technology and has left…
The other day I got the request to see if we could modify the colors that appear under the standard colors within the Text web part so that they followed the client’s brand guidelines. After digging around in Dev Tools for a bit I was able to…
Back in October I wrote the first part of this 2 part series that talks about and outlines how you can create an OOTB Stock Information solution in SharePoint Online that focused on the overall solution design and the JSON needed to format the view…
Almost every intranet project I work on there is a request to display the company’s stock information on their new intranet. My typical approach would be to leverage a backend service in Azure to call the stock API, cache the data, and provide a web…
Today I am going to walk you through scaffolding up your first SPFx web part. If you are new to SPFx and still need to setup your development environment you can check out this post: Setting up your SPFx development environment . This post will be…
Today I am going to walk you through setting up your development environment for the SharePoint Framework (SPFx). At the time of writing this the latest version of SPFx is 1.8.2 and which means that we will be installing NodeJS LTS version 10.16. I…
There are many reason to setup and configure your own Office 365 developer subscription. You may want to test and see how previously built on-premise solutions would migrate / have to be built and deployed in the cloud. Maybe you are like me and you…