Filtering a Single Item JSON Array

[dougydoe]

Hello Community,

I'm hoping someone can point me in the right direction on something I want my flow to achieve

At this point in my flow, some of the variables in the JSON (please see image below) will contain data and some will not. 

How do I filter out those that contain data? I'll the use HTML Tables Action to send the filtered items to recipients via email, which I think I have a handle on.

I've tried using the SELECT and FILTER ARRAY Actions but struggling to find a way round since it's only a Single Item Array. I just keep getting everything back. 

[v-bofeng-msft]

Hi @dougydoe :

I am afraid that there is no Action or Function that can directly filter the elements in an Object.

I suggest you use equals(value,null) to determine whether each element is empty one by one.I've made a test for your reference:

The Result

Best Regards,

Bof

[dougydoe · Accepted solution]

Hi @v-bofeng-msft, Thank you for your response. Your answer confirmed my suspicions that there might not be an OTB Action to do what I was looking for. I really appreciate your effort in putting together this custom expression which looks like the way forward. I'll implement this as it looks like it will work for me.