web

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

News and Announcements icon

Power Platform CommunityForums Power Automate ODATA Filter Query - "...

Power Automate

Answered

ODATA Filter Query - "fielddata eq null" not working

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I've been doomscrolling through various forums to figure out what's going wrong here, but I can't figure out where.

I'm trying to filter so that I only get the rows returned in column 'datestamp' that are empty, see below:

Question for PowerAutomate.PNG With OData filter this should be something like 'datestamp eq null' but it keeps throwing an error.

Thanks for looking into this.

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Verified answer

MarvinBangert 1,924 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hey @Anonymous
did you try this formula?
datestamp eq ''
Does this help you? Otherwise please give me some more information.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Blog: Cloudkumpel

Was this reply helpful? Yes No
v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Have you tried using the formula provided by @MarvinBangert ?

If your problem have been solved by @MarvinBangert 's solution, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @MarvinBangert,

Thanks, worked wonders!

Have a nice day!

Was this reply helpful? Yes No
RustyPole 6 on at

Like (0)

Report
Copy link

Link copied!

Hi Marvin,

How do I create the formula when the column name has a space between two words?

For example: `Serial Number eq null`. I have an Excel file with a table that includes a column named `Serial Number`. I need to filter and return all cells in this column that are empty.

Many thanks,

Russ

Was this reply helpful? Yes No

Join the conversation