web

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

News and Announcements icon

Power Platform CommunityForums Power Automate Get items Where Cell i...

Power Automate

Answered

Get items Where Cell is Blank

(0) Share

Report

Report

Posted on by IPC_ahaas

1,401 Moderator

This is driving me nuts. Sunday = 2022-09-25 and Saturday = 2022-10-01

Today is 2022-09-30, so this should return all three items in this picture:

Instead, I get nothing. I tried putting 'null' and got the same result.

{"body":{"value":[]}}

If I remove "ItemChosen" from the Filter, it returns the three values.

Categories:

All responses Img

All responses (5)

Answers Img

Answers (1)

Sort by

IPC_ahaas 1,401 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

So I partially figured this out. Looking at the output JSON with and without the "ItemChosen". If the item doesn't have an "ItemChosen" specified, it's literally missing from the JSON. What madness is this?
IPC_ahaas 1,401 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I found this other thread, but not sure how to apply it here.

Solved: Blank Sharepoint columns no longer returning - Power Platform Community (microsoft.com)
Verified answer

v-yujincui-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @IPC_ahaas ,

I assume the ItemChosen column is a Choice column.

Maybe you could try as below.

coalesce(item()?['ColumnName/Value'], 'blank')

Result Screenshot:

Best Regards,

Charlie Choi
JasonLane 261 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
This article seems to help
https://powerusers.microsoft.com/t5/Building-Flows/parse-JSON-Ignoring-null-value-s-when-parsing-JSON-payload/td-p/31999
Thanks
IPC_ahaas 1,401 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@v-yujincui-msft it is not a Choice column, just text. Looks like that worked!

@JasonLane I'm not sure how that article helps. This is regarding values returned as null. In my case, if the value is null it's not returned at all.

Join the conversation