cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
manojrohit16
Helper I
Helper I

Choice Column show blank Values

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

2 REPLIES 2
NandiniBhagya20
Solution Sage
Solution Sage

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())


Did you like my post? Please give it a thumbs up! Did I resolve your issue? Please click Accept as Solution to close the topic and so other members of the community can find solutions more easily.

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,690)