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 :

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi abpgupta ,

 

I did a test. If I understood it correctly, do you mean to have a clear table without any formatting?

 

 

Best Regards,

Yuna

 

 

abpgupta's avatar
abpgupta
Continued Contributor
5 years ago

Anonymous , I meant to format as Table so that Power automate can recognize various tables created in Paginated report and can be used further to extract data. 
in desktop report export data does it; however, we have to download one by one manually. I think Paginated Report can provide automated way to extract excel outputs for multiple tables in a report and send custom data alerts.