I am setting a Flow that can get the value of lookup column for using in Calculated Column. My List below:
I want the Column ExchangeRate in List B to get data from Lookup Column "Currencies: exRate" and the "Price in VND" column calculate = OriPrice x ExchangeRate. And when the "ExRate" in List A change, then update "Exchange Rate" and "Price in VND" column in List B.
I want to use MS Flow and also Sharepoint Workflow 2013.
Please give me an advice.