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

View solution in original post

mavako
Frequent Visitor

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

Thank you very much

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,016)