Set Default standard column values with REST API

Question

Im using Shrepoint "Colun default value settings".

I like to use REST API (with Power Automate) to set the default value for each folder in a library. Like this:

Any idea how to use REST API to set these default values ?

michalkornet · Answer

Hi TrulsBj , I don't want to go into details, but you can use a request like this to set this setting. Please note that the request does not append the setting; it overrides the previous configuration.

I used SharePoint HTTP Request action->

URL ->

Body ->

<MetadataDefaults><a href="/sites/YOUR_SITE/Shared%20Documents"><DefaultValue FieldName="YourFieldName">VALUE1</DefaultValue></a><a href="/sites/YOUR_SITE/Shared%20Documents/folder"><DefaultValue FieldName="YourFieldName">VALUE2</DefaultValue></a></MetadataDefaults>

Forum Discussion

Set Default standard column values with REST API

1 Reply