Automatic Currency Conversion / Inflation Calculator
@Darren Neese / @Kurt Larson : If you've already covered something like this in a previous tutorial, please can you direct me to the link? If not, then I have a 'Suggestion for New Content' request: ===== FIRST REQUEST ===== I'm building a contract management solution (in SharePoint) which will record contract values - as at the date the contract was awarded. Is it possible to connect to an online currency conversion tool, via a Power App that will automatically convert the contract values to any selected currency? An example use case would be when the contractor is submitting a proposal for work in a different country and needs to include examples of previous work completed, but is required to reflect contract values in the currency of that country. NB: The currency would need to be converted as at the date the contract was awarded, i.e. not today's date. I found this free embeddable widget tool, but not too sure how it could be applied within a Power App or how/if I can connect it to my table of contract values: https://www.oanda.com/foreign-exchange-data-services/embeddable-currency-converter-widget/ I also found a few tutorials for live currency converters set up via an Excel spreadsheet, so could possibly link to an Excel spreadsheet sitting in a shared location in the background? e.g. https://www.youtube.com/watch?v=onjlQNE-dFY - but hopefully there's a more efficient way (which is also free of premium licensing). ===== SECOND REQUEST ===== A further add-on to the above request is to be able to build some kind of "Inflation Calculator" into the system that would convert a historical contract value to a value relative to today's economy. e.g. If the contract value in 2005 was $10,000 then in 2024 that contract would be equivalent to about $16,000 now. (Ref: https://www.in2013dollars.com/us/inflation/2005?amount=10000)