Get items Where Cell is Blank

(0) Share

Report

Posted on by IPC_ahaas

1,374 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.

I have the same question (0)

All responses (5)

Answers (1)

IPC_ahaas 1,374 Moderator on at

Like (0)

Report

Re: Get items Where Cell is Blank

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?

Was this reply helpful? Yes No
IPC_ahaas 1,374 Moderator on at

Like (0)

Report

Re: Get items Where Cell is Blank

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)

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft on at

Like (1)

Report
Re: Get items Where Cell is Blank

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

Was this reply helpful? Yes No
JasonLane 261 on at

Like (0)

Report

Re: Get items Where Cell is Blank

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

Was this reply helpful? Yes No
IPC_ahaas 1,374 Moderator on at

Like (0)

Report

Re: Get items Where Cell is Blank

@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.

Was this reply helpful? Yes No