Filter Query issue: list rows present in a table

[RobinV86]

My table has several empty rows. I want my flow to ignore those. The excel column I'm testing on is called Project Reference. 

I have typed the following filters:

Project_x0020_Reference NOT ISNULL

Project_x0020_Reference NOT NULL

Project_x0020_Reference NOT ''

Project_x0020_Reference NOT [null from the expressions tab]. 

All of these return an error. What am I doing wrong?

[Brad_Groux]

You have a few options, a Filter Query or a Filter Array. If you could provide an expanded screenshot of your Flow and steps, and of any detailed error messages you're receiving we could likely better assist you.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[v-bacao-msft · Accepted solution]

Hi @RobinV86 ,

Currently, we cannot use Filter query in Excel table to filter out empty rows with the specified field value.

You could use Filter array or Condition to filter out non-empty rows. Don't need to configure the parameters on the right.

Image reference:

Best Regards,

[RobinV86]

Thank you for your help. I have added the filter array.

My next step was an apply to each. This was set to take the value output from excel. This has to be changed to the Body output created by the filter. 

Problem solved!

[hikmatune1]

Project_x0020_Reference ne '' (two single quotes no space between)

[hikmatune1]

Yes, it is possible

Project_x0020_Reference ne '' (two single quotes no space between)

[Anonymous]

Hi, I'm trying to use a similar flow to this to grab any rows from a pre-existing table that includes the search query from the filter array 'Is Equal To' but the resulting adds rows into a table but adds them in the output 'gobble-de-**bleep**- format, not in the table format.

"Studio": "{\"@odata.etag\":\"\",\"ItemInternalId\":\"12c25164-9ccd-48eb-9998-afe79cda9e36\",\"Studio\":\"C4\",\"Studio & Test\":\"C4 Testing\"}"

When all I want it to do is lookup using Studio and return only based on the Filter Array query.

I can't upload images of my flow due to work IT restrictions.

[Yi66]

I always got 404 status error, do you know why?