Office365Users.SearchUserV2 to lookup in ComboBox and update a SharePoint List "person field"

[sppt]

Hello Power Apps community and gurus,

I have the following dilemma in my use case:

I have a ComboBox in a form (Modern Controls) called DataCard1 with DataCardValue1, which is pre-populated from a SharePoint list (in Edit Mode). Therefore, DefaultSelectedItems is set to ThisItem.'Manager' (in my case, using the variable "varItem.'Manager/Supervisor'"). As you can see, it's a person field where I get the DisplayName from SharePoint.

So far, so good.

Now, I want to create the possibility for these persons to be "pre-populated" via Office365Users.SearchUserV2, meaning that the user can search for such supervisors/managers. Everything works fine up to this point.

My problem starts as soon as one really "searches" - so not just selecting from the dropdown - because then the value always reverts back to the one that's already in the SharePoint list.

DataCardValue1 / Items:

Sort(
    Filter(
        Office365Users.SearchUserV2(
            {
                searchTerm: Trim(Self.SearchText),
                isSearchTermRequired: false
            }
        ).value,
        AccountEnabled = true,
    DisplayName
)

In the Update field of DataCard1, it says the following:

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

What am I missing? What should I probably enter into DefaultSelectedItems insted of varItem.'Manager/Supervisor'

[v-qiaqi-msft]

Hi @sppt,

Try into DefaultSelectedItems:

 Office365Users.SearchUserV2(
            {
                searchTerm: Trim(ThisItem.'Manager/Supervisor'.Email),
                isSearchTermRequired: false
            }
        ).value

[sppt]

Hi @v-qiaqi-msft:

thanks for your reply. I've already tried this one... but it picks the first one in the Dropdown. And at a search --> always the item from Sharepoint list. 

regards, Pat

[sppt]

next "cool" thing is, that everything disappears after saving the draft. If I delete the "DefaultSelectedItems" and set it to blank - the app is visible again...

I found some posts regarding "Modern Controls" but I had the same issue with the former controls and decided to stay modern 😉

[v-qiaqi-msft]

Hi @sppt,

Dropdown?

I think it should be a ComboBox.

Well, you need to try to add the top parameter:

 Office365Users.SearchUserV2(
            {
                searchTerm: Trim(ThisItem.'Manager/Supervisor'.Email),
                top:999,
                isSearchTermRequired: false
            }
        ).value

[sppt]

yes - ComboBox... sorry.

But I get the same behaviour. If i select from Dropdown-List (within the ComboBox) - everything is fine. If I insert a SearchText and select then a suggested value - the "ThisItem.'Manager/Supervisor'" re-appears.

[sppt]

@v-qiaqi-msft ... thanks so far for your answers. 

Maybe I try to explain it with screenshots...

If I just click on the ComboBox and choose a value out of that suggested DropDown-List... 

everything is fine !

If i write a SearchText (1) into the ComboBox and select a suggested value (2) ...

it jumps back to the initial value from Sharepoint List.

Regards,
Patrick