Combo-box (one pulled from LookUp Column) will not patch to SharePoint List

[jharville1]

Hello! I have two combo-boxes ('Country' & 'Review Material') that will not patch to my SharePoint list, but all other fields in my form successfully do... Here is a screenshot of the form (there are a few other fields that aren't shown but these aren't important to the underlying issue):

*The 'Country' combo-box only allows for a single selection, and the items are pulled from a "Choice" column in my SharePoint List

     -The name of the 'Country' field's combo-box is called "nationBox"

*The 'Review Material' combo-box allows for multiple selections, and the items within that combo-box are pulled from a Lookup Column

     -The name of the 'Review Material" field's combo-box is called "reviewComboBox"

This is the Patch() Statement that I currently have:

***(side note: the 'Item' property of my EditForm is set to varRecord)

It is supposed to patch all of the fields into a list called 'cfa test list' (and also mark the FormStatus as "Submitted"), but it didn't patch any of the items selected from the "Country" and "Review Material" combo-boxes in my form to its perspective columns in my SharePoint List ...

I added Country: nationBox.Selected to the Patch() statement hoping it would add the item selected from my form's "Country" combo-box to the Country column in my SharePoint list, and even though it didn't throw any errors ... it didn't patch any info to the column and it still shows up blank.

(I've also tried Review Material: reviewComboBox.SelectedItems.Result to patch info to 'Review Material' but that didn't work either)

---------------------------------------------------------------------------------------------------------------------------

Does anybody know what lines of code will be able to patch the *one* item selected in my "Country" field (combo-box) of my form AND the *multiple* items selected in my "Review Material" field (combo-box) of my form to my 'cfa test list' (SharePoint List)?

[WarrenBelz]

Hi @jharville1 ,

Try this

Patch(
   'cfa test record',
   {ID:varRecord.ID},
   YourFormName.Updates
)

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.

[jharville1]

Hi @WarrenBelz !

I tried your solution, and even though it didn't throw any errors, it still didn't patch anything to my SP List:

(I also tried your above code but with varRecord replacing {ID: varRecord.ID} ... but it still didn't work

[jharville1]

@WarrenBelz 

I forgot to mention that the contents of my 'Country' field in my form is pulled from a "Choice" type field in my SharePoint list.

[WarrenBelz]

Hi @jharville1 ,

And there is the missing piece of the puzzle . . .

Patch(
   'cfa test record',
   {ID:varRecord.ID},
   {
      FormStatus:"Submitted",
      Country:{Value:nationbox.Selected.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.

[jharville1]

@WarrenBelz 

I tried your code and it's still not populating the 'Country' column in my SharePoint list with a patch...

There's also no errors in the code you provided:

Do you have any other ideas on solutions that may population that column in the SharePoint list? I will be messing around with your code in the meanwhile to see what can get that change to be successful.

(Also for my 'Review Material column, I do know that it uses a "Result" instead of a "Value" attribute since I ran a distinct function on the item choices in that combo-box)

[WarrenBelz]

Hi @jharville1 ,

Firstly I am assuming that the Patch works on the "Submitted" value into FormStatus - therefore the ID syntax is patching the correct record. Please confirm this.

To explain the next bit

Country:{Value:nationbox.Selected.Value}

Country (obviously) is the name of the Destination field in your list 'cfa test status'

As Country is a Choice field, it is of the "complex" field type (a Table) even though it contains only the one field Value in this Table. When you Patch to "Table Fields", you need to enclose the values in { } brackets and then list the fields and the required contents to send. So the first bit will be Value, but if you used a Distinct Filter, then certainly the value to be patched will be the Result

Country:{Value:nationbox.Selected.Result}

This is a very basic Patch operation and should not be difficult to sort with all the correct references.

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.

[jharville1]

@WarrenBelz 

That's actually a really good point (regarding FormStatus: Submitted). I did some testing on my side and saw that the patch works most of the time, but only when the entire form is filled out. Oddly enough, I am suspecting that it only successfully patches if certain criteria is met when filling out the form, when it shouldn't matter about what is filled out ~ it should patch regardless of the contents of the form.

I will do some more testing on my side and see why every form that is submitted is not marked as "Submitted" , as seen in the image above that there is one record that has a FormStatus of "New". I will respond once I figure out this issue and fiddle around with those two patch statements using your advice.

Thank you for your help Warren

[WarrenBelz]

Hi @jharville1 ,

A bit more debugging - put a Label inside the gallery with 

ThisItem.ID

and then another one anywhere on the screen with 

varID

They should be the same just before the Patch is done.

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.

[jharville1]

@WarrenBelz 

Do you know why I'm getting this error? (The 'Review Item field was where I used Distinct, not 'Country'):

Here's the full code:

(Also, reviewItem allows for multiple selections)