Power Platform Community Forum Thread Details

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!

Categories: