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
Solved! Go to 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
}
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
}
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!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
72 | |
23 | |
17 | |
17 | |
13 |
User | Count |
---|---|
125 | |
34 | |
31 | |
28 | |
26 |