Error 404 - Resource Not Found Excel

[Anonymous]

I am building a Flow that reference Excel multiple times in order to build a SharePoint list that will trigger emails. I have ran into the dreaded Error 404 multiple times now but usually a built in delay will suffice to circumvent the problem (due to Excel online limitations). However, using Delete Row to delete empty rows from a table (work around from another problem I'm having) will not seem to work even with a delay coming back with Error 404.

How can I get around this error? It makes no sense. The path to the file and the file itself have been referenced in actions previous with no problem minus some delays. 

[v-yamao-msft]

Hi @Anonymous ,

Could you share a screenshot on how the flow is configured?

What value are you using for Key column and Key value fields?

I guess that you are trying to delete rows when certain field is blank. If so, please check the following workaround.

In my scenario, I am going to delete the row if the Id column is empty. However, the column Subject always has value, so I use Subject column for key column and key value fields.

The function used in the Condition is:

empty(items('Apply_to_each')?['Id'])

is equal to

True

An image for your reference.

Best regards,

Mabel          

[Anonymous]

@v-yamao-msft  - Thanks for this, however, I have no fields with values in each row. This table is inflated in order to ensure I capture all the data, but I want to go back and delete all the empty rows before I start loading the items into SharePoint. If you know how to create a table with variable rows, I'm all ears. Otherwise, how do I define the Key Column and Key Value when there are no columns with values?

[Anonymous · Accepted solution]

I ended up figuring it out myself, the Delete Rows step was unnecessary, instead I configured a Filter Array to eliminate empty rows from my table. 

[Allybartz]

I would love to know how you figured it out and what formula you used.

Thanks!