Power Automate - Using Connectors

Answered

Use the Empty in Filter array

Like (0) Share

Report

Posted on 2 Oct 2019 01:42:17 by ilu989

164

Dear All,

I would like to filter the empty value's item to remain the item"0" that has value, but trial many expression can't achieve, please give me the help, the expression I tried:

empty(outputs('Compose_4')?['0'])

empty(body('Compose_4')?['0'])

empty(items('0'))

empty(item()?['0'])

empty()?['0']

The snapshot from my flow:

The compose 4 content:

[

{

"0": "", →"filter" to avoid the data that the item "0" has empty value

"1": "Update by AB",

"2": "Test01",

"3": "Test10",

"4": "Test11",

"5": "Test12",

"6": "Test13",

"7": "Test15",

"8": "Test10",

"9": "Test15",

"10": "Test11"

{

"0": "title 123",

"1": "Update by AB",

"2": "Test06",

"3": "Test76",

"4": "Test34",

"5": "Test43",

"6": "Test68",

"7": "Test32",

"8": "Test86",

"9": "Test54",

"10": "Test43"

{

"0": "title 246",

"1": "Update by AB",

"2": "Test11",

"3": "Test1",

"4": "Test1",

"5": "Test2",

"6": "Test3",

"7": "Test58",

"8": "Test02",

"9": "Test04",

"10": "Test78"

}

]

I require the result:

[

{

"0": "title 123",

"1": "Update by AB",

"2": "Test06",

"3": "Test76",

"4": "Test34",

"5": "Test43",

"6": "Test68",

"7": "Test32",

"8": "Test86",

"9": "Test54",

"10": "Test43"

{

"0": "title 246",

"1": "Update by AB",

"2": "Test11",

"3": "Test1",

"4": "Test1",

"5": "Test2",

"6": "Test3",

"7": "Test58",

"8": "Test02",

"9": "Test04",

"10": "Test78"

}

]

Regards,

ilu989

I have the same question (0)

All responses (3)

Answers (1)

ilu989 164 on 02 Oct 2019 at 08:38:45

Like (0)

Report

Re: Use the Empty in Filter array

Hi @RezaDorrani @v-alzhan-msft ,

Thanks for your help, it's workable and I found some exception, when the character value has an integer(number), the filter array couldn't recognize, just share what I research, thanks.

[
{
    "0": 1, → Integer can't recognize by filiter array
   "1": "Update by AB",
    "2": "Test06",
    "3": "Test76",
    "4": "Test34",
    "5": "Test43",
    "6": "Test68",
    "7": "Test32",
    "8": "Test86",
    "9": "Test54",
    "10": "Test43"
}
]

Regards,
ilu989

Was this reply helpful? Yes No
v-alzhan-msft on 02 Oct 2019 at 06:51:23

Like (0)

Report
Re: Use the Empty in Filter array

Hi @ilu989 ,

Have you take a try with @RezaDorrani 's solution , the solution is works, you could also refer to screenshot below in the Filter Array action:

@equals(empty(item()?['0']), false)

Please take a try and let me know if your problem could be solved.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Verified answer

RezaDorrani 12,141 on 02 Oct 2019 at 02:29:32

Like (1)

Report

Re: Use the Empty in Filter array

Hi @ilu989

empty(item()?['0']) - expression on left of is equal to
false - expression

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No

Community site session details

Use the Empty in Filter array

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Use the Empty in Filter array

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Telen Wang – Community Spotlight

Congratulations to the July Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates