Unanswered

Hide empty cells (columns)

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

v-qiaqi@microsoft.com on at

Like (0)

Report
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

Was this reply helpful? Yes No
mavako 15 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
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

Was this reply helpful? Yes No
mavako 15 on at

Like (0)

Report

Great, It works now. I did something wrong previously.
Thank you very much

Was this reply helpful? Yes No