Hello i'm quite new in building flow. anyway i'm trying to design a flow for my document library and im trying to figure out how to do the following:
1. Custom approval matrix: i have been building a multi-level approval process every time a document is uploaded in the library. My problem is i want it to be dynamic approvers depending on the person created/uploaded the document. I can't use the get manager step since the flow of the document approvals does not coincide with organizational hierarchy. I already created a sharepoint list to define the approval flow for each of the individual.
| contributor | First level approver | second level approver | third level approver |
| Person A | Person B | Person C | Person D |
I am thinking of getting a condition action for this, my question how can i perform a lookup that says if file created by = contributor, then get first level approver?
2. Customize approval process.
Aside from either approving or rejecting the document, i would like to put as an option to endorse it to a particular person. So a person receiving an email from flow, can either approve, reject or endorse it to another person.