Unanswered

How to make a Gallery selectively shows sharepoint columns that are not blank?

(0) Share

Report

Posted on by jdavila8091

State	Car Color	House Color	Flowers	Pets
Florida	red
New York			tulips	cat
Georgia		blue		dog

The table above is a sample of my database. As you can see, not every state has the same subtopics. Sometimes some states have data in them (Ex. Pets column, only Georgia and New York have data in it, the other state(Florida) is blank). My dilemma is, once the user selects a state(for example Florida from a dropdown box), how can I make a gallery to only pull the information from a sharepoint list where the columns are NOT empty, in a way where it displays the column header's name and its content below? am I asking too much from Power Apps ? I can get it to pull everything, but we dont want a bunch of empty results in between.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

TylerPA 201 on at

Like (0)

Report
Copy link

Link copied!
One approach - to spread out in the information horizontally, you collect the information for your selected item as below. Then filter "displayGal" to remove any blank "thisVal" rows. The result is a gallery of titles and values
ClearCollect( displayGal, { title: "State", thisVal: selected gallery items State value... }, { title: "Car Color", thisVal: selected gallery items Car Color value... }, { title: "House Color", thisVal: selected gallery items House Color value... } );

Was this reply helpful? Yes No
jdavila8091 4 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the response TylerPA. Could you give me an example how should i spread out the row and columns with the information provided? It would help me so much to understand it better.

Was this reply helpful? Yes No
TylerPA 201 on at

Like (0)

Report
Copy link

Link copied!
@jdavila8091

yep, no worries - below is setup pulling directly from sharepoint. could also be setup to work on a collection

if this is your sharepoint list

dropdown box Items property

dropdown OnChange
ClearCollect( displayGal, { title: "State", thisVal: First(Filter(testList30Nov, state=Dropdown8.Selected.state)).state }, { title: "Car Color", thisVal: First(Filter(testList30Nov, state=Dropdown8.Selected.state)).carColor }, { title: "House Color", thisVal: First(Filter(testList30Nov, state=Dropdown8.Selected.state)).houseColor }, { title: "Flowers", thisVal: First(Filter(testList30Nov, state=Dropdown8.Selected.state)).flowers }, { title: "Pets", thisVal: First(Filter(testList30Nov, state=Dropdown8.Selected.state)).pets } );

horizontal gallery Items

and labels within the gallery, ThisItem.title, ThisItem.thisVal

Was this reply helpful? Yes No
Putte 2 on at

Like (0)

Report
Copy link

Link copied!

Hi.

Managing the blanks in the gallery is pretty straightforward and here is an example. Just paste the code into the Items property of your gallery control and update the data source and dropdown control:

Filter(Sort(Split(Concat(Filter(yourDatabase,State=yourDropDownControl.Selected.Result),

If(!IsBlank('Car Color'),'Car Color' & ", ","") &
If(!IsBlank('House Color'),'House Color' &", ","") &
If(!IsBlank('Flowers'),'Flowers' &", ","") &
If(!IsBlank('Pets'),'Pets' &", ","")),", ")

,Result,Ascending),!IsBlank(Result))

Fetching the column names in Power App is a little more tricky but here's a way to do it:
Get Collection Column Names - Matthew Devaney

I hope this solves your challenge.

Was this reply helpful? Yes No