Choice Column show blank Values

[manojrohit16]

Hello there,

I have query where I get 4 column data into one row means in Choice column by below query where I'm also getting blank values and I don't want blank value into row so let me know how to avoid blank value.

Ungroup(
Table(
{Value: Blank()},
{Value: With({wItem:LookUp(SharePoint List Name,Lookup.Value="5" && column=DataCardValue14.Text)},Table(
{Value:wItem.Email},{Value:wItem.Email2},{Value:wItem.Email3},{Value:wItem.Email4}))}
),
"Value"
)

How to avoid blank Values from the above query?

Regards,

Manoj Roy

[NandiniBhagya20]

Hi @manojrohit16 ,

I know how to remove blank value from a collection. Please refer below sample code:
ClearCollect(sampleCollect, {Value: Blank()}, {Value: "A"}, {Value:"B"}, {Value:"C"}); RemoveIf(sampleCollection, Value=Blank())

[manojrohit16]

I have edited the question and I filter query from SharePoint list directly without using collection.