Hide empty cells (columns)

[mavako]

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. 

[v-qiaqi-msft]

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

[mavako]

Hello, I made example to explain in more detail 😉

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

App BrowseScreen: 

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

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:

Regards

Martin

[v-qiaqi-msft · Accepted solution]

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.

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

[mavako]

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

Thank you very much