Forum Discussion
Using Flow to get Lookup Column Value and use these Value to calculate
Hi ca_rem,
If the update occurs at the time of List B row creation then consider the following Flow steps:
- Trigger - SharePoint new item
- Action - SharePoint get items from List A
- 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
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.
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
Norman Young . I'm setting up follow you instruction.
List A:
List B:
My Flow:
I realize that I must keep these Lookup Column. So when you say it is not required, It surprised me. Am I missing something?
Hi ca_rem,
List B ExchangeRate is not required. The value is coming from List A ExRate.
Make sense?
Norm
Norman Young . Sorry for my slow understanding, can we use a formula with the value of List A ExRate directly?