Answered

Calculate total amount using exchange rate

(0) Share

Report

Posted on by MarwaAlhajri

Hi guys ,

I have a table with exchange rates based on each date"Used power automate to generate rates from free exchange rate API"

now I want to calculate the total amount based on the currency we select

like qucantity*unit price/exchange rate

I used the code

With(

{

wRate:

LookUp(

'Currency Rate to USD',

'Created Date' = DataCardValue3.SelectedDate

)

Value(TextInput3_2.Text) *

Switch(

Dropdown2_1.Selected.Value,

"USD",

wRate.'Created Date',

"AED",

wRate.'Created Date',

"OMR",

wRate.'Created Date'

)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Gerard Simpson 2,987 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi - The initial LookUp is just grabbing the first row of the data and then this is passed through to the switch logic.

Can you try this instead - this creates a filter table based on the date, which is then passed through and a lookup applied to grab the correct row of the filtered table...

With(

{

wRate:

Filter(

'Currency Rate to USD',

'Created Date' = DataCardValue3.SelectedDate

)

},

Value(TextInput3_2.Text) * LookUp(wRate, Title = Dropdown2_1.Selected.Value).'Currency Rate to USD'

)

Was this reply helpful? Yes No
MarwaAlhajri on at

Like (0)

Report
Copy link

Link copied!

Hi, thanks for your reply,
I did as you said, but still, the value didn't change
I changed the value of the dropdown box which contains currency USD, OMR AED ONChange value to
Reset(TextInput3_3)

Was this reply helpful? Yes No
timl 36,558 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi @MarwaAlhajri

In the OnChange property of Dropdown2_1, you would need to call Reset on your Total Price text input control (eg, Reset(txtTotalPrice) ) if you want the value to update after changing the exchange rate.

Was this reply helpful? Yes No
MarwaAlhajri on at

Like (0)

Report
Copy link

Link copied!

Hi Thanks for the reply,
I change it to the currency rate to USD but now I think the amount is showing wrong
it's correct for OMR but if I change it to USD it is the same is it only taking one value which is OMR

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi - in your switch, you are referencing the 'Created Date' field - this should be 'Currency Rate to USD'

Was this reply helpful? Yes No