Power Platform Community Forum Thread Details

Let's say I have a sharepoint list as follows:

ColumnA ColumnB ColumnC

Row1 1 2 3

Row3 1c 2c 3c

On the same sharepoint environment, I also have an excel spreadsheet. It looks like this:

ColumnA ColumnB ColumnC

Row1 1 2 3

Row2 1a 2a 3a

Row3 1b 2b 3b

Row4 1c 2c 3c

My goal is to use a flow to instruct the Excel spreadsheet to either (whichever the Power Automate community feels is more efficient):

1a) Hide the missing rows (in this case, 2 and 4) from the excel spreadsheet

Or:

1b) Delete the missing rows from the excel spreadsheet

2) Check that 1a or 1b is completed (eg using a 'do until' with some kind of task monitoring variable)

3) Send the resulting spreadsheet to the user as an email attachment (I have actually done this part successfully, but I thought I would mention it to give some context to the extra item below). It needs to be an attachment rather than a table written into the HTML of the email because our userbase will not be able to use the latter effectively.

4) If 1b) is the most efficient method, then restore the deleted rows to the table (eg delete the table and copy another from elsewhere).

I appreciate this is a big ask! Any assistance with any part of the above would be extremely helpful 🙂

Categories:

General topics