I am setting a Flow that can get the value of lookup column for using in Calculated Column. My List below:

List A: Target List, contain Currencies and Exchange Rate to VND (Called exRate) of the Currencies enter image description here

List B: Source List, Product List, want to calculate price in VND enter image description here

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.



It seems currencies is a lookup column. It can be with a flow like below. Use the currency id to find the corresponding exRate in the currency list and set the exRate to the current item Exchange Rate column enter image description here

For updating exRate when changed in the target list, you can use another flow to do so. enter image description here

About how to filter look up column, please check this:https://powerusers.microsoft.com/t5/Flow-Ideas/SharePoint-ODATA-filtering-by-lookup-values/idi-p/152553

  • Hi @jerry_MSFT, I success with the First Workflow. But the 2nd WorkFlow, what is the Trigger of the Workflow? Sorry bro, I am a newbie. – TAN EZVISA Jul 2 '19 at 10:36
  • 1
    @TANEZVISA, The second flow is triggered by item is created/modified in the currencies list, which is your list a – Jerry_MSFT Jul 3 '19 at 1:21
  • Thanks, @jerry_MSFT. You are the one who saved me – TAN EZVISA Jul 3 '19 at 4:05
  • @TANEZVISA Glad to help. Please accept the reply as answer so other people could find it more easily – Jerry_MSFT Jul 3 '19 at 5:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.