0


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?

Improve this question
2
  • 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 - MVP
    Commented Jul 10, 2019 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
    Commented Jul 10, 2019 at 5:59

2 Answers 2

Reset to default
1

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

Improve this answer
1
  • Thanks, @jerry_MSFT. You are the real friend saved me.
    – TAN EZVISA
    Commented Jul 10, 2019 at 9:14
0

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.

Improve this answer
6
  • 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
    Commented Jul 10, 2019 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
    Commented Jul 10, 2019 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
    Commented Jul 10, 2019 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
    Commented Jul 10, 2019 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
    Commented Jul 10, 2019 at 9:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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