Hi There,
Yes, the process can be achieved using Power Automate with standard connectors.
Use the "When an item is created or modified" SharePoint trigger to initiate the flow when Managers update the SharePoint list.
Use the "Get file content" action to retrieve a template Word document stored in SharePoint (or OneDrive) which acts as a certificate template. Utilize the "Populate a Microsoft Word template" action to populate placeholders in the Word document with the updated details from the SharePoint list.
After populating the Word document, use the "Convert Word document to PDF" action to transform the populated Word document into a PDF format. Use the "Send an email (V2)" action with the Office 365 Outlook connector to send the generated PDF as an attachment to the user.
Utilize the "Create file" SharePoint action to save the generated PDF to a designated SharePoint document library.
All the above steps can be accomplished using standard connectors available in Power Automate without the need for premium connectors.
Please give kudos and mark as solution if it helps.
Thanks,
Sandeep Mishra
