Answered

Gallery Not Displaying Any Information

(0) Share

Report

Posted on by JacksonG

I am trying to display the data from a SP multi-choice people column in a gallery, but PowerApps displays nothing, despite there being data in the column.

Concat(ThisItem.AssignedEmployee, DisplayName, "; ")
This is the formula that I am using. There are no errors, it just returns blank.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@JacksonG - nothing wrong with your formula, so there must be something else.

I assume your applying that formula to the Text property of a Label control?

Is your Gallery displaying other records?

Was this reply helpful? Yes No
JacksonG 40 on at

Like
a
(0)

Report
Copy link

Link copied!

1. Yes, it is.
2. No, the gallery is only displaying this information, nothing else.

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@JacksonG - in that case, I would expect the Items property of the Gallery control to contain something along the lines of:

Choices([@'Your List'].'Your Multi Choice People Field')

And the Text property of the Label to include any of the attributes contained in a People type column, e.g:

ThisItem.DisplayName

Was this reply helpful? Yes No
JacksonG 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, that works!
I am also trying to filter this information based on the selected value of another gallery. Is that something that is possible?

Was this reply helpful? Yes No
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@JacksonG - please remember to accept the solution to the original question.

Regarding the second question, yes it is possible so long as there is a matching value. A People Type column returns a table which contains the following columns/attributes:

Claims

Department

DisplayName

Email

JobTitle

Picture

Was this reply helpful? Yes No