Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a scenario here, hope someone can help:
1) 5 columns of data from excel
2) 100 individual pdf files
I would need to import the 5 column data into the individual pdf forms, it is possible?
I try to google for answer for an hour and could not find anything, hope, experts can help here. Many thanks
Solved! Go to Solution.
Hi @WISM
Power Query is not a right tool to do that job. You could try other tools or methods, for example:
Automatically fill and send 1,000 PDF forms with Excel data [Step-by-step Guide 2021] - YouTube
How to AUTOMATICALLY Fill PDF Forms Using Microsoft Excel in 1 CLICK - YouTube
Fill a PDF Form with Microsoft Power Automate — Encodian
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
there is a new option in 2023, much simpler, no coding required - Power PDF Filler Add-in for Microsoft Excel
https://appsource.microsoft.com/pl-pl/product/office/wa200005545?tab=overview&exp=kyyw
5-min video walkthrough: https://www.youtube.com/watch?v=w6h7s8COkXA
Hope this helps!
Hi @WISM
Power Query is not a right tool to do that job. You could try other tools or methods, for example:
Automatically fill and send 1,000 PDF forms with Excel data [Step-by-step Guide 2021] - YouTube
How to AUTOMATICALLY Fill PDF Forms Using Microsoft Excel in 1 CLICK - YouTube
Fill a PDF Form with Microsoft Power Automate — Encodian
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
This sounds like a job for Power Automate Desktop. I haven't done what you are asking, but just pointing you to the right tool for the job IMO.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.