Forum Discussion

ca_rem's avatar
ca_rem
Brass Contributor
Jul 01, 2019
Solved

Using Flow to get Lookup Column Value and use these Value to calculate

Hi there;

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

List B: Source List, Product List, want to calculate price in VND

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.

 

Thanks

Microsoft Flow
sharepoint
  • Norman Young's avatar
    Norman Young
    Jul 02, 2019

    Hi ca_rem,

     

    If the update occurs at the time of List B row creation then consider the following Flow steps:

    1. Trigger - SharePoint new item
    2. Action - SharePoint get items from List A
    3. Action - SharePoint update item in List B with lookup values in List A

    If the updates need to occur on an ongoing basis then replace Trigger - SharePoint new item with Trigger - Schedule.

     

    I hope this helps.

     

    Norm

8 Replies

  • Norman Young's avatar
    Norman Young
    MVP
    Jul 02, 2019

    Hi ca_rem,

     

    If the update occurs at the time of List B row creation then consider the following Flow steps:

    1. Trigger - SharePoint new item
    2. Action - SharePoint get items from List A
    3. Action - SharePoint update item in List B with lookup values in List A

    If the updates need to occur on an ongoing basis then replace Trigger - SharePoint new item with Trigger - Schedule.

     

    I hope this helps.

     

    Norm

    • ca_rem's avatar
      ca_rem
      Brass Contributor
      Jul 02, 2019

      Thanks, Norman Young 

      Your instruction work completely. But I have a question. If use flow, in this case, do I have to keep the lookup column?

      And Can you give more detailed instructions about the Trigger - Schedule if I want the updates need to occur on an ongoing basis?

      Hope your reply.

      • Norman Young's avatar
        Norman Young
        MVP
        Jul 02, 2019

        Hi ca_rem,

         

         do I have to keep the lookup column?

        If I understand correctly, no the lookup column in List B is not required.

         

        Can you give more detailed instructions about the Trigger - Schedule if I want the updates need to occur on an ongoing basis?

        Sure. Use the Recurrence trigger and select a frequency that make sense for you and set the time zone appropriately. Example image below. 

         

        I hope this helps.

         

        Norm

Resources