1 Better way to use Create Item in SharePoint with Power Automate Microsoft Power Automate image 5

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

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.

1 Better way to use Create Item in SharePoint with Power Automate Microsoft Power Automate image 4

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 😉

1 Better way to use Create Item in SharePoint with Power Automate Microsoft Power Automate image 5

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.

Create Item with REST API Body

If you prefer you could of course still select the site and the list and all the relevant properties will appear.

1 Better way to use Create Item in SharePoint with Power Automate Microsoft Power Automate image 7

4 thoughts on “1 Better way to use Create Item in SharePoint with Power Automate

  1. 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?

    1. 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?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: