Answered

Collect User Email into SharePoint 'Person or Group' record

(1) Share

Report

Posted on by JimmyJams

This seems like it should be easy, but I'm stumped. I'd like to take something like the User( ).Email function and collect that into a new record of a SharePoint list. That record is the 'Person or Group' data type and is expecting a 'record' data type. User( ).Email is text so that doesn't do.

Closest I got to it is this:

Collect(SPList, {Email: User( )})

User( ) is a record, but clearly not what SharePoint is expecting because it fails to collect anything:

Collect works for all my other fields so I know it's at least passing information along. Anyone deal with this?

I have been able to make a form and collect from a form field, but I'm trying to avoid making users unnecessarily have to fill out and select their email.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@JimmyJams

Instead of

@JimmyJams wrote:
Collect(SPList, {Email: User( )} )

Try

Collect(SPList, {Email: User().Email})

See if it works.

Was this reply helpful? Yes No
JimmyJams 70 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply @poweractivate! Unfortunately it does not.

User( ).Email is a text datatype. An SP List item of 'Person or Group' seems to want a record data type:

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@JimmyJams

Change your formula to:

With(User(), Collect(SPList, {Email: { Claims:"i:0#.f|membership|" & Lower(Email), Department:"", DisplayName: FullName, Email: Email, JobTitle: "", Picture: "" } } ) )

This will create a new record with the following assumptions:

1) There are NO required columns in your list

2) The Email column in your list is the real name of the column and it is a Person type column.

I hope this is helpful for you.

Was this reply helpful? Yes No