I have an excel file that is used to populate a SharePoint list with new invoices that have been received. After the information is uploaded to the SharePoint list I have a manually triggered flow which sends the selected list item (invoice) to a dynamic approver along with any attachments. The approver gets an email in Outlook with the attachments and various details related to the invoice which they can use to Approve/Reject. Details of the approval/rejection are captured in an Approver Comments (Single Line Text) column.
This accomplishes 50% of what I need, and I don't know if it's possible to figure out the rest of my problem.
Essentially, each invoice can relate to multiple projects, and I need the approver to supply multiple percentages as a result. So for instance if I send an invoice for approval they would need to be able to input and respond back with:
50% Project 1
25% Project 2
25% Project 3
Additionally, if it were possible I would really like the ability to provide a dropdown for them to select from a list of active projects, rather than just giving them a blank field to input the information.
I understand that when my flow sends the email request that only approval can be required and that I can't use power automate to request/require additional information in the email. I have seen around that I could potentially use PowerApps to send a partially completed form to the user for approval/additional information, but I can't find anything resembling a working example of that, and have no idea how I would start that from scratch as I have almost no experience with PowerApps.
If anyone has any advice, examples, or resources that could help assist me with this I would really really appreciate it.
