Answered

Default Value parameter in List Column not being set during Power Automate Flow

(0) Share

Report

Posted on by Community Power Pla...

I have created flows that can create and delete multiple list columns based on two extremely useful posts:

The first uses variables and an array of column names and loops through the creation of the columns: https://www.alanps1.io/power-platform/flow/flow-create-sharepoint-list-text-fields-using-rest-api-wi...

The second provides option on how to do a myriad REST options which I used to tweet the Creation flow above to delete multiple columns:

http://www.ludovicperrichon.com/sharepoint-rest-api-call-with-powerautomate/#removelistfields

This page gives examples on many other useful REST API options too.

This being said, for some reason, neither with the create or update flows work in setting the Default Value on the Yes/No columns. in my array. Here is the information for both:

1. Create Flow:

Headers:

{
"Content-Type": "application/json;odata=verbose",
"Accept": "application/json;odata=verbose"
}

Body:

{
"__metadata": {
"type": "SP.FieldText"
},
"FieldTypeKind": 8,
"Title": "@{items('Apply_to_each_Create_Each_New_Column_String')}",
"Required": "false",
"EnforceUniqueValues": "false",
"DefaultValue": "No",
"StaticName": "@{items('Apply_to_each_Create_Each_New_Column_String')}"
}

2. Update Flow:

Header:

{
"accept": "application/json;odata=verbose",
"content-type": "application/json;odata=verbose",
"IF-MATCH": "*",
"X-HTTP-Method": "MERGE"
}

Body:

{
'__metadata': {
'type': 'SP.FieldMultiLineText'
},
'DefaultValue': 'No'
}

Any help would be appreciated.

All responses (4)

Answers (1)

Community Power Pla... on at

Like (1)

Report

Re: Default Value parameter in List Column not being set during Power Automate Flow

@abm

That worked! The simple and obvious solutions always allude me. 🙂 Thanks for the correction. I wish Microsoft's documentation as clear.
Community Power Pla... on at

Like (1)

Report

Re: Default Value parameter in List Column not being set during Power Automate Flow

@Expiscornovus,

I will have to look into the XML option later as it might come in handy for other things. Looks like simply using "0" instead of "No" was the answer.
Verified answer

abm abm 32,506 Most Valuable Professional on at

Like (2)

Report

Re: Default Value parameter in List Column not being set during Power Automate Flow

Hi @NotThe1stChoice

For Yes/No field you can set using DefaultValue to "0" (False), Set DefaultValue to "1" (True)

For Default No

{
"__metadata": {
"type": "SP.FieldText"
},
"FieldTypeKind": 8,
"Title": "@{items('Apply_to_each_Create_Each_New_Column_String')}",
"Required": "false",
"EnforceUniqueValues": "false",
"DefaultValue": "0",
"StaticName": "@{items('Apply_to_each_Create_Each_New_Column_String')}"
}

For Default Yes

{
"__metadata": {
"type": "SP.FieldText"
},
"FieldTypeKind": 8,
"Title": "@{items('Apply_to_each_Create_Each_New_Column_String')}",
"Required": "false",
"EnforceUniqueValues": "false",
"DefaultValue": "1",
"StaticName": "@{items('Apply_to_each_Create_Each_New_Column_String')}"
}
Expiscornovus 32,157 Most Valuable Professional on at

Like (1)

Report
Re: Default Value parameter in List Column not being set during Power Automate Flow

Hi @NotThe1stChoice,

Don't know if that DefaultValue is supported in the fields method. I always prefer the CreateFieldAsXml option because it seems to support more properties. In the body of that request you can set the Default value to 0 (aka No).

Try something like below

URI

_api/web/lists/getbytitle('@{variables('ListName')}')/fields/CreateFieldAsXml

Body

{ "parameters": {"__metadata": {"type":"SP.XmlSchemaFieldCreationInformation"}, "SchemaXml":"<Field DisplayName='YesField' Format='Dropdown' IsModern='TRUE' Name='YesField' Title='YesField' Type='Boolean'><Default>0</Default></Field>", "Options":12} }