Default Requestor to logged in user

[tagustin2020]

@RandyHayes 

Hello Randy,

I would like to default a combo box control to the logged in user. I'm going with a combo box approach because there is the possibility that the Shipping Crew members will sometimes enter new requests on behalf of others so I want it to be flexible to change. Everything is working except for writing the user's name back to the SharePoint data source.  No name is written back. I suspect the issue is the Update formula. I tried entering cbPeople.Selected.DisplayName, but it errors out. Can you let me know what I need to do? Thank you, Teresa

Requestor Name Data Card

Default: ThisItem.’Requestor Name’

Update: cbPeople.Selected

Requestor Combo Box Control

Items: Office365Users.SearchUser({searchTerm:cbPeople.SearchText,top:100})

DefaultSelectedItems: Office365Users.SearchUser({searchTerm:User().Email,top:100})

App OnStart: Set(varUser,User())

[zmansuri]

Try this in DefaultSelectedItems of ComboBox:

Filter(Office365Users.SearchUser(),Lower(Mail)=Lower(User().Email))

[RandyHayes · Accepted solution]

@tagustin2020 

Yes, your issue will be in the Update formula.  In your case, you are trying to write a person record from Office 365 to a Person column in SharePoint...they are two different records completely.

Your DefaultSelectedItems property is generally fine except, you are not accounting for the underlying datasource value in your formulas, so while it will be fine that the person logged in will be the one showing as selected...that will ALWAYS be the case, even after some name as been written to the record.

So, the following should be what you have as you need to translate the record schema back and forth and you need to also account for making sure that the Default and Update properties of the Datacard match properly in order for the Unsaved property of your form to continue to function properly:

And one other thing...use the V2 actions on the SearchUser as the actions you are using are deprecated and should be avoided.

Requestor Name Data Card

Default: ThisItem.’Requestor Name’  

Update: cbPeople.Selected

If(cbPeople.Selected.Mail <> ThisItem.'Requestor Name'.Email,
    // If the selected person in the combobox is different than the underlying record, then
    // use a record that is a valid SharePoint person schema record made from the combobox
    { 
      Claims:"i:0#.f|membership|" & Lower(cbPeople.Selected.Mail), 
      Department:"", 
      DisplayName: cbPeople.Selected.DisplayName, 
      Email: cbPeople.Selected.Mail, 
      JobTitle:"", 
      Picture:""
    },
    // If the selected person is the same as the underlying record, then just use that record...
    // ...it is already a record with the proper schema.
    ThisItem.'Requestor Name'
)

Requestor Combo Box Control

Items: Office365Users.SearchUserV2({searchTerm: Self.SearchText, top:100}).value

DefaultSelectedItems: 

Office365Users.SearchUserV2(
    {searchTerm: Coalesce(ThisItem.'Requestor Name'.Email, User().Email)}
).value
// This will return a record that is compatible with the Items property of the combobox...but not a SharePoint person record

I hope this is helpful for you.

[tagustin2020]

@RandyHayes 

@zmansuri 

Thank you Randy! That got me where I needed to go. Z, thank you for your response as well. I hope you both have a nice evening! 

Teresa