Power Automate - SP Custom List to PDF with Grouping applied

[SanjayAdsure201]

Dear All,

Thank you for taking time to read this. My scenario is as follows:

I've a custom SP Online List having total rows more than 4000. Column count is four. One of the column is 'Department'. I can apply grouping on SharePoint level & get data on SharePoint site. But requirement is I need to create a PDF file having all rows & in PDF, it should get grouped by 'Department' column. 

So if one of the Department name is 'ABD' then I need to show as 'ABC' in a row & below that I will have all the rows where department is 'ABC' and like this for other departments. I tried to do this using custom script but it's saying 

"Blocked script execution in 'about:srcdoc' because the document's frame is sandboxed and the 'allow-scripts' permission is not set."

Need to implement it on urgent basis. Any help will be highly appreciated.

Thanks,
Sanjay

[v-bofeng-msft]

Hi @SanjayAdsure201 ,

Do you want to get something like this:

My table:

The Result:

If so, I've made a test for your reference:

In addition, you should turn on the "Pagination" function for the get items action and then set the top count to 5000.

Best Regards,

Bof

[SanjayAdsure201]

Dear Bof,

First of all, thank you very much for your reply & the details steps. By following these steps, I was able to get it in the format you mentioned. But I need it to be in the format as mentioned below. Could you please help me to tweak the code so table will be formatted in below way. Also I am getting error if column 1 or 2 or 3 has null value. Can you please let me know how can we handle that?

Thank you for all the help in advance.

Thanks & Regards,

Sanjay

[v-bofeng-msft]

Hi @SanjayAdsure201 ,

This formula can avoid errors caused by null values :

item()?['Column1']

In addition , the format of the table you asked is hard to achieve, cause It involves the  'colspan' property in the CSS syle  , but the convert file does not support the css style.

Best Regards,

Bof

[SanjayAdsure201]

Dear @v-bofeng-msft 

Thank you for your prompt reply.

Then can we use your previous solution & instead of column headers coming in each block, if we keep it at top so it will look like as below? 

Thanks & Regards,

Sanjay

[v-bofeng-msft · Accepted solution]

Hi @SanjayAdsure201 ,

Please try:

The result:

I think this link will help you a lot:

HTML Tables 

Best Regards,

Bof