Create pdf from 2 SharePoint list and multi entry child table

[zmansuri]

Hello,

Use case is simple. There is a form and gallery which creates entries in two tables. One is Order Header and One is Line Item. One Order header has multiple line items. Attaching sample datasets.

Header table

Line Item Table

What i need is create a pdf that looks something like this:

Seller Name	Seller Code	Priority
Seller1	123	Low

Line Items:

Item Name	Item Price	Quantity	Total
Soap	10	10	100
Towel	20	10	200

In the power automate i have set the trigger in items created on header item and then based on the id i fetch line items. I don't know what to do next. Lie how to merge this two arrays and supply it to create html table.

[MarvinBangert · Accepted solution]

Hi @zmansuri 

I would say you don't need to merge these two arrays as you also want to display them later separately inside two HTML tables. You can use the "Create HTML table" action within Power Automate to generate your table from the arrays (actually one array and one object as the trigger only runs on one item).

Depending on your license, you could either use a Word Connector (Premium) to populate a word template with your information, please check out this blog post: Intermediate | Flow of the week: Create PDF Invoices Using Word Templates with Microsoft Flow | Powe...

Otherwise, you can also create a html file first, save it to onedrive and afterwards convert the file to PDF. Here you can find some examples how to do it: Power Automate Create PDF + 11 Examples - SPGuides

Does this help you? Otherwise please give me some more information.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Blog: Cloudkumpel
Join my User Group (German & English): Power Platform UG Cologne