cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mavako
Frequent Visitor

Hide empty cells (columns)

Hello, I have data in google excel sheet.. Each item (row) has filled different columns and I would to show only filled columns for each item.

If cell in column is filled everythink is OK. But if some cells are empty, I would to hide this row in app.

Vissible in attached picture - OK data in green circle, data to hide in red circle if there is empty cell in column. 

hide.jpg

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @mavako,

Have you ever tried the solution I provided?

I thought that you want to hide the whole data card in the Display Form. The solution I provided does hide the DataCardKey as well because I set the Visible property of the Data card rather than the control within it.

Please check the screenshot as below, you could see that the whole data card is invisible.

v-qiaqi-msft_1-1619597128431.png

Therefore, on your side, please select the ADDITIONAL data card and set the Visible property as:

If(!IsBlank(ThisItem.ADDITIONAL), true , false )

Check if it could solve your probelm.

Regards,

Qi

Best Regards,
Qi

View solution in original post

4 REPLIES 4
v-qiaqi-msft
Community Support
Community Support

Hi @mavako,

Based on the issue that you mentioned,do you want to hide the data card if there is some empty field in a record?

Could you please share a bit more about the scenario, is this a Display Form in your app?

If so, I think you should set the Visible property of each data card.

Firstly, you should check if the current field in the record is empty, if it is, then the data card will be invisible.

Not sure the column type of you each field, I just list an example as below.

Assume that you have a Text field, please set the Visible property of the data card as below

If(!IsBlank(ThisItem.TextField),true,false)

If you have other column types like Choice or Person, Date and time, you should modify the formula as below:

If(!IsBlank(ThisItem.ChoiceField),true,false) // For Choice type
If(!IsBlank(ThisItem.PersonField),true,false) //For Person type
If(!IsBlank(ThisItem.DateField),true,false) //For Date and time type

Hope it could help you.

Regards,

Qi

Best Regards,
Qi
mavako
Frequent Visitor

Hello, I made example to explain in more detail 😉

 

Input data - in column D (ADDITIONAL) are some cells empty

data.jpg

 

App BrowseScreen: 

browser screen.jpg

App DetailScreen with all cells filled is OK as I want:

detail OK.jpg

App DetailScreen with empty cell - DataCardValue (empty cell in column D) is hidden, but I would to hide DataCardKey (text ADDITIONAL) as well. I means to hide complete ADDITIONAL_Data_Card:

detail NOK.jpgdatacard.jpg

 

Regards

Martin

Hi @mavako,

Have you ever tried the solution I provided?

I thought that you want to hide the whole data card in the Display Form. The solution I provided does hide the DataCardKey as well because I set the Visible property of the Data card rather than the control within it.

Please check the screenshot as below, you could see that the whole data card is invisible.

v-qiaqi-msft_1-1619597128431.png

Therefore, on your side, please select the ADDITIONAL data card and set the Visible property as:

If(!IsBlank(ThisItem.ADDITIONAL), true , false )

Check if it could solve your probelm.

Regards,

Qi

Best Regards,
Qi
mavako
Frequent Visitor

Great, It works now. I did something wrong previously.

Thank you very much

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (2,956)