web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Export to file for pag...
Power Automate
Unanswered

Export to file for paginated reports - count rows

(0) ShareShare
ReportReport
Posted on by

Hi,

 

Task: export file for paginated report > check if file has at least 2 rows > if yes, send it in attachment.

Note: it will always have at least 1 row - header, this is why i need to check if it has at least 2 rows.

 

nandic_0-1648196192496.png

 

Additionally, i see that there is such option of data in Excel is set as table. However, in this case it is plain Excel without any tables.

 

Best regards,

Nemanja

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    on at
    Re: Export to file for paginated reports - count rows

    I also have the same query. Can someone help on this topic?

  • b2wise Profile Picture
    23 on at
    Re: Export to file for paginated reports - count rows

    @Expiscornovus @takolota Hey gurus! Any idea?

  • b2wise Profile Picture
    23 on at
    Re: Export to file for paginated reports - count rows

    Hey I posted a similar question and figured out a solution.

     

    Note the file size when blank, create a csv file in sharepoint and use 'Update File' to save the paginated report over it. Use 'Get file metadata' to get the file size and set the condition greater than a blank file size (kb)

     

    A bit clunky but it works.

     

    b2wise_0-1667345139608.png

     

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard