Power Platform Community Forum Thread Details

Hi everyone,
I'm looking to create an expense tracker using Microsoft Lists, and I want to automate the conversion of local currencies to EUR. My expenses come in different currencies, and I would like the setup to work as follows:

Column A: Local Currency Amount
Column B: Local Currency (e.g., USD, AUD, GBP, etc.)
Column C: Euro Value (automatically calculated based on exchange rates from a separate list)

I have another list that contains currency exchange rates, structured like this:

Column A: Currency (e.g., AUD)
Column B: Euro Exchange Rate (e.g., 1.66)

Whenever I enter a new expense in my main expense tracker, it should automatically fetch the corresponding exchange rate from the Currency Rates list and calculate the Euro equivalent in Column C in my expense tracker.

Any suggestions or guidance on how to achieve this would be greatly appreciated!

Categories:

General topics