cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Modifying a Data Table & the Edit Form (Sharepoint List)

Hey guys,

 

I'm currently working on a PowerApp where I have a sharepoint list with 120 collumns. It is a product list and displays the various characteristics of all our products. Please note that each product has 8 characteristics, so not all of the collumns are complete for each product and there are a lot of empty rows. Now I would like to add a data table to my PowerApp that just shows me the collumns with entries. I have absolutely no clue how to solve this issue and really hope that you can help me out with this. 

 

We also have the same issue with the following edit form, where we just wanna see the data cards that actually hold a data value. So if you know what kind of function we need for this, any tip or hint is appreciated. 

 

Cheers,

Linda

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Modifying a Data Table & the Edit Form (Sharepoint List)

Hey LRVinNC,

 

many many thanks for your help!!! We tried your function, but it didn't fulfilled the purpose that we are thriving for. 

But we found a solution for the Edit Form! To hide the empty boxes we used: 

 

If(IsBlank(<Name of the Data Table Column>);false; true)

 

 

 

View solution in original post

2 REPLIES 2
Super User
Super User

Re: Modifying a Data Table & the Edit Form (Sharepoint List)

You need to use a Filter to limit the rows returned to only those with the data you want to display.  Two resources that will be useful in learning about filters are:  https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup and this video by @Shanescows https://www.youtube.com/watch?v=nlhWQg03TL0.

 

Here's an example of a filter for a sharepoint list that eliminates rows where a specific column is blank:

Filter(<SharepointListName>, Not(IsBlank(<ColumnContainingBlanksName>.Value)) 

If you need multiple critieria, connect them with && (And) or || (Or):

Filter(<SharepointListName>, Not(IsBlank(<FirstColumnContainingBlanksName>) && 
Not(IsBlank(<SecondColumnContainingBlanksName>.Value)) 

This statment will go into the Items Property of the gallery or data table, depending on which you are using.

Anonymous
Not applicable

Re: Modifying a Data Table & the Edit Form (Sharepoint List)

Hey LRVinNC,

 

many many thanks for your help!!! We tried your function, but it didn't fulfilled the purpose that we are thriving for. 

But we found a solution for the Edit Form! To hide the empty boxes we used: 

 

If(IsBlank(<Name of the Data Table Column>);false; true)

 

 

 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,548)