Answered

Issue with DisplayName table in collection.

(0) Share

Report

Posted on by SmoothOperator

Hello beautiful Community.

I have a SharePoint List called "Meetings". There, I have a column (person/people type) called "PeopleInvolved".
I am trying to collect (collection Name: "Expected" the PeopleInvolved column per DisplayName in order to implement a text field that can be used as search.
However, all I am getting is a table, in which in no way possible I can split, display, edit or anything.
The expected here is to be able to search via a text box, one or more display names that participated in the meeting.
And then, in my gallery, if you type either "James" or "Johnson" or "Doe" or "User" it should bring you this meeting (ID of the meeting is "2").
Any help, will be super appreciated!

Here is a screenshot below:

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@SmoothOperator

Since you seem to be aimed at using the display name for search and it appears that your Person column is a multi-person column, I would suggest the following:

Let's say you have a TextInput control named txtSearchName.

Set the Gallery Items property to the following:

DropColumns( Search( AddColumns(Meetings, "searchColumn", Concat(PeopleInvolved, DisplayName & ";") ), txtSearchName.Text, "searchColumn" ), "searchColumn" )

This should filter your Gallery as desired. No collections needed.

I hope this is helpful for you.

Was this reply helpful? Yes No
SmoothOperator 48 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much @RandyHayes ! 😁

Was this reply helpful? Yes No