I have a Excel macro file (workbook) which requires to be uploaded to OneDrive for Business and converted to PDF. Trigger is When a file is created. Then using standard Convert File action (PDF format) and then Create File which does not give any error. However, the created PDF file has 0 bytes and does not open as a PDF in browser or Acrobat Reader.
I have also tried to save the file as XLSX (non-macro) file, but same result.
One reason for the problem may be that the file has multiple worksheets (about 15). I have defined a Print Area in the Excel. Also, I have a Name Range defined for the area I want to print. Not sure what will help.
UPDATE:
After a of tinkering I found the issues that prevent Excel to PDF conversions (using OneDrive Convert File action).
Issue still present:
Hi @YatinMumbai ,
Have you tried using Get file content action or Get file metadata to get the file size and File content?
See if its file contents can be referenced normally and if the file size is as expected.
In addition, you can create a simple Excel file to perform a similar test and see if such errors also exist. The purpose of this is to confirm whether this is related to the reason for the problem you mentioned.
Best Regards,
Michael E. Gernaey
179
Super User 2025 Season 1
David_MA
161
Super User 2025 Season 1
stampcoin
143