cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tamras
Impactful Individual
Impactful Individual

Default value of combo box

How do I make the combo box's default value to current user?  For instance, the source is a people picker field (SharePoint Online) with below settings:
2019-06-10_1253.png

I added Office365Users as data source, and set the DefaultSelectedItems property - gave an error expected table value

Office365Users.UserProfile(User().Email).DisplayName



1 ACCEPTED SOLUTION

Accepted Solutions
v-monli-msft
Community Support
Community Support

Hi @Tamras ,

 

Actually you do not need to add Office365 Users to set the default value to current user for SharePoint people field. Simply use below formula in the Default property of the dropdown control in people field's data card:

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

And if you want the dropdown still shows the original value when editing an existing item, use below formula instead:

If(Text(EditForm1.Mode)="1",{ 
  DisplayName:User().FullName,
  Claims:"i:0#.f|membership|" & Lower(User().Email), 
  Department:"", 
  Email:User().Email, 
  JobTitle:"", 
  Picture:""
},Parent.Default)

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-monli-msft
Community Support
Community Support

Hi @Tamras ,

 

Actually you do not need to add Office365 Users to set the default value to current user for SharePoint people field. Simply use below formula in the Default property of the dropdown control in people field's data card:

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

And if you want the dropdown still shows the original value when editing an existing item, use below formula instead:

If(Text(EditForm1.Mode)="1",{ 
  DisplayName:User().FullName,
  Claims:"i:0#.f|membership|" & Lower(User().Email), 
  Department:"", 
  Email:User().Email, 
  JobTitle:"", 
  Picture:""
},Parent.Default)

Regards,

Mona

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Tamras
Impactful Individual
Impactful Individual

@v-monli-msft 

  • The first formula worked.  The second formula is giving an error on Parent.Default
  • I also have another screen without any forms, I just inserted a combo box.  How do I make this combo box default value as the current user?  Neither formulas worked when I tried it.
Anonymous
Not applicable

Hi @ ,

 

I have similar issue, but the formula you shared doesn't work for me.

 

I have a Combo Box where I expect only one selection (I set as false the SelectMultiple). For the Items I refer to a Person-Type Column "Host" at my list "VMS invitations". I assume this is not an issue as it works well. But the Default value of the current user I don't get to make it work.

 

I don't know what I am missing.

 

Untitled.png2.png

 
nrvrvl
Helper I
Helper I

How do I make the combo box's default value to multiple users  ?  For instance, the source is a people picker field (SharePoint Online) with below settings:

This did not put the current user in that field.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (3,949)