cancel
Showing results for
Did you mean:
New Member

## Microsoft flow getting price from column and adding 10% to create a new value

Hi,

I'm trying to create a Microsoft workflow to take a price £ from a column in a list and add 10% to the price to give me a new price.

10/100*Price

i got this formula online but it doesn't work and everything else is calculating how much percentage was added to the original cost.

mul(variables(Percentage)/100)*(variables(Previous Cost))
1 ACCEPTED SOLUTION

Accepted Solutions
New Member

Solved it,

I didn't need a variable for percentage, i used this formula

so basically it first divides the Previous Cost variable by 10 (the percentage i want to add to the total cost), then it add the result of the division back to the value in Previous Cost to give me the Previous cost + 10%

Previous Cost £1263.10
Percent increase 10%
New Price £1389.41
so mathematically its 1263.1 / 10 = 126.31 + 1263.1 = 1389.41
2 REPLIES 2
New Member

I thought i would add more information as I'm not getting any replies, I have a list of software licenses we have basically, name of license / description / renewal date / Previous Cost / estimated new cost.

Now originally i created estimated new cost as a calculated column and added 10% to the cost of the Previous Cost to get the result, the only issue is that you cannot display the SUM total at the bottom of the column.

the way around this is to set the column as currency and then use flow to update the Estimated New Cost column.

I researched online but the closest i could find to this was to create a variable to capture the Previous cost and a Variable to add the percentage is wish to add, so far i can only get the calculation to add 10 to the Previous Cost or multiply the Previous cost by 10.

my understanding is that mathematically its 10 /  100 * Previous cost but i cannot find this formula as an expression i can use in Microsoft Flow.

New Member

Solved it,

I didn't need a variable for percentage, i used this formula

so basically it first divides the Previous Cost variable by 10 (the percentage i want to add to the total cost), then it add the result of the division back to the value in Previous Cost to give me the Previous cost + 10%

Previous Cost £1263.10
Percent increase 10%
New Price £1389.41
so mathematically its 1263.1 / 10 = 126.31 + 1263.1 = 1389.41

Announcements

#### December 2023 User Group Update: Welcoming New Groups and Upcoming Events

A new month means it's time to celebrate and welcome the new user groups that have joined our community. We are excited to announce that we have more than 8 New Groups, which is no surprise after the amazing Microsoft Power Platform Conference. This month, we are breaking them out by the different community categories. If your group is listed here, give this post a kudo so we can celebrate with you! Don't forget to take a look at the many events happening near you or virtually! It's a great time of year to connect and engage with User Groups both locally and online.   Please Welcome Our NEW User Groups   Power Platform: PowerIT User Group: Nottingham Power Platform User Group: Bergen Power Platform User Group: Danmark Nashville Power Platform User Group Microsoft Ambassador Program y Mujer Latina Technolochicas NCWIT Community Copilot Studio:  Copilot User Group Italia Dynamics365: Dynamics User Group AdriaticDynamic 365 Azerbaijan   December User Group Events   01 Dec 2023 Aprendiendo Desarrollo web, creando mi primer power app y power page. 01 Dec 2023 Q4 Hybrid Philadelphia Dynamics 365 & Power Platform User Group Meeting05 Dec 2023APAC Dynamics 365 FastTrack Bootcamp - BI and Analytics07 Dec 2023Bay Area Power Platform Meetup: Learn, Share, and Connect07 Dec 2023Indiana D365/AX December User Group Meeting07 Dec 2023Dynamics User Group Meeting: Houston09 Dec 2023 December '23 - NEW Power Apps User Group Meeting - Online 12 Dec 2023December Cleveland Power Platform User Group Meeting12 Dec 2023 RW2 Data Stewardship Open Forum Discussion 13 Dec 2023  Black Country Power Platform User Group - December 2023 - West Midlands