I have tried several ways to filter an Excel file and import/update the filtered data into my SharePoint list.
The flow worked before the Excel file grew too large to import. I need to remove the rows not needed in the import.
Notes about the Excel file:
- Has 14k+ rows and is an automated file extracted from another tool therefore it is difficult to manually edit each day for the import into SharePoint.
- File is housed in my SharePoint documents library
- I only need to import the rows that do not equal an "empty" value in the PermitPlannerFIXED column. Only import rows with other values like "Joe", "Bill@test.com", "Mike@test.com", etc. in PermitPlannerFIXED column.
Do not import "empty" column rows. Only others like Joe, Bill@test.com, etc.
The flow: (currently fails)


- The flow currently fails with the error: The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Apply_to_each_3')' is of type 'Object'. The result must be a valid array.
- I have also tried to filter in the List rows present in table query without the Filter array step with no success.
- I am using the Excel column Work Order ID and the SharePoint column WorkOrderID for the condition create or update.
Any help would be appreciated!