Key value: ID_Number (Again, I am not sure of the relevance of the key value here.

I presume that the key column is important when performing logical tests, since it is checked for its value?) Key column: ID_Number (I honestly wasn't sure what to put here. (Note that I am simply looking for a test that will always evaluate to true, and I see no reason why this wouldn't do so). Library: Sharepoint folder containing Excel fileĮxcel column 2 ('ID_Number') is equal to Excel column 2 ('ID_Number'). Location: Sharepoint name containing Excel file When an item is created or modified (in the specified Sharepoint site address and list name): (I am assuming that in order to delete a row, a condition must be met (ie, there is no way to simply delete rows without performing a logical test). The destination is an excel spreadsheet, which must be emptied/have all rows removed when this list is modified. The flow is triggered when a Sharepoint list is modified. The flow is marked on Power Automate as running successfully (which I believe confirms the flow is running and that there are no apparent errors, so that's good at least) but the table rows aren't deleted.

(Yes, my table is definitely an excel table, not a range! ) I am trying to delete all rows in a table when a flow is triggered.

Hiding the rows and columns is a permanent solution.I'm new to PA/Flow and very confused by this-deleting rows (no conditions, just empty the entire table) seems like a pretty obvious objective. The VBA properties are reset when you close and reopen the spreadsheet, so disabling scrolling and editing is just a temporary solution. Even if the rows are visible, nobody can edit them. When you disable scrolling, you also disable editing. For example, to scroll through rows 1 through 100 and columns A through Z, type 'A1:Z100' (without the quotes). Type the letter of the last column you want to display before the number of the last row.

In the ScrollArea field, type the letter of the first column you want to display, before typing the row number. You can temporarily disable scrolling through - as well as editing - columns. You can hide and unhide rows and columns that contain data, in case you don't want people to edit them accidentally. To unhide all rows, press 'Ctrl-A' to select everything in the spreadsheet, click 'Format' in the Cells group, select 'Hide & Unhide' and then click 'Unhide rows.' To unhide all columns, click 'Unhide columns.' Click 'Format,' select 'Hide & Unhide' and then click 'Hide columns' to hide the columns. Hold 'Ctrl-Shift' and press the 'Right' arrow key to select all columns. Don't try to scroll to the last column because Excel 2013 spreadsheets can contain 16,384 columns. Locate the last column you want to be visible in the spreadsheet and then click the header of the next column to select it. You can also hide columns to prevent people from editing them.

Excel how many rows in a table