Choosing Approvers from Related Table

Question

Hi all -- two part question here.I am trying to create a change approval flow for a complicated approval matrix.&nbsp; I have designed a table to pull user names for each approval "role" from a related table based on a field (region) in the record.&nbsp; Where I am getting hung up is that depending on the content of another field (change type) some "roles" don't need to approve.&nbsp;I thought I could create a dynamic form rule to delete the content in the unrequired "role" fields, but realize that I cannot change that data since it is pulling from the related table.&nbsp; Is there a better way to manage this matrix with multiple dependencies?&nbsp;&nbsp;Example below:The linked Table contains Multiple Regions&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Role--&gt;FinanceOperationsMarketingRegion&nbsp;&nbsp;&nbsp;AsiaBillLiamAnneEuropeStephPaulMaria&nbsp;Each Record in the Change Request table is linked to the region and has a change request type.&nbsp; For&nbsp; change type 1, I need approvers from all roles.&nbsp; For change type 2, I don't need Marketing.&nbsp;&nbsp;Part 2 of the question is that I would like to send email notifications only to the selected approvers.&nbsp; Is there a way to send a notification to the users in the names of multiple fields with one notification, or do I need 3 notifications to send to Finance, Operations, and Marketing?&nbsp;Thanks in advance!Chuck&nbsp;

chuckhardy · Answer

P.S.&nbsp; I forgot to mention that I have considered a "cheat" where I use a form rule to copy the imported data to a new "role approver" field in my form. This may work but I'm guessing there is something more elegant.

Role-->	Finance	Operations	Marketing
Region
Asia	Bill	Liam	Anne
Europe	Steph	Paul	Maria

Forum Discussion

Choosing Approvers from Related Table