web

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

News and Announcements icon

Power Platform CommunityForums Power Automate ODATA query | Row does...

Power Automate

Answered

ODATA query | Row does not have data

(0) Share

Report

Report

Posted on by Md_Fazlul_Karim

27

Hello Power Automate experts,

Can you please let me know how can I write a ODATA query which will filter out the row if there is no data.

For Example, I have a date column 'RentalEndPeriod', where I would like to filter out the the rows that are empty.

Although my PowerAutomate is doing what is supposed to do I see an 'Failed' message as some of the rows are empty which causes this error.

I do not wish to use the compose to filter as I want to reduce the work load of the Automate. I will only consider this if I know this is the only solution.

Thank you.

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

CU-18081211-6 9,270 Moderator on at

Like (1)

Report
Copy link

Link copied!
@Md_Fazlul_Karim ,

If you want to receive records with values, use:

RentalEndPeriod ne null

or if you want to receive records with RentalEndPeriod null, use:

RentalEndPeriod eq null

Do not write null using the add dynamic content -> expressions.

Hope it helps !

Was this reply helpful? Yes No
Md_Fazlul_Karim 27 on at

Like (0)

Report
Copy link

Link copied!

@gabibalaban You magnificent person, this worked!

Was this reply helpful? Yes No

Join the conversation