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.
List B :
INDIA -- XXXName
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?