AnsweredAssumed Answered

Calculated Value fields and Workflows

Question asked by cbanquer on Oct 24, 2017
Latest reply on Oct 25, 2017 by cbanquer

I have a lookup list that I use to look up values that could change, i.e. when an approver leaves the company.

I have a 'Calculated Value' field that looks up an approver's email address from the look up list.

The calculated value field is connected to an 'ApproverEmail' column.

I, then, use this 'ApproverEmail' column value, which is passed on by the calculated field, when sending the email (I am not using quick approval because the approver needs to open the item and approve from there).


My question: What are the pros and cons of getting values from a lookup list using the above approach, as oppose to having a workflow doing the lookup?


Thank you for your input.