Create calculated field with http request

[marial16]

Hallo,

I have created a flow that creates Lists in SharePoint. One of the columns is calculated.

I know the type of the column, but is there a way i can automatically create the calculation itself?

Example

[Expiscornovus · Accepted solution]

Hi @marial16,

You can use the SP.FieldCalculated type in your metadata. 

Below is an example of that approach.

In this example I am also setting the output as a number. If you want to use text use the outputtype 1. 

https://docs.microsoft.com/en-us/dotnet/api/microsoft.sharepoint.spfieldtype?view=sharepoint-server

{ 
"__metadata": { "type": "SP.FieldCalculated" }, 
"FieldTypeKind": 17, 
"Title":"TotalCost",
"Formula": "=Quantity*Cost", 
"OutputType": 9 
}

[marial16]

Yes this works,

i figured it out eventually although i did not know about output type. 

I will add it also to the workflow.

Thank you!