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.
Thank you for your help!
Hi @Armyrunner
Please try to use ‘PermitName’ not equal to null as filter condition.
PermitName ne '@{null}'(ne means not equal to)
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.