1 Better way to use Create Item in SharePoint with Power Automate
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.
