Hi Guys,
I am a new PA user and have been thrown in at the deep end at work. I have been asked to build a new solution that will allow users to request a new product. The request will go through 3 levels of approval and there will be 3 approvers on each level. At each level, 2 out of 3 approvers must approve before it moves on to the next approval stage.
My questions are:
1. I wanted to ask about storage, there are a possible 9 different approvers for each request, I need to capture the decision of each approver including the date and any comments. Should I store these details in a separate table? Coming from a SQL background it doesn't make any sense to store everything in the one place.
2. Should I be using Sharepoint List or CDS? I assumed Sharepoint List but that's only because I hadn't heard of CDS until today. My company has premium license for Office 365
3. Design considerations for the flow itself, I was thinking of a modular approach, having a flow for the approver work, being called and controlled by a master flow. Does this seem like a reasonable approach?
If you have any additional tips for me, I sure would appreciate it 😃