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 :

     

setis's avatar
setis
Post Partisan
5 years ago

I have exactly the same question and I can figure out how to export as an exel table to be able to use it from Power automate. 
I get the data exported but without the proper table formatting. abpgupta did you figure it out?

  • abpgupta's avatar
    abpgupta
    Continued Contributor
    5 years ago

    Yes, in Paginated Report, I created a dummy column with value as 'ALL' for export. creating it at (0,0) position ensures there are no additional blank rows to deal/filter with.


    Then in Power Automate, used "create table" giving a suitable high range with custom table name.  

    Then used List value present in table with filter on dummy column (eq 'ALL') to exclude blank rows from table. 

    Now with this output , you can populate data to other steps.