Showing results for 
Search instead for 
Did you mean: 
New Member

how to create a flow to populate my excel template and create a file

We need to create a flow as per below

1. User submits a purchase requisition form

2. We have Excel Template, the fileds from this from populate the excel template


3. Creates an Excel File in PRF Document Library with Name Format : "PRF-'Number to derived from Form"

4. An Email is sent to Approver01.

If Approved -

a) A digital Signature to appear below approvers name on the template. Or the Term "Approved" appears against the approvers name. (please note the same excel file in the sharepoint DL to be updated with the Digital Signature/"Approved")

b) An Email sent to Approver02. Who clicks on "Approve"

c) Now the "PO" template is updated with the fields from the Form/PRF file and a new file created in PO Document Library with Name Format: "PO-Next available number"

d) The PO is then sent to the initiator as an "PDF" attachment. to print - stamp - signoff by "Approver02"

Note - Can we automate the PO to have the signature and company stamp too into the template?


If Rejected by "Approver01" - The term "Rejected" to show against the name. And the status of the PRF in the list & document library to show "Rejected" and an email sent to an Initiator saying PRF Rejected.


Super User II
Super User II

After quickly reviewing your requirements I believe that Flow can perform most if not all of what you are seeking.

If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.

If you have trouble getting started with Microsoft Flow I strongly suggest making your way through this free Flow training documentation:

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Community Support
Community Support

Hi @psunith1476 ,


About step3, “create an Excel file in PRF Document library with Name format”, do you want to create the file using the content of the Excel template?


Do you want to add the signature and company stamp into the template automatically?


Please take a try with connector DocuSign, which is the easiest way to sign and get documents signed:


Best regards,



Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (15,978)