Patch ComboBox SelectItems no longer working

(0) Share

Report

Posted on by rcapone

hi,

initial approach to PATCH ComboBox SelectedItems worked until I used the FIRST function to load values

in the ComboBox 'DefaultSelectedItems' from a SharePoint List PeoplePicker field

the initial approach to PATCH still works as needed when the ComboBox is populated vie user input

ComboBox_BusinessApproverEmail section PATCH works as required (ComboBox is being populated via UI).

ComboBox_FinanceApproverEmail section PATCH now shows as error (ComboBox is being populated from SharePoint PeoplePicker field using FIRST function shown above ).

thanks in advance!

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

MudassarSZ365 591 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @rcapone ,
try this
Patch( YourDataSource, Defaults(YourDataSource), { // Other fields to patch BusinessApproverEmail: ComboBox_BusinessApproverEmail.Selected.Email, // Assuming BusinessApproverEmail is a single person field // For FinanceApproverEmail from PeoplePicker field FinanceApproverEmail: First(ComboBox_FinanceApproverEmail.Selected).Email } )
If you provide more details or error messages, I can assist you further. If you find this solution helpful, please consider accepting it. 😊
rcapone 54 on at

Like
a
(0)

Report
Copy link

Link copied!

hi MudassarSZ365,
BusinessApproverEmail is multi-person Combobox that is being patched to a SharePoint PeoplePicker field

here is the full Patch statement that had been working until I populated the FinanceApproverEmail Combobox using the FIRST function

here is the full PATCH code
-------------------------------------------------------------------
ClearCollect(
colSharePointNewItem,
Patch(
spFinance_List,
Defaults(spFinance_List),
{
Title: FlowParm7_UserFilename,
Business_Requestor:
{
Claims: User().Email,
Department: "",
DisplayName:User().FullName,
Email:User().Email,
JobTitle: "",
Picture: ""
},
Business_Approver: ForAll(ComboBox_BusinessApproverEmail.SelectedItems,
{
Claims: ThisRecord.Mail,
Department: "",
DisplayName:User().FullName,
Email:User().Email,
JobTitle: "",
Picture: ""
}
),

Finance_Approver:ForAll(ComboBox_FinanceApproverEmail.SelectedItems,
{
Claims: ThisRecord.mail,
Department: "",
DisplayName:User().FullName,
Email:User().Email,
JobTitle: "",
Picture: ""
}
),

CC_Users:ForAll(ComboBox_CCeMail.SelectedItems,
{
Claims: ThisRecord.Mail,
Department: "",
DisplayName:User().FullName,
Email:User().Email,
JobTitle: "",
Picture: ""
}
),
FileNameTempale_Uploaded: FlowParm6_UserFilenameExt,
NumberAttachments_Uploaded: varNumberOfAttachments,
Comments: TextInput_Comments.Text,

'Created Date': Today()
}
)
);
-------------------------------------------------------------------
rcapone 54 on at

Like
a
(0)

Report
Copy link

Link copied!

here is the error message
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @rcapone,

Do you set all the people picker Items property with Choices() function?

If you populate the ComboBox_FinanceApproverEmail with Choices(), you can see that the returned table including the following fields like DisplayName, Email, JobTitle

Please check the fields of your ComboBox_FinanceApproverEmail, refer to the correct field name.
rcapone 54 on at

Like
a
(0)

Report
Copy link

Link copied!

hi Qi,
confirming, I am using Choices() in ComboBox_FinanceApproverEmail.Item

First() and Filter() in ComboBox_FinanceApproverEmail.DefaultSelectedItems

Note:
the Patch had been working until I changed the DefaultSelectedItems to uses First() with Filter (on SharePointList) and Items to uses Choices. Initially, it had been using a collection which I had populated via code to contain Joe Blow and Sue Flew email addresses

thanks for your help on this, please advise
RC
Verified answer

rcapone 54 on at

Like
a
(0)

Report
Copy link

Link copied!

I found what was causing the issue - when I changed Claims to be mapped to ThisRecord.Email instead of ThisRecord.mail (which ComboBox_FinanceApproverEmail was previously using and is still used for Patching to the ComboBox_BusinessApproverEmail PeoplePicker field)

not sure why this worked, hope someone can shed some light on this

regards,
RC