Import Exchange Rates

17 Wednesday Apr 2019

Posted by Ludwig Reinhard in General Ledger

≈ 9 Comments

Tags

Exchange rate provider, Exchange Rates, HTTP, JSON, MS Flow

MS Flow Demo Files:

FX1_20190412134750

FX2_20190412134819

9 thoughts on “Import Exchange Rates”

Pingback: Import Exchange Rates - Finance and Operations Community
Ajay said:

2020-01-31 at 11:54

Great solution Ludwig, thanks for sharing this with all the details, it was good seeing you a year ago at the D365 Saturday event in Paddington

LikeLike
Randhir Taucoor said:

2020-02-11 at 08:04

Hi, I need to import rates from Bloomberg with over 14 cross currencies. We currently export data on excel, then type in one by one. Is there any possible solution to import rates via the flow or import file?

LikeLike
- Ludwig Reinhard said:
  
  2020-02-11 at 19:57
  
  Hi Randhir Taucoor, If you have the Bloomberg data in an Excel sheet that can be accessed via a cloud drive (one-drive, sharepoint, etc.) then you can use flow. Yet, rather than downloading it, can’t you access the data via an API and thereby ‘save’ the download step? Should be possible especially for a large provider such as Bloomberg. Best regards, Ludwig
  
  LikeLike
Patricia Cervello said:

2020-03-04 at 10:27

Hi Ludwig,
Thank you for explaining in such detail how the Flow works and how to configure it. After talking with a developer though, he thinks that the modification that has to be done in the system in order to create a new exchange rate provider is much easier than the configuration needed to make Flows work. Would you still recommend to use Flows instead of coding a change? Thank you!

LikeLike
- Ludwig Reinhard said:
  
  2020-03-04 at 12:10
  
  Hi Patricia, I certainly prefer the out of the box Flow/PowerAutomate solution over a system adjustment by code. Yet, if I would be a developer I would certainly argue differently 😉 Best regards, Ludwig
  
  LikeLike
Coste said:

2021-09-29 at 14:12

Hi Ludwig, I have applied your power automate flow, but I met a blocking point on the action : Compose (Split) : the error is : Unable to process template language expressions in action ‘Compose_(Split)’ inputs at line ‘1’ and column ‘12746’: ‘The template language function ‘split’ expects its first parameter to be of type string. The provided value is of type ‘Object’. Please see https://aka.ms/logicexpressions#split for usage details.’.I have checked the code, and for me it’s ok. do you have an idea about these error ? thank you

LikeLike
- Ludwig Reinhard said:
  
  2021-09-29 at 14:53
  
  Hi, MS made some changes to the ‘flow’ (PowerAutomate) language since this post was published. You might thus not be able to use this ‘old’ examples but might have to modify things a bit. Please check this and related sites: https://docs.microsoft.com/en-us/power-platform/power-fx/overview. Best regards, Ludwig
  
  LikeLike
  - Coste said:
    
    2021-09-29 at 17:44
    
    I found the correction in your flow, now It is functional, thank you for your job.
    
    LikeLiked by 1 person