Forum Discussion

abpgupta's avatar
abpgupta
Continued Contributor
5 years ago
Solved

Paginated Report: Excel Output as Tables

Hi All   I noticed when we download Excel output from Paginated report, it doesn't create Excel tables for outputs. Because of this, when we use it in Power Automate to read, we have to add additio...
Need Help
Tips and Tricks
  • AbhiSSRS's avatar
    AbhiSSRS
    5 years ago

    Please create a pixel aligned table in paginated with loaction 0,0 and column width in round numbers or 1 decimal only eg 1,1.5,2in . Also please do not merge any headers in groups that you create. This would help create a valid table output. Click Advanced mode in groups to verify your settings as below :

     

mohammedadnant's avatar
mohammedadnant
Impactful Individual
5 years ago

Hi abpgupta 

 

Paginated report will export the table exactly to each cell in the excel.

it will happen only when you design the report correctly.

for an example: if you design the report like this below image,

the 1st column will split into 2 due to the title of the report, 

try to place the objects in place to export exact result in the excel.

 

 

Thanks & Regards,

Mohammed Adnan

Learn Power Platform for free: https://www.youtube.com/c/taik18