Hello All,
I have this requirement where in a PDF to be generated when an item in a SharePoint list is submitted. With Automate flow, I am able to generate pdf using OneDrive approach without using any Premium connectors.
I am stuck at a point wherein, in my list, there are some fields types and depending upon the value, the row color should change. For instance,
- When it is graded E, the row color should be in red,
- If graded D, row color should be in orange
- If graded A, row color should be in green
With word template, i am unable to generate it as rich text formats are converted to plain format so all the html tags were displayed.
So, started with another approach of generating html and convert it to pdf.
The approach is
1. Created a html template and inside the template, placed few placeholders where the list field value has to be populated.
2. Fetching the html content and using REPLACE expression to update the placeholders with live data coming from the list
3. Using creating the html document in OneDrive and converting it to PDF using OneDrive PDF converter and placing it back in SharePoint Document library.
Inside the html template(mentioned in 1), added few javascripts in the body of the html to dynamically apply the changes but when it is processed via Automate flow, the changes are not visible.
Can someone suggest on what could be done? It is been a while we are waiting for rich text inclusion by Microsoft till then have to work with some alternate approaches.
Appreciate your valuable response.
Thanks
Anupama
