Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Multiple currency exchange rate multiplication with user input value

I have multiple currency and its values in different list and Currency is lookup in the main list so user can select from dropdown and can enter its cost. 

Main List field:

Currency- Lookup in main list. Currency list has currency field and exchange rate field which is number type field: user needs to select currency from dropdown options in main list

Cost - Number type: user need to enter values here


Based on the above inputs from user. I want to calculate Expected Cost

Expected Cost: exchange rate*Cost. Expected cost change when user change currency or cost.


Thanks in advance

Super User
Super User

You have stayed the process. Can you restate what you need since you already have a way of calculating the cost?

May your request clearer


If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.



I'm new to the powerapps, I know how to calculate the expected cost but don't know where I need to make changes in powerapps form and also I don't know how to write formula for this in powerapps

Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,776)