I have built a Power App that allows users to submit a request form for multiple different items, each of which can be submitted together, but then is added as individual line items in a SharePoint list so they can be approved/rejected individually. For example, if the Power App Form is filled out one time with 10 requests, 10 items get added to the SharePoint list, each under the same title. I am hoping to accomplish the following:
1. Combine all 10 items into one email to be sent to an approver.
2. Create a Power App interface from the SharePoint list that will allow an approver to easily find these 10 items from the long list
3. Allow an approver to comment on and either approve/deny each of the 10 requests without having to individually click on each one .
Does anyone have any ideas? I am wondering how to aggregate these items together based on "name" so that the approver can see them all in one place, and make comments/decisions as necessary. I am hoping to use the SharePoint list to feed a PBI dashboard, so I want the approval status to be updated live on the SharePoint.
I appreciate any advice/ideas/insight!