Saving multiple people from combo box with Patch

(0) Share

Report

Posted on by AH-22100006-0

Hi there,

I am having issues using a Patch command in Power Apps.

I had it working, then added another combo box to my form, that saved multiple people (from O365) - and it stopped working.

I do this exact same thing in another app I've created, and it works great, so I copied the code and pasted it into my patch command.

It won't work, and I can't see where I may have gone wrong.

If I comment out the code to patch my Authors field (highlighted below), everything works great - when I don't have the code commented out, it errors on me.

But as I said, I copied this exact code from my other app and it works great.

Here is my patch code:
 
Patch(
    'MySharepointList',
    LookUp('MySharepointList', ID = galNotes.Selected.ID),
    {   EntryDate:dtNewEntry.SelectedDate,
        Comments: txtNewEntryNotes.Text,
        StaffMember: {
            Claims: cboUserList.Selected.UserPrincipalName,
            DisplayName: cboUserList.Selected.DisplayName,
            Email: cboUserList.Selected.Mail,
            Picture: "",
            Department:cboUserList.Selected.Department,
            JobTitle:cboUserList.Selected.JobTitle
        },
        Authors: ForAll(
            cboAuthor.SelectedItems As _Data2,
             {
           Claims:"i:0#.f|membership|" & Lower(_Data2.Mail),
           Department: "",
           DisplayName: _Data2.DisplayName,
           Email: _Data2.Mail,
           JobTitle: "",
           Picture: ""       
             })
    })
   
 
Thanks in advance for any help!

Amber
 

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

developerAJ 4,750 on at

Like (1)

Report

what is data source of the combo box meaning Items property

If you did exact way as the other app but still not working could be an issue with combo box. There are issues happening with modern combo box. Microsoft is planning to fix modern control issues soon. If you are using modern, try classic and see

try debugging by adding this code on button and collect

Authors: ForAll(

cboAuthor.SelectedItems As _Data2,

{

Claims:"i:0#.f|membership|" & Lower(_Data2.Mail),

Department: "",

DisplayName: _Data2.DisplayName,

Email: _Data2.Mail,

JobTitle: "",

Picture: ""

})

and see if data is populated

Was this reply helpful? Yes No
WarrenBelz 153,138 Most Valuable Professional on at

Like (0)

Report
Hi @AH-22100006-0,

Firstly @developerAJ is correct in everything noted. I have a blog on the various options here, so you might run throught it and check everything else lines up, in particular

Are the Items of the second Combo Box based on Office365Users.SearchUser like the other one

Is the Person field being written to by the second Combo Box also multiple-value.

Was this reply helpful? Yes No
AH-22100006-0 97 on at

Like (0)

Report

Thanks for the responses!

@developerAJ The items property of the combobox is:

Office365Users.SearchUserV2(

{

searchTerm: Self.SearchText,

isSearchTermRequired: false,

accountEnabled: true,

top: 999

}

).value

(same as in my other, working app).

I used to see options - to use modern or classic combobox - but I only see one choice "Combo box" - just by looking at it, I think it's a classic control.

Your suggestions for debugging - how do I do that? How do I test to see if the data is populated?

Was this reply helpful? Yes No
AH-22100006-0 97 on at

Like (0)

Report

@WarrenBelz the items property is almost the same for both - the only difference is I don't have a filter on this one.

My working combo box has the following for Items property:

Filter(

Office365Users.SearchUserV2(

{

searchTerm: Self.SearchText,

isSearchTermRequired: false,

accountEnabled: true,

top: 999

}

).value,

Department = "Computer Services"

)

Whereas the non-working (new) combo box just has:

Office365Users.SearchUserV2(

{

searchTerm: Self.SearchText,

isSearchTermRequired: false,

accountEnabled: true,

top: 999

}

).value

Yes, the person field being written to is also multiple-value.

Cheers,

Amber

Was this reply helpful? Yes No