web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Autofill

Power Apps

Answered

Autofill

(0) Share

Report

Report

Posted on by Canadiansal

310

I have a SharePoint list with a Person Column.

I would like that when the users open this in the edit form, the value is automatically changed to the user email address.

The current code is

Choices([@'Datasource'].ColumnName)

I tried changing it to User(). Email, but get the following error:

"Expected Table Value".

Any insight would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Canadiansal

Change the Default (if Dropdown, DefautlSelectedItems if a combobox) to the following Formula:

{ '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser", Claims:"i:0#.f|membership|" & Lower(User().Email), Department:"", DisplayName:User().Email, Email:User().Email, JobTitle:".", Picture:"." }

I hope this is helpful for you.

Was this reply helpful? Yes No

Join the conversation