Aug 23 2020 11:17 PM
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.
Oct 14 2020 12:21 AM - edited Oct 14 2020 12:22 AM
Oct 14 2020 12:21 AM - edited Oct 14 2020 12:22 AM
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
3. Update List item in A.
I hope its clear