web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Create calculated fiel...

Power Automate

Answered

Create calculated field with http request

(0) Share

Report

Report

Posted on by marial16

443

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

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
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 }

Was this reply helpful? Yes No
marial16 443 on at

Like (1)

Report

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!

Was this reply helpful? Yes No

Join the conversation