Cart

Synchronize a file with a SharePoint list

Here you get a pattern for comparing the content of a file with the content of a SharePoint list. For each item in the file, you create an item in SharePoint.
Published on
January 26, 2021

Here you get a pattern for comparing the content of a file with the content of a SharePoint list.

For each item in the file, you create an item in SharePoint.

Transcript

You might have worked with Power Automate or Azure Logic Apps and discovered that it can take a lot of steps to do simple operations.

And even very costly if you implement a flow which run over and over again .

and also be costly if you have to repeat them over and over again. You might also have to pay extra for Premium Features.

The HEXATOWN framework has been designed to challenge that. By making process logic in code using PowerShell. PowerShell which can be hosted – unchanged – on your machine, on a local server or in the cloud as Azure Functions.

Let me show you how you can import items into a SharePoint list in 20 lines of code using the Hexatown.com framework.

You have a SharePoint list and a file with data you like to store in that list.

I will

1. remove 3 items from the list –

2. Swap to PowerShell on my machine and run the script

Flow

File

Simple JSON file containing an array of strings

PowerShell

Niels Gregers Johansen
Niels is a self-taught IT engineer who was introduced to Microsoft tools when DOS 1.1 was born in the 1980s. His focus is bridging the technical gap between as-is and to-be platforms, with as much time spent on coding as possible. Niels is the brains behind the web version of the Periodic Table of Office 365.

Recent blog posts

View all posts

Obviously you have an opinion, so share it!

This is some text inside of a div block.