For the last few days, I’ve been trying to figure out one mysterious aspect of “Export to File for Paginated Reports” action, which is that it was always taking just a little more than 30 seconds to complete.
Which, even for the simplest static paginated report that would not even connect to a data source, would always result in the flow duration which is just over 30 seconds as well:
There was a support ticket, yet I kept asking around, and, eventually, it was confirmed that this is just how it works because of some internal details, so we should expect 30+ seconds there.
Would it be reasonable to ask the users to wait for about 40-50 seconds just to get the invoice generated when it’s part of the process where the end client is waiting for that invoice? It’s a good question, and I don’t, yet, know, what the answer would be, so may actually have to fall back to the word templates in this particular scenario.
There are other scenarios, though, where 30 seconds wait time would not make any difference (that’s when it takes longer to generate the report anyways, or when the process is a-synchronous by nature. As in, when the report is supposed to be sent by email/stored in Sharepoint, for example).
Anyways, at least now I know what’s happening, so I can stop thinking I’m losing my mind
PS. There is ItAintBoring PowerPlatform chat session coming up on Oct 12 where we’ll talk about Power BI paginated reports in particular, but, also, we will, hopefully, have a broader discussion about document/report generation in Power Apps. If you have something to share, or if you just wanted to listen in, don’t forget to register for the event: https://www.linkedin.com/events/oct12itaintboringpowerplatformc6843586222267478016/