Power Platform Community Forum Thread Details

Edit:

I am being asked to populate SharePoint list with data sent to me in an Excel workbook that has a table with identified parameters of A:O, rather that A1:O100.

There is only data in rows A1:O65, the rest of the cell/rows in the table are blank.

This causes several blank rows to appear in my SharePoint list.

I would like to write a filter query in the 'List rows present in a table' of my flow that would prevent the blanks from the workbook from being added to my SharePoint list, how would I accomplish this task?

I have tried Title ne null and Title ne " " in the 'List rows present in a table' action but it doesn't seem to stop the blanks from coming over.

Categories:

Building flows