Need some help in designing a workflow.
A simple sequential approval workflow that has to pick approvers based on the requestor and the amount requested.
|Requestor||<1000 (all approvers)||1000-2000 (all approvers)||>2000 (all approvers)|
|User1||User2||User2, User3||User3, User4|
|User5||User3||User3, User4||User3, User4, User6|
The number and who approves depends on the requester and also the range.
My idea was to maintain this exact table in a list with the columns as multi user columns. Query this column value into a collection. Loop through and set the approvals.
Q1 - is this an ideal way?
Q2 - will the collection always have the users in the same order as I enter in the multi user column?
Thanks for your inputs.