Manual Trigger Excel Attachment, to Word Doc Template, To PDF to Shared Email

[SpartySteve33]

Hello - I've been working on this for a few hours, and am a bit stuck.

I am trying to use a standard xls template that our team uses for events to send out pdf certificates to people completing the class. We take the reporting from an event from Teams Webinars and adjust it a bit to use as the xls input file.

I would like to do the following:

1. Manually select the xls file to be used with Power Automate after each event from an xls file stored in SharePoint.

        -Note: We have not found a way to take the Teams Webinar file automatically to start this process, so manual is okay for now.

1. For each xls row, use participants data to fill out a word doc certificate to eventually be converted to pdf and emailed to the participant.

Power Automate Flow:

1. Manually Trigger selecting the xls participant data attachment to be used
2. Use an already created certificate template from Microsoft word stored in SharePoint using xls data for template fields created (similar to mail merge). Template fields include: Title of Event, Name of Participant, Number of Credit/CPE Hours, Date of Event
3. Convert each individually created Word doc to PDF
4. Save each PDF in a share point folder with name of person_eventtitle.pdf in a folder structure such as (Event_Year->Event_Month_Date)
5. Email the certificate to the participant email from each row in the xls sheet using a shared email account.

A few of us have the Power Automate Premium License/M365 Business Premium Accounts, while the rest of our team just has the Free Power Automate and Business Basic Accounts.

I started this, but i keep getting errors.

Thanks in advance for any assistance.

[AlexEncodian]

@SpartySteve33 

This should be relatively easy to set-up. What are the errors showing / can you expand the actions that are erroring so we can see what you have done?

Note, if you don't have wide ranging premium licensing, the Encodian connector is standard and comes with 150+ actions including all the above:

Populate Word Document

Convert Word

[SpartySteve33]

I'm getting stuck on converting the word document to pdf, keep getting errors.

How I'm calling the create PDF to the dynamic create word file location is not working. Have also tried body/ID to call it.

[AlexEncodian]

@SpartySteve33 

If you select the File via the folder icon, you'll be able to see what the input needs to look like. Probably, it needs a file path as the connector wont know which folder you're looking in

[SpartySteve33]

Yes, that was a major miss. Thanks for the catch on that. I thought the body/path would work.

Last item i'm trying to fix is the email send from a shared mailbox.

The error in the flow is caused by using a non-Groups URI with a Group Shard. To fix the error, you should check the 'dataset' parameter in the 'CreateFile' action and ensure that it is a valid Groups URI. If it is not, you may need to update the parameter to a valid Groups URI.

[AlexEncodian]

@SpartySteve33 

Have you checked the parameter in the Create File action? 

Could also be a bug with the new designer. Try switching to the old designer, deleting the dynamic content in the Create File / Send email actions and re-adding it.