Using a flow to Calculate a contribution of the product based on the percentage.

(0) Share

Report

Posted on by Akil_kamal

Hi,

I have 3 columns on SharePoint list.

Product column is a Choice.

Event Name

Products

Event Estimated value.

Contribution of each product

International meeting

Product A

Product B

Product C

90,000

50%

20%

30%

I have created a flow that was able to add this event to each of the product sperate list after receiving approval from the budget owner however I need to calculate each product individual contribution value and add it to its relevant list for example:

List of activists of product A should have the below row after its approved:

Event Name	Products	Contribution
International meeting	Product A	45,000

is there a flow that I can use to do such calculation?

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Akil_kamal ,

Could you please tell me what 'Contribution of each product' 's data type is? Is it a choice column two?

I've made a test for your reference:

I assume 'Contribution of each product' is a multiple lines of text column

2\My flow

1)

range(0,length(outputs('Get_item')?['body/Products']))

2)

{ "Title": @{outputs('Get_item')?['body/Title']}, "Products" : @{outputs('Get_item')?['body/Products'][item()]['Value']}, "Contribution":@{div(mul(outputs('Get_item')?['body/EventEstimatedvalue'],int(replace(split(outputs('Get_item')?['body/Contributionofeachproduct'],decodeUriComponent('%0A'))[item()],'%',''))),100)} }

Result

Best Regards,

Bof

Best Regards,
Bof

Was this reply helpful? Yes No
Akil_kamal 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft ,

Thank you so much. this is extremely helpful.
i have tried t replicate the flow with the current lists I have. however, I keep getting the below error

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Akil_kamal ,

Don't input any value here.

Best Regards,

Bof

Was this reply helpful? Yes No