I have a power automate flow that converts an excel workbook (5 sheets) into a PDF. The PDF shows all the tables, but I only need the first one because the others are the backend tables for my calculations. I have been doing research and they all take me to a third party connector which I do not want to do because this flow will be called a lot throughout the day.
The first page shows my main table and is dynamic and connected to the other worksheets, but I do not want the other four sheets to show.
Is there a way to copy over my calculated values to another sheet without loosing the information? Then I can convert that one worksheet into the PDF.
Or is there a way to only grab the PDF's first page without using a third party connection?
Any tips or guidance is much appreciated! Thank you.
