I am working on creating an approval process for a pricing deviation for our department.
The current process is as follows.
- Deviation created
- Review for approval
- If approval is needed, determined based on value, then email the first approver in the assigned list. They will review and approve or reject. Once approved, if the value required an additional level of approval then it is sent on, if it does not, then it is filed, closed and entered in our system.
- This process will repeat until all approver levels for a specific value have been met.
- Example values for approval
- <$10,000 auto approve
- >$10,000, but <$56,000 first approver only
- >$56,000, but <$113,000 Must include first approver, then final approver at new level.
- >$113,000, but <$250,000 Must include all previous approvers, then final approver at this level.
- >$250,000 Must include all previous approvers, then final approver at this level.
We input the data into an Excel sheet. I would like to have a process flow that will pull the data from the excel sheet to a list, or have a list that we can attach the excel sheet to, so that it can be used to submit for approvals and follow the value based flow.
Is this possible?
I have taken a stab at it and I have a flow that will auto approve the first level, but then when it comes to the addition levels, it send the request to everyone versus using the value to determine who will be assigned the request and when they will get the approval request in the process.
