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

Notifications

Announcements

Community site session details

Community site session details

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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard