web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Only import rows not n...
Power Automate
Answered

Only import rows not null in column from Excel into SharePoint List

(0) ShareShare
ReportReport
Posted on by 28

Hello

 

I hope someone can help. I have attempted to resolve this myself with no luck.

 

I currently have an Excel file that is successfully being imported using a flow into my SharePoint List. My challenge is that I do not want to import all the 4000+ rows in the Excel table into my list. I only want to import the rows with that are NOT null in the 'PermitName' column. The 'PermitName' column is a Single line of text field in SharePoint. If I am able to so this, I can drastically reduce my import to about 200 rows.   

 

I have tried to use the List rows present in a table Filter Query with no luck. 

 

My flow currently looks like this:

Current working flowCurrent working flow

 

I appreciate the assistance anyone can give me. 

Categories:
I have the same question (0)
  • Verified answer
    v-LilyW-msft Profile Picture
    Microsoft Employee on at

    Hi @Armyrunner 

    Please try to use ‘PermitName’ not equal to null as filter condition.

    PermitName ne '@{null}'(ne means not equal to)

    vLilyWmsft_0-1645151008265.png

    Hope the content above may help you.

    Best Regards

    If my reply helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Armyrunner Profile Picture
    28 on at

    Thank you for your help!

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 293

#2
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 223 Most Valuable Professional

Last 30 days Overall leaderboard