Unanswered

Create Collection from SharePoint List "Person and Groups" field

(0) Share

Report

Posted on by StuartSmith

207

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:

General Questions

All responses (3)

Answers (0)

Shazza 4 on at

Like (1)

Report

Re: Create Collection from SharePoint List "Person and Groups" field

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
StuartSmith 207 on at

Like (0)

Report

Re: Create Collection from SharePoint List "Person and Groups" field

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
StuartSmith 207 on at

Like (0)

Report

Re: Create Collection from SharePoint List "Person and Groups" field

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