web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps The new modern Combo B...

Power Apps

Unanswered

The new modern Combo Box selectedItems errors out

(0) Share

Report

Report

Posted on by bllknight007

Hi Guys

I have been following Raza recent tutorial Power Apps PATCH function Tutorial with Modern Controls. But the Skills: combo multiselect control error's out. The data source is SharePoint. It is definitely the selectedItems property the issue, just wondered if there is a workaround or syntax I am missing here.

I been struggling a bit with this one...

Thanks in advance

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Hassan_SZ_365 542 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bllknight007 ,
Use this Formula:

Patch( 'Employee Data', If(varRecordType="New", Defaults('Employee Data'), varItem), { Title: TextInputCanvas1.Text, Department: DropdownCanvas2.Selected, Age: Value(TextInputCanvas2.Text), 'Hire Date': DatePickerCanvas1.SelectedDate, 'Exit Date': DatePickerCanvas2.SelectedDate, Salary: Value(TextInputCanvas3.Text), Skills: ForAll(ComboboxCanvas1.SelectedItems, {Value: Value}), Active: CheckboxCanvas1.Checked } )

In this formula, ForAll(ComboboxCanvas1.SelectedItems, {Value: Value}) creates an array of records with a Value field, which is the format expected by SharePoint for multi-select choice fields.
If you still encounter issues, make sure the names of the controls (ComboboxCanvas1, TextInputCanvas1, etc.) match exactly with those in your app. Also, ensure that the column names (Skills, Title, Department, etc.) match with the internal names of your SharePoint list's columns.
If the Skills column is a 'Lookup' column in SharePoint, the approach would be different, and you would have to use the Id of the selected items.
Best Regards,
Hassan Raza
MudassarSZ365 591 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @bllknight007 ,
corrected version of the Skill field patching:
Skills: ForAll(ComboboxCanvas1.SelectedItems, {Value: Value})
Patch function with correction
Patch( 'Employee Data', If(varRecordType="New", Defaults('Employee Data'), varItem), { Title: TextInputCanvas1.Value, Department: DropdownCanvas2.Selected.Value, Age: Value(TextInputCanvas2.Value), HireDate: DatePickerCanvas1.SelectedDate, ExitDate: DatePickerCanvas1_1.SelectedDate, Salary: Value(TextInputCanvas2_1.Value), Skills: ForAll(ComboboxCanvas1.SelectedItems, {Value: Value}), Active: CheckboxCanvas1.Checked } );
If this solution helps resolve your issue, please accept it. 😊

Join the conversation