cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
the_colbs
Level: Powered On

Gallery Displaying multiple columns

Hello PowerApps community,

 

I'm working on building an interface for users to edit the tasks (i.e "cards") assigned to them. Because of some business limitations, the sharepoint list where these "cards" are assigned has to be oriented as one column per card  as pictured below. PowerApps list example.png

 

What I would like to do is use a browse gallery so that the user using the app sees all of their assigned cards . I can create a browse gallery and filter it so the email matches the user with

Filter('SharePoint List Name', Email = User().Email)

however that will only show one item, and the values of that gallery item are not the cards. Does anyone know if PowerApps supports selecting multiple columns in one gallery?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Gallery Displaying multiple columns

Hi @the_colbs ,

Do you want to display individual Cards as multiple items within the Gallery rather than display multiple cards within single one Gallery Item?

 

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the Gallery to following formula:

Filter(
Split(
Concat(
Filter('SharePoint List Name', Email = User().Email),
If(!IsBlank('Card 1'), 'Card 1', Blank()) & "," &
If(!IsBlank('Card 2'), 'Card 2', Blank()) & "," &
If(!IsBlank('Card 3'), 'Card 3', Blank()) & "," &
If(!IsBlank('Card 4'), 'Card 4', Blank()) & "," &
If(!IsBlank('Card 5'), 'Card 5', Blank()) & "," &
If(!IsBlank('Card 6'), 'Card 6', Blank()) & "," &
If(!IsBlank('Card 7'), 'Card 7', Blank()) & ","
),
","
),
!IsBlank(Result)
)

Then within your Gallery, add single one Label, set the Text property to following:

ThisItem.Result

Please take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 REPLIES 8
Super User
Super User

Re: Gallery Displaying multiple columns

Hi @the_colbs 

The Filter syntax should return rows that match the email address of the current user and as such, the Gallery control should be able to access all the 'card' columns.

image.png

When you click the Fields > Edit link, do you see the option to select your additional card columns?

the_colbs
Level: Powered On

Re: Gallery Displaying multiple columns

@timl ,

 

Actually I don't, this might be part of the problem. Below is an image of what the data screen looks like for me. There is no space to add or modify items.

PowerApps data screen.png

 

Also just for clarity, the objective is to display 4 items in the gallery for users with 4 cards, 2 items for users with two cards, etc. 

Super User
Super User

Re: Gallery Displaying multiple columns

Hi @the_colbs 

If you use the Insert > Text menu item to insert a label into the first row in gallery control, a new item should appear and hopefully, you can set this to one of your other card columns.

image.png

the_colbs
Level: Powered On

Re: Gallery Displaying multiple columns

@timl 

 

This technically works, however I was hoping to have unique objects appear in the browse gallery instead of one browse gallery object showing many different labels. Do you know if this is supported in PowerApps Otherwise I have to rely on large amounts of conditional logic.

Thanks so much for your help

Community Support Team
Community Support Team

Re: Gallery Displaying multiple columns

Hi @the_colbs ,

Do you want to display individual Cards as multiple items within the Gallery rather than display multiple cards within single one Gallery Item?

 

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the Gallery to following formula:

Filter(
Split(
Concat(
Filter('SharePoint List Name', Email = User().Email),
If(!IsBlank('Card 1'), 'Card 1', Blank()) & "," &
If(!IsBlank('Card 2'), 'Card 2', Blank()) & "," &
If(!IsBlank('Card 3'), 'Card 3', Blank()) & "," &
If(!IsBlank('Card 4'), 'Card 4', Blank()) & "," &
If(!IsBlank('Card 5'), 'Card 5', Blank()) & "," &
If(!IsBlank('Card 6'), 'Card 6', Blank()) & "," &
If(!IsBlank('Card 7'), 'Card 7', Blank()) & ","
),
","
),
!IsBlank(Result)
)

Then within your Gallery, add single one Label, set the Text property to following:

ThisItem.Result

Please take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: Gallery Displaying multiple columns

Hi @the_colbs 

If you want to transpose your columns into rows, @v-xida-msfts's solution should do the trick for you. I'd give that a go and see how you get on.

Good luck.

Community Support Team
Community Support Team

Re: Gallery Displaying multiple columns

Hi @the_colbs ,

Have you taken a try with the solution I provided above?

 

Based on the needs that you mentioned, I think the solution I provided above could achieve your needs, please take a try with it, check if the issue is fixed.

 

If the issue is solved, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
the_colbs
Level: Powered On

Re: Gallery Displaying multiple columns

@v-xida-msft 

Yes those functions together allows items to appear as if it were column oriented. 

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Top Community Contributors for September  2019

Top Community Contributors for September 2019 🎉🎉

Let's thank our top community contributors

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 400 members 5,286 guests
Please welcome our newest community members: