cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Armyrunner
Helper I
Helper I

Trouble filtering and importing Excel data into SharePoint list

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:

  1. 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. 
  2. File is housed in my SharePoint documents library
  3. 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.Do not import "empty" column rows. Only others like Joe, Bill@test.com, etc.

The flow: (currently fails)

Untitled1.png

 Untitled2.png

 

  • 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!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-liwei-msft
Community Support
Community Support

Hi @Armyrunner 

 

Based on your screenshot, I suggest you to modify your flow to:

vliweimsft_0-1667551678632.png

 

Best Regards,

Levi

 

View solution in original post

1 REPLY 1
v-liwei-msft
Community Support
Community Support

Hi @Armyrunner 

 

Based on your screenshot, I suggest you to modify your flow to:

vliweimsft_0-1667551678632.png

 

Best Regards,

Levi

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,594)