Forum Discussion
'Export to File for Paginated Report' Flow action failing
With a little serendipity I found a solution. There is definitely strange stuff going on. I hope Microsoft team reads this as it definitely should be looked at.
After trying for hours to get the call to Export Paginated Report to a File working within Apply to Each and not able to get around 'The response is not in JSON format.' error I gave up. Instead of a simple Flow with 6 steps, I was adding export and its processing individually. 160+ steps, painful and error-prone but I needed something working tomorrow. I added about 50 steps and took a break. When I resumed I was using the copy step to clipboard functionality to speed up getting them in. I opened one and instead of the text for Workspace and Report Name, there were guid's. Bizarre but serendipitous, and when I opened the step a minute later, it was displaying text again, not guids.
I got the guid's for each report and redid the logic to pass those in and it works. Strange but true.
With a little serendipity I found a solution. There is definitely strange stuff going on. I hope Microsoft team reads this as it definitely should be looked at.
After trying for hours to get the call to Export Paginated Report to a File working within Apply to Each and not able to get around 'The response is not in JSON format.' error I gave up. Instead of a simple Flow with 6 steps, I was adding export and its processing individually. 160+ steps, painful and error-prone but I needed something working tomorrow. I added about 50 steps and took a break. When I resumed I was using the copy step to clipboard functionality to speed up getting them in. I opened one and instead of the text for Workspace and Report Name, there were guid's. Bizarre but serendipitous, and when I opened the step a minute later, it was displaying text again, not guids.
I got the guid's for each report and redid the logic to pass those in and it works. Strange but true.
