Answered

@empty condition not working properly after 'Get Items' action

(0) Share

Report

Posted on by gtsmith

I have a flow that is set to trigger on a monthly basis to check for empty fields in a particular column. The '@empty' function works perfectly well if I use a simple 'When a new item is created' trigger, but it does not work on an existing list where I have to use the 'Get Items' trigger:

@empty.JPG

The condition simply returns true for each item, even if that item has data. I know the '@empty' syntax is correct because it works when I use the 'When a new item is created' trigger instead.

Any ideas? I'm stumped!

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

gtsmith 18 on at

Like (0)

Report
Copy link

Link copied!

I came up with a clever workaround for now. I created a column labeled 'ThisFieldToRemainBlank' and changed my condition from '@empty' to if 'Dec Update' is equal to 'ThisFieldToRemainBlank'. The workaround works for now (as long as no one enters data into my 'ThisFieldToRemainBlank' column) but I'd like to know if anyone has a proper solution to the issue.

Thanks,

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @gtsmith,

Could you please share a bit more about the data structure of your SharePoint list?

Which type is the Dec Update column in your SharePoint list?

I think there is something wrong with the formula in your Condition box. I have made a test on my side and the flow works well. My flow’s configuration as below:

Within Condition box, click “Edit in advanced mode”, type the following formula:

@empty(items('Apply_to_each')?['Dec_x0020_Update'])

The flow works successfully as below:

Please consider take a try to change your formula within Condition box to above formula that I provided and check if the issue is solved.

Best regards,

Kris

Was this reply helpful? Yes No
gtsmith 18 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much, Kris - your modified formula is exactly what I was looking for. It worked fine on my end too.

Thanks again.

Was this reply helpful? Yes No