Hi all,
i would like to ask what is the best way to do this for both sharepoint list and in powerapp for Expense Application.
Our default currency is Singapore Dollars.
I have 1 Currency exchange rate List that have few different currency.
In the list there are column such as the table.
| Date of exchange rate (Single line Text) | USD Rate (Number) | Yen Rate (Number) | MYR Rate (number |
| 18/10/2022 | 0.02413 | 0.00957 | 0.30185 |
| 19/10/2022 | 0.02411 | 0.00953 | 0.30133 |
i am trying to add exchange rate into the expense app.
When an employee select the Currency option and enter the cost of the receipt, i would like to have the powerapp to calculate exchange rate amount base on the currency option selected, the receipt date, and the Currency exchange rate list.
