I have a question about Flow for Sharepoint List. I have 2 Lists, and one of them has a lookup column to another.
List 1: Currency List (Target List) enter image description here

List 2: Price Table (Source List). I want to get a Value of Ask Rate (Lookup Column) to ExRate Column (Number Column) to use in Price (Caculated Column). enter image description here

My Flow: enter image description here

Anyone know what happens, please help me!

And another question: If I don't have ExRate, I want to use an expression to calculate in the Price Column, please give me the expression?

  • 1
    Do you have added lookup column in Currency List and you are referencing this lookup from Price Table? correct me if I am wrong. can you add screenshot of your lookup column's configuration settings as well? – Ganesh Sanap Jul 10 '19 at 5:06
  • Can you explain the question? You are saying the ID is missing but they are not the same ID it has to be like that. Technically you need to use "get Items" not "Get Item" then filter the values based on column name and value. – Ehsan Aliverdi Jul 10 '19 at 5:59

Tan, It seems you have some trouble with the flow i set. I recreated a new set of lists and the flow shows look up column ID properly. Please double check the lookup column setting. And you can add a get item action to get more properties of the newly created item. enter image description here

  • Thanks, @jerry_MSFT. You are the real friend saved me. – TAN EZVISA Jul 10 '19 at 9:14

Thanks, everyone, especially @jerry_MSFT, you always help me in difficult times. Based on your suggestions, I check my Lookup Column Setting and realize something new:
When I choose: The Lookup Column Title (linked to the item). The Flow can't get the ID of the Lookup item.
enter image description here

But when I choose: The Lookup Column Title, It works fine.

  • Glad to see you figure it out. That's the common mistake everyone will have :-) Hope you go smoothly with your future tasks. BTW, please mark the reply as answer so other community members can avoid this small trap. – Jerry_MSFT Jul 10 '19 at 9:17
  • I want to ask you a general question, can we use Flow instead of Additional Lookup column? I see this way will help us have the right to affect the columns more easily such as using calculate or lookup from another table, how do you feel, give me your suggestion. – TAN EZVISA Jul 10 '19 at 9:21
  • It is possible to do so. You will need to do a bit more work with flow/workflow to find the right item in the target list. For you situation, you will need to write some code with the filter or query. As I assume you will need to handle a bunch of similar currency rate data with like USD to Euro and USD to JPY. – Jerry_MSFT Jul 10 '19 at 9:32
  • And for I am not an expert on Flow, usually i change the plan case by case. You can open a thread on the flow forum powerusers.microsoft.com/t5/Microsoft-Flow-Community/ct-p/…. There are many veterans who can give you more help. – Jerry_MSFT Jul 10 '19 at 9:35
  • @jerry. In this example, my final purpose is to calculate the Price Field. If we don't have ExRate Field to get value from Lookup Field. Can we use Formula or Expression to Calculated directly? – TAN EZVISA Jul 10 '19 at 9:36

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.