Answered

Filter Query issue: list rows present in a table

Like (0) Share

Report

Posted on 17 May 2019 04:55:01 by 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?

I have the same question (0)

All responses (10)

Answers (1)

Thenerdy 58 on 25 Apr 2023 at 17:19:41

Like (0)

Report

Re: Filter Query issue: list rows present in a table

Doesn't seem to work - I get the following error:

Invalid filter clause: cannot find the 'Player_x0020_ID' column

The formula used -
Player_x0020_ID ne ''

Was this reply helpful? Yes No
RajkumarS 4 on 06 Mar 2023 at 11:54:13

Like (0)

Report

Re: Filter Query issue: list rows present in a table

Step 1 : Replace the Header with "Run Script(Excel Online)" refer the code snippet below
Step 2 : use the renamed column in filter/select query

function main(workbook: ExcelScript.Workbook) {

let HeaderCell1 = workbook.getActiveWorksheet().getRange("A1");
let HeaderCell2 = workbook.getActiveWorksheet().getRange("B1");

HeaderCell1.setValue("NewColumnName1");
HeaderCell2.setValue("NewColumnName2");
}

Was this reply helpful? Yes No
zachary4828 3 on 08 Feb 2023 at 15:27:55

Like (0)

Report

Re: Filter Query issue: list rows present in a table

This is the solution I was looking for and it worked. Thank you!

Was this reply helpful? Yes No
Yi66 58 on 27 Jul 2022 at 14:41:03

Like (0)

Report

Re: Filter Query issue: list rows present in a table

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

Was this reply helpful? Yes No
Community Power Pla... on 30 Nov 2020 at 14:36:28

Like (0)

Report

Re: Filter Query issue: list rows present in a table

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.

Was this reply helpful? Yes No
hikmatune1 35 on 04 Nov 2020 at 22:19:19

Like (1)

Report

Re: Filter Query issue: list rows present in a table

Yes, it is possible
Project_x0020_Reference ne '' (two single quotes no space between)

Was this reply helpful? Yes No
hikmatune1 35 on 04 Nov 2020 at 21:31:50

Like (4)

Report

Re: Filter Query issue: list rows present in a table

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

Was this reply helpful? Yes No
RobinV86 45 on 20 May 2019 at 01:39:38

Like (0)

Report

Re: Filter Query issue: list rows present in a table

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!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on 17 May 2019 at 06:56:00

Like (0)

Report

Re: Filter Query issue: list rows present in a table

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,

Was this reply helpful? Yes No
Brad_Groux 4,556 on 17 May 2019 at 05:12:07

Like (0)

Report

Re: Filter Query issue: list rows present in a table

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!

Was this reply helpful? Yes No