Answered

Set combo box default item to the current user

Like (0) Share

Report

Posted on 8 Mar 2021 11:14:38 by Community Power Pla...

Hi all,

I have another question. On the home screen of one of my apps the users search for and select themselves so they can record data about what work they're doing throughout the day.

The combo box is a standalone input field, so not part of a form. The items property is: Filter(Office365Users.SearchUser({searchTerm: Self.SearchText}), Department = "Corporate Resources, IBC").

I cannot figure out what piece of code to put in the DefaultSelectedItems property of the combo box.

I think it needs to be something like this(?): Filter(Office365Users.SearchUser({searchTerm: Self.SearchText}), Mail = User().Email).

The screen looks like this:

I have seen lots of posts about doing this using sharepoint as a datasource, but not the O365 Users connector.

Thanks,

Freddie

Categories:

Connecting to Data

All responses (4)

Answers (1)

Community Power Pla... on 08 Mar 2021 at 12:37:08

Like (0)

Report

Re: Set combo box default item to the current user

Thanks. This works perfectly!
Verified answer

Community Power Pla... on 08 Mar 2021 at 12:33:14

Like (3)

Report
Re: Set combo box default item to the current user

You're very close! This will work to default select the current user:

First(Office365Users.SearchUserV2({searchTerm:User().Email}).value)
timl 35,227 Super User 2025 Season 2 on 08 Mar 2021 at 11:54:22

Like (0)

Report
Re: Set combo box default item to the current user

Hi @Anonymous

You might find that just setting the DefaultSelectedItems property to this will work.

[User().Email]
JR-BejeweledOne 5,836 Moderator on 08 Mar 2021 at 11:51:56

Like (0)

Report

Re: Set combo box default item to the current user

You said:

I think it needs to be something like this(?): Filter(Office365Users.SearchUser({searchTerm: Self.SearchText}), Mail = User().Email).

Have you tried this?