Unanswered

Create Collection from SharePoint List "Person and Groups" field

(0) Share

Report

Posted on by StuartSmith

225

I have a SP List (Users) with various columns in, one being a "Person or Group" type called "Name". How can I create a collection showing the details, such as "Display Name", "Email" of each person in the SP List?

I have tried many different solutions found on the web and none work.

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

StuartSmith 225 on at

Like (0)

Report

Where are the greatest Power App minds when you need them? 🙂

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (0)

Report

Alternatively, I have a gallery in the app that shows the users found in the SP List called "Users". I thought I would be able to create a collection using the gallery instead, but get the same issue. How can I get the data held in each record into a single collection? The gallery has "Name" and "Role" and if its easier, I could just work with the name field. Could it be converted to text and saved in a gallery?

Thanks in advance

Was this reply helpful? Yes No
Shazza 4 on at

Like (1)

Report

Hey, try adding an AddColumns after Show Columns when creating the collection, then adding new columns specifically for the Display Name or Email, and using those instead. eg:
ClearCollect(colNewCollectionName, ShowColumns(AddColumns(SPListName,"NewColumnDisplayName",SPFieldName.DisplayName),"NewColumnDisplayName"))
then they should be a basic field instead of a record

Was this reply helpful? Yes No