web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Patching MultiSelect c...

Power Apps

Unanswered

Patching MultiSelect columns in a repeating table not working

(0) Share

Report

Report

Posted on by Bereketwold

2

I built a repeating table with a multiselect combobox...Item property --Choices(permission.Jobtitle).

I have 2 issues.

when i patch to my collection it only holds 1 of the selected items
The final submit button dosent work at all.

I have a save button in each gallery item that patches the current items and create a new line. the onselect formula is

Patch(col_Add, ThisItem, {NewJobtitle:Multiselectcombobox.selected.value,---------I also tried using SelectedItems

FName:Textbox1.Text})

On the final submit button i have

ForAll(Col_Add, Patch(Permission,Default(Permission),

{Name:FName,

JobTitle:{Value:NewJobtitle})----------------------------This is not working at all.

Any help would be much appreciated.

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (0)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Bereketwold ,

For the first one try

Patch( col_Add, ThisItem, { NewJobtitle: ForAll( Multiselectcombobox.SelectedItems As aSel, {Value: aSel.Value} ), FName: Textbox1.Text } )

the second should work as below as you now have a matching Table structure in your collection

Patch( Permission, ForAll( Col_Add As aPatch, { Name: aPatch.FName, JobTitle: aPatch.NewJobtitle } ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
Bereketwold 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz
Thank you so much for your suggestio. i tried the above formula and on the fist patch, i get an error saying
NewJobTitle does not match the expected type 'Text'. Found type 'Table'.

I dont understand what caused this error. My SharePoint column is a multiselect and the Combobox also allows multiple selections. any thoughts?
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Bereketwold ,

It is telling you that NewJobTitle is a Text column in SharePoint - can you please check your List Settings for this.

Join the conversation