Answered

Set ComboBox Default to Current User and Save in Sharepoint List Person column.

Like (0) Share

Report

Posted on 3 Oct 2019 20:55:38 by Community Power Pla...

I have a Sharepoint List with a Person column that accepts multiple people. In my PowerApp I have a Combobox tied to this column that also accepts multiple people. I have not been able to figure out how to set the default for the Combobox to the current user for a new record. Any help with this would be appreciated. Thanks.

Categories:

General Questions

All responses (5)

Answers (2)

Verified answer

RezaDorrani 12,141 on 03 Oct 2019 at 21:20:59

Like (5)

Report

Re: Set ComboBox Default to Current User and Save in Sharepoint List Person column.

Hi @Anonymous ,

Set the default property of the data card to

If(FormName.Mode= FormMode.New ,Table({
DisplayName: User().FullName,
Claims: "i:0#.f|membership|" & User().Email
}),ThisItem.PPFieldName)

where FormName = name of your form
PPFieldName = column name in SP

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Verified answer

Community Power Pla... on 10 Oct 2019 at 13:28:28

Like (2)

Report

Re: Set ComboBox Default to Current User and Save in Sharepoint List Person column.

Even though I am not using "Forms", I was able to use the red code below from your suggestion. Thanks!

If(lvarStatus="New",
    Table({DisplayName:User().FullName,
    Claims:"i:0#.f|membership|" & User().Email}),
    RFQAGallery.Selected.SendEmails)