I have a workbook which takes forms submissions for equipment inspections and displays them as a daily checklist log for the month. I have designed these checklists in a specific way to resemble my company's paper format. I am trying to build an automated flow which takes each sheet and exports it with the sheet name as the file name and saves it as a pdf in a single folder. I cant find any help on this which doesnt require reformatting of the checklist. The checklist I built is not a table on excel because I couldn't get the formatting the way I wanted when it was a table because you can't merge cells on a table in excel.
I can currently get each worksheet to save to a destination, but the worksheets are always corrupted.
This is my current flow:
The Convert File step always ends up as "Bad Request".
I am lost if anyone can help.