SharePoint Multi-Select combobox Update showing Patch error

[williamferrier]

Hi All,

I'm trying to create a custom SharePoint form using PowerApps, but I keep seeing a "patch" error when I try to use the app.

I have one field which is a single selection combobox, pulls items from another list and the below works fine as the Update syntax:

{
'@odata.type':
"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id:DataCardValue1.Selected.ID,
Value:DataCardValue1.Selected.Title
}

All good so far...

But as soon as I add a combobox that allows multiple selections, it throws the patch error. My understanding is that when the app is based on a custom sharepoint form, the patch function is not required in the Update syntax. I've tried ForAll to loop through each item, but again, this fails for me. Any ideas..? Thanks!

[WarrenBelz]

Hi @williamferrier ,

This is the structure

ForAll(
   DataCardValue1.SelectedItems As aSel
   {
      Id: aSel.ID,
      Value: aSel.Title
   }
)

but I am wondering if Title should be Value

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.

MVP (Business Applications)   Visit my blog Practical Power Apps

[williamferrier]

Thanks for the super spedy reply @WarrenBelz .

I've tried the structure in a few different forms, but still no luck in getting it to work. I must be missing something fundamental for the red highlights to appear... 

Effort 1 (basic structure without the SPlist connector - which I presume I need):

Effort 2 (SPlist connector):

Effort 3 (SPlIst connector, but with the alias taken out):

I've even tried adding what I think is the source...

Any help on this would be really appreciated - before my laptop is thrown out the window! 🙂

Many thanks!

[WarrenBelz]

Hi @williamferrier ,

Firstly, you do not need the first line @odata.type reference anymore, so delete that. I have to assume here this is a Lookup field (which you really do not need to use with Power Apps - I never use them), but the next question is what is the Items of the Combo Box ?

[williamferrier]

I’m pulling Items for the combo box from another sharepoint list. 

items = ‘IT Document Repository- Tags’ 

I have another field where I’m using an O365 Active Directory connector in another multi select combo box to display users. I presume the same syntax can be used for this too..?

Thanks again for the help on this. It’s really appreciated.

[WarrenBelz]

@williamferrier ,

This is where Lookup fields cause you so much completely unnecessary grief - changing the Items of your Combo Box from the standard Choices(ListName.LookupFieldName). The issue is that you now do not have the Id (which is the ID of the item being looked up in the other list). What I am confused about now is how the output is DataCardValue2.Selected.Title when that is your Items ?

However, the structure you need is this (I am guessing the field name here based on your post)

ForAll(
   DataCardValue1.SelectedItems As aSel
   {
      Id: 
      LookUp(
         YuorOtherList,
         'IT Document Repository- Tags' = aSel.Title
      ).ID,
      Value: aSel.Title
   }
) 

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.

MVP (Business Applications)   Visit my blog Practical Power Apps

[williamferrier]

@WarrenBelz 

I'm still battling with this. Here's what I have...

I've created a document library 'IT Document Repository' with column 'Tags'. I'm playing with both Choice and Lookup field types for this column - It doesn't matter to me which type I use, but at the moment I have pointed to my Lookup field.

The dropdown items for 'Tags' needs to come from another list 'IT Doc Repository - Tags'. In this list, I've got column 'Title' containing the value I want displayed in the 'Tags' column of my document library.

In PowerApps, I've got --

Datacard: 'Tags_DataCard1'

-- Update: 

ForAll(DataCardValue4.SelectedItems as TagLk
{
id: LookUp('IT Document Repository - Tags',Title=TagLk.Value).ID,
Value: TagLk.Value
}
)

Combobox in 'Tags_DataCard1': DataCardValue4

-- Items: 'IT Document Repository - Tags'

-- DisplayField: ["Title"]

Any ideas? The syntax doesn't look too happy. 

Again, thanks for the support on this. 

[WarrenBelz]

@williamferrier ,

That is because the output is not contained in your lookup schema - if it is unrelated, put the output into the Choice column and then you only need the Value.

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.

MVP (Business Applications)   Visit my blog Practical Power Apps

[williamferrier · Accepted solution]

@WarrenBelz - Thanks for all your help on this. I finally got it working. 

The Update in my card is now very simple:

ForAll(DataCardValue4.SelectedItems,
{Value: ThisRecord.Title})

I then figured out that I needed to also change the DefaultSelectedItems on my combobox to:

ForAll(ThisItem.Tags,LookUp('IT Document Repository - Tags',Title=Value))

Without the last step, my update wouldnt account for any existing records.

Now, I need to repeat all of this, but with a multi selection people picker (using O365 connector). This is a problem for tomorrow me to figure out.