S. J. Lewis 365 Solutions: A passion for building robust Microsoft 365 solutions

Create a button to launch a Flow

You can use column formatting to create buttons that, when selected, run Flows on the corresponding list item.

November 19, 2024

Exploring Model Driven Apps with an Asset Management Solution

This project is based upon Lisa Crosbie’s fantastic tutorial, Power Apps Model Driven Apps FULL COURSE for Beginners. I’ve recreated this asset management solution to demonstrate how processes can be streamlined and productivity enhanced within the Model Driven Apps framework.

December 14, 2023

How to sort an array using Power Automate

Learn how to sort an array using Power Automate. In this post I share a Power Platform solution containing two example Cloud Flows demonstrating how an array can be sorted. I also briefly explore performance results of running actions in parallel verses serial with some surprising results.

June 5, 2023

How to Add and Remove Accounts from Multi-Select SharePoint Person and Group Fields

Learn how to use the SharePoint API and Power Automate to add and remove accounts from multi-select Person and Group fields in SharePoint. Our step-by-step guide includes detailed illustrations and examples, as well as an optional Power Platform solution to help you deploy the solution to your tenant. Improve your SharePoint workflow management today!

May 17, 2023

SharePoint REST API: How to find the List or Library “__metadata” “type”

SharePoint REST API is a powerful tool for updating lists and items in SharePoint, but determining the correct “__metadata” “type” for API calls can be confusing…

April 15, 2023

Using SharePoint REST API to GET List properties: ListItemEntityTypeFullName

To find the ListItemEntityTypeFullName property for a SharePoint List, use REST API calls with either the List ID or ListName in the URL. Append “?$select=ListItemEntityTypeFullName” to get the property specifically. For detailed information, consult Microsoft’s guide on working with lists via REST.

February 9, 2022

A Guide to Error Handling in Power Automate Flow

In this article, I share a strategy for proactively informing administrators and support staff when something has gone wrong within their mission-critical Cloud Flows.

January 29, 2022

Hide or show fields in New or Edit forms

Microsoft has made it easier to customise “modern” SharePoint Online Lists and Libraries Forms natively. But what do you do if you need to managing a “classic” Form or the edit for option is just not available?

May 21, 2021

SharePoint/SPFx: Returning to Webpart Development Part #4 (with React Hooks)

This article is different to its predecessors in the series, because I have published the SPFx-People-Search webpart solution to my GuiHub repository, I will be focusing on what I have found challenging about writing this webpart with React Hooks, SPFx and Microsoft Graph.

December 2, 2020

SPFx Debugging: Cannot GET /temp/workbench.html

While debugging SPFx, I kept seeing the following error: “Cannot GET /temp/workbench.html”

November 28, 2020

Category: Development