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
Solved! Go to 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
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,
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
Thank you very much, Kris - your modified formula is exactly what I was looking for. It worked fine on my end too.
Thanks again.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
27 | |
26 | |
23 | |
14 | |
10 |
User | Count |
---|---|
62 | |
51 | |
29 | |
28 | |
24 |