Hello,
I have a two lookup columns i.e.
1. Business
2. Approver EID
3. Person or Group
Into Business I have 3 choice i.e. Elec, Aero and Hyd
Say for example : if a user selects Elec, then we see My EID i.e. E123456 in the Approver EID column
Similarly, if user selects Aero, then we see Rick as the name in the Approver EID column.
So what I'm trying to achieve is: in Person or Group column, Email address should automatically get populated against EID mentioned in Approver EID column.
For E.g.
| Business = Elec |
| Approver EID = E12345 |
| Person or Group = [email protected] |

Vaibhav ChauhanPosted Jun 16, 2021, 3:38 PM
Prem MPosted Jun 16, 2021, 3:15 PM
Vaibhav ChauhanPosted Jun 14, 2021, 7:34 AM
Prem MPosted Jun 14, 2021, 7:02 AM
Vaibhav ChauhanPosted Jun 11, 2021, 4:30 PM