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 flow
I appreciate the assistance anyone can give me.