Power Platform Community Forum Thread Details

I have a complete flow that takes an excel file and converts to PDF. But it's taking both "sheets" from the excel file. I only want the one sheet/tab to be converted to PDF.

I have searched high and low, but can't sort it out. I don't have access to third party flow apps because this is through a work account.

Is there a way to create a "new" file that only has the one tab from the original excel file? and then i could convert that to PDF?

Having a very hard time figuring out how to build a flow to target the one tab.

Thanks

Categories:

Building flows

Will it always be the same format??

If the format is always the same

1) I would create an Excel file, that has only one sheet, and in that Sheet, put the headers etc (no data) and then add an Excel Table around the headers and first row

Its required

1b). I would then Copy the Template you made to another File, that you will use as the Receiver of this data. You want to keep your template there all the time to make this easy.

2) Make sure that your Original File, has an Excel Table around the Data you want. If its NOT there, then you need to use the Create Table action for Excel and add one,

3) Use a List Rows in a Table action to loop through all the Items in your Source Excel using the Excel Table Name you either created in Step 2 or if it already had one

4) Use an Apply to Each (For each in new UI) to look through all the ROws found in step 3

5. Inside the Apply to Each, use the Add a Row to a Table Action in Excel, to use the Data in the Current Iteration of the Loop, to add a new row into the Table in the Copy you made of the Excel File I had you create

Once thats finished, you are done.