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.

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.

Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using contact@veenstra.me.uk.

Recent Posts

8 top reasons to use Dataverse or SharePoint lists in the Power Platform

Why would you use Dataverse, if SharePoint lists gives you the option to avoid premium…

6 days ago

Filter by calculated fields in SharePoint using Power Automate

When you read items from a SharePoint list and you want to filter by calculated…

1 week ago

Expected String but got Null, when calling a flow from a Model Driven app

A few weeks ago I looked at calling flows from model driven apps. And for…

1 week ago

Get all your broken connections using Power Automate

To get all your broken connections in the Power Platform can be a challenge. In…

2 weeks ago

Customer Voice a.k.a. Forms Pro the database behind the magic

If you call Customer Voice still Forms Pro or not, have you ever looked into…

2 weeks ago

Many running flows in Power Automate

Recently I noticed that some of my flows end up with many running flows. Types…

3 weeks ago