Have you been using the REST API instead of the create item action in Power Automate. Create Item in the SharePoint connector is now just as good!
Using the REST API – Verbose
Table of Contents
In the past I’ve been a fan of the REST API action available in the SharePoint connector. This to the extend of that I’m almost defaulting to the Send an HTTP request to SharePoint action for all of my SharePoint actions.
I would even use the odata=verbose option most of the time. Even though the nometadata is easier to use. There are some things that require the verbose header and therefor I started to use it by default. That doesn’t make it right though 😉
But there is a better option available. This option has been hidden so well, that you might not even notice its existence. Yes there is a reason for this blog post!
Create item action
When you use the Create Item action and you dynamically fill the site address (i.e. Power automate cannot identify the fields on your list!), then there is a property Item that appears rather than a list of field.
If you prefer you could of course still select the site and the list and all the relevant properties will appear.
Hey Pieter, great article again!! I’ve been using SharePoint API in the past for creating items with a lot of success in speed. But now I tried to use the API to get items, but I can’t get past the 5000 items limitation.
Do you have any tips to get over 5000 by using it?
Hi Emanuel,
With multiple queries you could. So you could for example query ID lt 5000 and ID gt 5000 and get 10000 items like that.
The question to be asked of course is what are you going to do with 10000 items? Could you filter the items using fitler queries on the get items and just collect the items that you really need?
Hi, Thanks for this. How do you POST or BATCH POST to a sharepoint date field?
you would have to use the format: yyyy-MM-ddThh:mm:ss