We are wanting to set up an automatic workflow that saves a Purchase Order upon "confirmation" in Dynamics 365 Finance & Operations, over to a folder in Sharepoint online to be viewed there. We think that we need to use Power Automate to do this workflow although I cannot see a suitable template.
Within Sharepoint we want the purchase order information (eg PO number, Supplier, Order Date, Description, Net, Vat, Gross) to be populated as file information, and a new folder to be created for each new Supplier - I think that we need to use metadata/content types in Sharepoint, but again I have not found a suitable tutorial that encompasses all these requirements.
It would also be useful to send an email notification to the requisitioner that their purchase order number XXXX has been approved and please go to this area XXXX in SharePoint via this LINK.
Any help to achieve these requirements would be very welcome.
