Skip to main content

Notifications

Power Automate - Using Flows
Answered

Trouble filtering and importing Excel data into SharePoint list

(0) ShareShare
ReportReport
Posted on by 28

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!

 

 

  • Verified answer
    v-liwei-msft Profile Picture
    v-liwei-msft on at
    Re: Trouble filtering and importing Excel data into SharePoint list

    Hi @Armyrunner 

     

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

    vliweimsft_0-1667551678632.png

     

    Best Regards,

    Levi

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics

Restore a deleted flow