Patch new record(s) based on a combo box?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Can you create new Sharepoint records based on a combobox?

Patch(ListName,

{Task Name:Dropdown1.selected,

Person:combo_box1.selecteditems.result,

Department:dropdown4.selected})

the person value is a dropdown list of names on sharepoint

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

BCLS776 8,994 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!
You can use a ComboBox to drive a Patch(), but keep in mind SelectedItems is a table with potentially multiple entries - your Patch() needs to handle this. Syntax will look more like:

ForAll(combo_box1.SelectedItems As aItem, Patch(ListName,Defaults(ListName), { TaskName: Dropdown1.Selected.Text, Person: aItem.Result // Assuming this is a single line of text column Department: Dropdown4.Selected.Text } ) )

Hope that helps,

Bryan

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Yes you can, but depends on your SharePoint list column settings. If it's a person field, then you'll need to allow multiple people on the column. I can't remember if powerapps will convert that or not automatically, but you'll want to make sure that's enabled on the column, then update the schema / save reload your app, then use the combobox.selecteditems only not .results, it should respect the multiple selection.

If it's another column type then you'll have to use concat etc. to concatenate the .selecteditems from the table as suggested in previous reply.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @marc2510,

Do you want to save multi select Combo Box items to Person column?

Could you please tell me that if the Person column is a Text column in the SP list?

I assume that the Person column is a single line of text column, please modify your formula as below:

Patch(ListName, {Task Name:Dropdown1.selected, Person:Concat(combo_box1.SelectedItems,Result,",") Department:dropdown4.selected})

Was this reply helpful? Yes No
Stacey_T 60 on at

Like
a
(0)

Report
Copy link

Link copied!
Is it possible to have the Patch function create the number of records equivalent to the number of selections in the combobox, i.e. one new record per selection? The solution seems to put my multiple selections into one row/one field.
ForAll(combobox.SelectedItems As alias,
Patch(SP_list, Defaults(SP_list),
{alias_test_field: alias.Result}));

Was this reply helpful? Yes No