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
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())
I have edited the question and I filter query from SharePoint list directly without using collection.