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