web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Filter Query (Not Null)

Power Automate

Answered

Filter Query (Not Null)

(0) Share

Report

Report

Posted on by RJF61

1,265

I am trying to create a Flow that exports information to an Excel spreadsheet. In the filter query of the Get Items, I was trying to eliminate WONo = Null (or only select records with a value). I have tried the ne Null but with no success. How should I modify the query?

[

{

"WONo": "9001306211"

},

{

"WONo": null

},

{

"WONo": null

},

{

"WONo": null

},

{

"WONo": "9001296960"

},

{

"WONo": null

},

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Rhiassuring 8,692 Moderator on at

Like (1)

Report
Copy link

Link copied!

I'll show you both ways...

In a Filter Query in your Excel action:

"null" has to be entered as an expression - even though you just type it in and select it and click OK.

Your Excel column needs to have no spaces in it.

In a Filter Array action:

Same thing with the null.

the item() formula looks like this: item()?['WOno']

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @RJF61,

Do you use Filter Query in Get Items action?

If so, I think you should modify the formula as below:

WONo ne null

Was this reply helpful? Yes No

Join the conversation