Network error when using patch function - I am about to loose my mind!

[BaseHQ]

Hello All 

Yes, I am new BUT I have used Patch before and I have checked my syntax against forums but I just cannot get my patch function to work - patching a new record in a sharepoint list via input components (dropdowns, text inputs, date selector etc) on a canvas app. Screen grabs below - any pointers would be appreciated - thanks!

[Amik]

@BaseHQ - is "SI Number" set up as a Number field or as a Text field in your data source?

If it is a Number data type, you will need to convert the Text into a Number using the Value function:

'SI Number': Value(txt_sinumber.text),

[timl]

@BaseHQ - to diagnose this, you can try removing the field/value pairs from your call to Patch one-by-one and testing if it works. If the patch succeeds, the last field that you removed will be the culprit.

[BaseHQ]

hello @Amik 

thank you - Site Instruction column is set up as a number field. I removed .text in my code - screen attached but still issues... 

[Amik]

@BaseHQ - please use the code I suggested. So replace this line:

'SI Number': txt_sinumber,

With this:

'SI Number': Value(txt_sinumber.text),

Alternatively if your still struggling, please post your code text (rather than as an image). 

[BaseHQ]

Hello Imran-Ami Khan

Updated code - pasted below... errors still showing. New error - first time - now claims that the record for 'Issued by' is wrong... errors seem to be inconsistent...

Patch(
'Site Instructions',
Defaults('Site Instructions'),
{Project: dd_projectname.Selected,'Date Issued':DatePicker.SelectedDate,'SI Number':Value(txt_sinumber.text),'Issued by':dd_issuedby.selected,Action:dd_actionby.Selected,'Cost Allocation':dd_costallocation.Selected
}
)

[BaseHQ]

Patch(
    'Site Instructions',
    Defaults('Site Instructions'),
    {Project: dd_projectname.Selected,'Date Issued':DatePicker.SelectedDate,'SI Number':Value(txt_sinumber.text),'Issued by':dd_issuedby.selected,Action:dd_actionby.Selected,'Cost Allocation':dd_costallocation.Selected
    }
)

[Amik]

as @timl correctly points out, there are likely multiple errors with your Patch. If you remove each line one by one, you can then pinpoint which field is causing the problem via a process of elimination.

What do you have in the Items property of your "dd_issuedby" Dropdown control?

[BaseHQ]

Items = Choices([@'Site Instructions'].'Issued by')

Something very stange - I created a new screen with three input controls and create a submit button (using patch) worked fine the first two times and then on the third time errors prevented the patch from working correctly... 

Tried deleting variables one by one - with all input components removed, there is still an error... 

[MMPoweR]

Get the value of the selected control.

Please make sure that you use the correct case for control.Selected, as per your image, dd_issuedby.selected is having lower case instead of upper case. 

dd_issuedby.Selected // If this won't work try to get the value, use the code below.

dd_issuedby.Selected.Value