Power Platform Community Forum Thread Details

Using Power Automate with Forms, SharePoint and Word Template

Hello -

On my team, we are responsible for formatting job postings in MS Word from position descriptions uploaded in pdf format to our system. Usually, this involves manual cutting and pasting of job descriptions from pdf into Word, then doing all editing and formatting in Word, finally copying and pasting the job description into our Applicant Tracking System for posting. This is a very manual process and lately our team has been very inconsistent with formatting, causing our job descriptions to view/read poorly for our job seekers. So, to automate this process, reduce error, and create more consistency and compliance around our job postings, I created a Microsoft Flow.

Callouts:

1. We do not have access to the Premium Word Online connector, so we are unable to build a flow with that connector to accomplish this task.

2. We cannot change the format of pdf documents. Most of our team doesn't have access to pdf editors. The idea of the flow is that ALL of the formatting is performed in the flow.

3. The goal is for this process to be completely automated. The MS Form responses are the input, the Word document with a completely formatted job posting to be cut/paste into our applicant tracking system is the output.

Please see the following:

1. Here are screenshots of the pdf that we start with (that we copy/paste text from into the MS Form responses:

2. Power Automate JP Automation Flow and Form (attached) - screenshots of the workflow from Power Automate and the MS Form we are cutting/pasting text into from the pdf. Please note that there are 10 sections each for the Role Requirements, Required Qualifications and Preferred Qualifications - I left these out of the document for sizing purposes.

3. US TA Job Posting Template (attached) - this is the template that the forms responses are uploading into to create the Job Posting

(Sorry - I was only able to attach 2 documents with this case)

4. This is a screenshot of the output from the flow from MS Word:

The content appears to be transferring over fine and the formatting of the template remains intact. However, there are issues with the spacing due to the formatting of the pdf, which we cannot change prior to pasting into the MS Form. Can anyone help me with figuring out why the output is not spacing correctly and what can be done (if anything) to fix it? Is it an issue with the flow, or is it an issue with the Word template?

Quick Links

Leaderboard > Power Automate