Answered

Gallery Displaying multiple columns

(0) Share

Report

Posted on by the_colbs

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

timl 36,393 Super User 2025 Season 2 on at

Like (0)

Report

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.

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

Was this reply helpful? Yes No
the_colbs 22 on at

Like (0)

Report

@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.

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.

Was this reply helpful? Yes No
timl 36,393 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
the_colbs 22 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
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,

Was this reply helpful? Yes No
timl 36,393 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-xida-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No
the_colbs 22 on at

Like (0)

Report

@v-xida-msft
Yes those functions together allows items to appear as if it were column oriented.

Was this reply helpful? Yes No