Skip to the content

My Blog

Welcome to my Blog. The main objective of this blog is for me to have place where I can store some notes, articles and tips so I can easily find them when I need them. Even better if sharing these notes can help you or point you in the right direction to solve a technical issue.
If you have any questions or suggestions please add a comment to the blog or contact me.

SharePoint column starting with capital F converted to _x0046_

Recently in a document library in SharePoint Online I have created a Choice column called FYQ1.I have noticed that the internal field name for the column FYQ01 is Field=_x0046_YQ01In Power Automate I have a "Get Items" action with the Filter Query _x0046_YQ01 eq 'Completed'When I run the flow I get the following error" Column '_x0046_YQ01' does not exist. It may have been delet ...

Patch person/group field with multiple selection - Part 1

I have recently worked on a PowerApps customized form where I had to build a relationship between different fields and patch lookup and person/group filed with multiple selection. As a data source I used four SharePoint lists. Docs Approval – List that contains the data entered by the user of the App Docs – List of all available documents Initiators – List of initiators a ...

How to get distinct records using the Union function in Power Automate

The Union function in Power Automate is used to return a collection that contains all the items from the specified collections.

SharePoint organisation news site

As a SharePoint administrator you can specify any number of organisation news sites.
An organisation news site is a site where the news/posts get a visual enhancement and appear on the SharePoint start page.

SPO - Restoring over 100k items from Recycle bin

Recently I was presented with the challenge of restoring over 100.000 items from SharePoint Online Recycle Bin.

How to update PnP-PowerShell

To upgrade to the latest version of PnP-PowerShell please follow these steps:

Launch a Canvas PowerApps from SharePoint List "New" Button

You can launch a Canvas Power App by clicking the new button in a SharePoint list, by setting the Customised SharePoint List form to open your Power App.