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.
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.
1. remove 3 items from the list –
2. Swap to PowerShell on my machine and run the script
Simple JSON file containing an array of strings