Update field value based on lookup field value selection in MS FLOW in SharePoint online

%3CLINGO-SUB%20id%3D%22lingo-sub-1607251%22%20slang%3D%22en-US%22%3EUpdate%20field%20value%20based%20on%20lookup%20field%20value%20selection%20in%20MS%20FLOW%20in%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1607251%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20please%20help%20me%20here%3F%20New%20to%20MS%20FLOW.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20list%20A%3A%20Having%20Empname%2C%20Plant%20Name(is%20lookup%20field)%2C%20and%20ZoneManager%20(is%20hidden%20in%20new%20form)fields.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EList%20B%3A%20Having%20Plant%2C%20ZoneManagers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20a%20user%20submits%20List%20A%20form%2C%20by%20filling%20the%20Empname%20and%20Plant%20name%20entry%20will%20be%20added%20to%20list%20A%20and%20workflow%20will%20be%20triggered%20and%20Zone%20Manger%20will%20be%20auto-updated%20by%20picking%20the%20respective%20field%20ZoneManger%20name%20from%20ListB%2C%20this%20is%20working%20fine%20in%20SharePoint%20workflow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EList%20B%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3EPlant%26nbsp%3B%20%26nbsp%3B%20ZoneManagers%3C%2FP%3E%3CP%3EINDIA%20--%20XXXName%3C%2FP%3E%3CP%3EUSA--%20YYYName%3C%2FP%3E%3CP%3ERUSSIA--ZZZName%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20the%20user%20enters%20in%20LIST%20A%3A%20Empname%20as%20CHRIS%20and%20Plant%20as%20the%20USA%20and%20saves%2C%20then%20ZoneManager%20field%20has%20to%20update%20as%20YYYName%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20achieve%20this%20in%20MS%20FLow%2C%20Any%20suggestions%2C%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20Advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1778365%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20field%20value%20based%20on%20lookup%20field%20value%20selection%20in%20MS%20FLOW%20in%20SharePoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1778365%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F134238%22%20target%3D%22_blank%22%3E%40Praveen%20Kumar%20Gogulakonda%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20you%20you%20can%20follow%20below%20steps%26nbsp%3B%3C%2FP%3E%3CP%3E1.%26nbsp%3B%20List%20item%20Created%20in%20List%20A%3C%2FP%3E%3CP%3E2.%20Use%20Get%20Item%20Action%20and%20get%20expected%20item%20from%20Lookup%20List%20B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ShivajiDhole_0-1602660048406.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226610iDA425D70C5EDEC5A%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22ShivajiDhole_0-1602660048406.png%22%20alt%3D%22ShivajiDhole_0-1602660048406.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E3.%20Update%20List%20item%26nbsp%3B%20in%20A.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20its%20clear%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi All.

 

Can anyone please help me here? New to MS FLOW.

 

I have list A: Having Empname, Plant Name(is lookup field), and ZoneManager (is hidden in new form)fields.

 

List B: Having Plant, ZoneManagers.

 

when a user submits List A form, by filling the Empname and Plant name entry will be added to list A and workflow will be triggered and Zone Manger will be auto-updated by picking the respective field ZoneManger name from ListB, this is working fine in SharePoint workflow.

 

Example: 

 

List B : 

Plant    ZoneManagers

INDIA -- XXXName

USA-- YYYName

RUSSIA--ZZZName

 

When the user enters in LIST A: Empname as CHRIS and Plant as the USA and saves, then ZoneManager field has to update as YYYName

 

How to achieve this in MS FLow, Any suggestions, please?

 

Thanks in Advance.

1 Reply

@Praveen Kumar Gogulakonda ,

 

I think  you can follow below steps :-

 

1.  List item Created in List A

2. Use Get Item Action and get expected item from Lookup List B

ShivajiDhole_0-1602660048406.png

3. Update List item  in A.

 

I hope its clear