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

#### Back to Basics Tuesday Tip #9: All About the Galleries

This is the ninth post in our series dedicated to helping the amazing members of our community--both new members and seasoned veterans--learn and grow in how to best engage in the community! Each Tuesday, we feature new content that will help you best understand the community--from ranking and badges to profile avatars, from Super Users to blogging in the community. Our hope is that this information will help each of our community members grow in their experience with Power Platform, with the community, and with each other!     Today's Tip: All About the Galleries Have you checked out the library of content in our galleries? Whether you're looking for the latest info on an upcoming event, a helpful webinar, or tips and tricks from some of our most experienced community members, our galleries are full of the latest and greatest video content for the Power Platform communities.   There are several different galleries in each community, but we recommend checking these out first:   Community Connections & How-To Videos Hosted by members of the Power Platform Community Engagement  Team and featuring community members from around the world, these helpful videos are a great way to "kick the tires" of Power Platform and find out more about your fellow community members! Check them out in Power Apps, Power Automate, Power Pages, and Copilot Studio!         Webinars & Video Gallery Each community has its own unique webinars and videos highlighting some of the great work being done across the Power Platform. Watch tutorials and demos by Microsoft staff, partners, and community gurus! Check them out: Power Apps Webinars & Video Gallery Power Automate Webinars & Video Gallery Power Pages Webinars & Video Gallery Copilot Studio Webinars & Video Gallery   Events Whether it's the excitement of the Microsoft Power Platform Conference, a local event near you, or one of the many other in-person and virtual connection opportunities around the world, this is the place to find out more about all the Power Platform-centered events. Power Apps Events Power Automate Events Power Pages Events Copilot Studio Events   Unique Galleries to Each Community Because each area of Power Platform has its own unique features and benefits, there are areas of the galleries dedicated specifically to videos about that product. Whether it's Power Apps samples from the community or the Power Automate Cookbook highlighting unique flows, the Bot Sharing Gallery in Copilot Studio or Front-End Code Samples in Power Pages, there's a gallery for you!   Check out each community's gallery today! Power Apps Gallery Power Automate Gallery Power Pages Gallery Copilot Studio Gallery