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

[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:

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

[gtsmith]

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,

[v-xida-msft · Accepted solution]

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

[gtsmith]

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

Thanks again.