Hello!
I am trying to create an approval workflow using two lists. I need list A to be an approval intake and list B to track the approvals. I want the reviewers to be able to create an item in list A and select multiple people to assign it to and then begin the approvals. I also want to simultaneously create a matching item in list B for each reviewer assigned in list A and set the approval status to pending. I would then set the approval conditions to update list B as approvals/rejections come in.
Ex:
List A- List item added and assigned to Mary, Joe, and Brad in one list item
List B- 3 total list items created: one for each Mary, Joe, and Brad. List A columns would all be copied over, and each item would be in Pending status until approvals come through.
I think I know how to set up the approvals and status updates after approvals, but I don't know how to break out one item into multiple items.
If there is a better way to do this, I am open to ideas. I just need to be able to assign to multiple people at once and then see approval status broken out by person somewhere besides Approvals. I also can't connect Approvals to Power BI without using a premium connector.