Hello,
I am trying to create a power automate flow which is triggered by a form with an attachment being submitted. When the form is submitted I want the following actions to occur:
- Item to be created in sharepoint, when clicked on it takes you to the form and the attachment appears in the sharepoint list for easy viewing.
- An email to be sent to an approver with a summary of whats in the form a copy of the attachment and the option to approve or reject.
- Sharepoint item to be updated with an approved/rejected status, approved/rejected by and comments.
- E-mail to be sent to requester based on outcome.
I have made numerous attempts following various videos but i'm struggling to achieve the above. Here is the flow I have built:
Challenges I am facing are:
- I can't get the attached file to attach to the email or the SharePoint list, even though I have the column available on the sharepoint page:
- 2 emails are being sent to the approver, one with the details and a link to the SharePoint view which isn't for the form. The other is a notification type email to see the form, not receiving anything with the option to approve/reject.
Can anyone help me resolve these challenges? or am I asking for something that isn't possible?