How to use Flow to Calculate and Populate a SharePoint Field / Column

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Power Users,

Hope you can help. I am working on using Power Automate to Update a SharePoint Item with the calculation below

CASH FLOW RELEASE = (Approximate Spend x ((Proposed Number of Days Credit-Current Number of Days Credit) / 365))

Cash Flow Release is the Column in SharePoint which needs populating and all the fields will be dynamic content from the SharePoint List.

Does anyone know how to use Flow Expressions to do this calculation? The syntax is confusing. I would use SharePoint Calculated Columns but they are not visible in New/Edit Modes. I essentially need Flow to do the calculation.

Much appreciated,

Arnold

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

Pstork1 69,543 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
You would build a formula like the one below using the Expressions tab. Substitute the appropriate dynamic content fields for the things in single quotes. Insert the resulting formula into a compose, a variable or directly into the update sharepoint field.

mul('Approximate Spend' ,(div(sub('Current Number of Days Credit','Proposed Number of Days Credit'),365))

Sub() subtracts the first field from the second

Div() divides the result by 365

Mul() multiplies that result times Approximate spend.

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please make sure all the column are Number type and you could refer to screenshot below to create the flow:

Expression in the Compose as below:

mul(outputs('Compose'),div(sub(outputs('Compose_2'),outputs('Compose_3')),365))

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No