Create a Certificate with multiple dynamic values

[PrudhviL]

Hello Community,

My Requirement: Create PDF of the people who complete particular Training. The PDF look as below image  

Here, everything is dynamic. The body has to change Dynamically depending on the kind of training taken.
The Full name , Training Name, Status and Date Submitted are obtained from the Sharepoint list  

I would have Implemented This Video (Generate PDF using Word Template)

The Problem is I have 20 different Trainings, so I'm not sure how to implement it. 

I do not want to keep 20 different templates (Which is like creating 20 different flows), so that's why I want to make 1 flow where I can Dynamically change data depending on the type of training that the person chooses.

So, 20 trainings are unique values each and yes they can be a variable

The data is inputted from the Power apps and Saved into the Sharepoint list.

From the SharePoint list I take the data and create the Certificate. 

I want the trigger to be automated, When ever an Item in is created in the Sharepoint list It should take the details like the Full Name, Training Title, Status(Qualification level achieved) from the SharePoint LIST

But Again here coming to the body i.e. the below part. It is Dynamic and the whole paragraph varies for every training. All this data is based on an excel file where for every training there is the body that has to be placed. 

Has demonstrated in-depth knowledge and proficiency in methodology and has successfully applied the appropriate Tools and Techniques to deploy [Training Name] on the Shop-floor to reduce Defect/Rework/Retrofit at the Final Control aligned with a robust ¬¬Control Plan, Work Instructions and Control Sheet updated regularly based on REX to ensure Right First Time and Customer Satisfaction.

In recognition of this important contribution for Alstom,     	  
is awarded                          for this competency.

I would appreciate any kind of help with ideas or work arounds.
Please help!
Thank you so much!

[SanmeshG]

Hi @PrudhviL ,

I have tried an approach and it works fine. Please see the below steps. 

1. Create a List and store each Training Name and the Certificate Content , here the Certificate Content should have a placeholder , like EMPLOYEE_NAME_HERE, TRAINING_NAME_HERE

2. Replace each of the placeholder with the dynamic content.

3. Now use the Dynamic Content to create HTML , Convert it to PDF and then create a PDF File.

//Get Dynamic Content(Here the Content varies based on the Course/Training Name) with Placeholder
outputs('Get_items')?['body/value']?[0]?['CertificateContent']

//Replace the Placeholders with the Dynamic Values(For Eg. Employee Name, Trainig Name) from your SP List-this replace expression may vary based on the fields you will have
replace(replace(outputs('Dynamic_Certificate_Content'),'TRAINING_NAME_HERE',outputs('Get_item')?['body/Training']),'EMPLOYEE_NAME_HERE',
outputs('Get_item')?['body/EmployeeName/DisplayName'])

2. You use that Content which is replaced with all the dynamic values.

If this helps , please give this answer a thumbs up and accept this as a solution.

Thanks,

Sanmesh