Hi,
I am fairly new to Flow. I have been trying to develop a flow that looks up values for a column from another list- very similar to vlookup in excel. But I am stuck, not knowing how to proceed.
Premise
I have two lists - Leave Request and Staff Reporting.
Leave Request has 5 columns - Leave Type, Date From, Date To, Employee Name and Line Manager. Line Manager is a lookup column which is referencing "LM" column in Staff Reporting
Staff Reporting has 3 columns - Employee Name, LM, LM Email
Problem
When a new item is created on the list - Leave Request, i want to create a flow where the Employee Name is looked up in the list "Staff Reporting" and the corresponding value for LM is returned and stored in the column Line Manager.
Can someone please help with the above scenario?
Thanks,
MT
Solved! Go to Solution.
Hi @MT2,
I have made a test on my side, if the "Line Manager" column is of type "lookup", it is not possible to update the "Line Manager" column for your scenes.
Please modify the "Line Manager" column to Single of text column, and then you could refer to screenshot below to create the flow:
When an item is created in the Leave Request list as below:
The flow would run successfully as below:
Best regards,
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @MT2
Can you please post the column type for each of the columns in both list? I will assume that DateFrom and DateTo are Date columns and Leave Type is a Choice column, but what about the rest?
Regards,
Fausto Capellan, Jr
Hi @faustocapellanj,
Please see column details below:
Leave Register : Columns
Leave Type: Single Line of Text
Date From: Date and Time
Date To:Date and Time
Employee Name: Single Line of text
Line Manager: Single Line of text (Lookup column)
Staff Reporting: Columns
Employee Name: Single Line of text
LM: Single Line of text
LM Email: Single Line of text
Thanks,
MT
Hi @MT2
This should be a quick one with the approach I'm taking. Please follow the steps below:
first(body('Get_items')?['value'])['LM']
Please, do not hesitate to reach out if you have any questions.
Regards,
Fausto Capellan, Jr
Hi @MT2,
I have made a test on my side, if the "Line Manager" column is of type "lookup", it is not possible to update the "Line Manager" column for your scenes.
Please modify the "Line Manager" column to Single of text column, and then you could refer to screenshot below to create the flow:
When an item is created in the Leave Request list as below:
The flow would run successfully as below:
Best regards,
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried the flow that you suggested but it fails at the "Get Items" step.
And throws the below error :
Hi @MT2,
If your problem has been solved according to my solution, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!
Best regards,
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
45 | |
43 | |
38 | |
36 | |
23 |
User | Count |
---|---|
47 | |
31 | |
29 | |
29 | |
28 |