Patching the selected values of dropdowns, text inputs and combo boxes

[byr10112]

Hello,

I'm trying to build a power app, where the user can go in, select an account based off of the list provided in an imported Excel file in the combo box, and the account ID, Area and Sales Unit of the account is populated automatically through other combo boxes that depend on the first combo box. The user then should be able to use other combo boxes and text inputs to give further information on the account. Lastly, when all the fields are populated, the user should be able to press a button and the information provided will get patched to the sharepoint list.

I built all the combo boxes and inputs, they work fine. The issue I'm having is, I cannot patch to the sharepoint list. Below is the formula I use for Patch

Patch('Losses', Defaults('Losses'),
{
ID: ID, 
Name: Name,
Area: Area,
SalesUnit: SalesUnit,
isChild: isChild,
ChildName: ChildName,
NR_Reason: Reasons,
NR_Other: Other,
WinBack:WB,
WinBack_Details: Details})

Where name is the combo box the user uses to select the account, Area, SalesUnit, and ID are populated automatically. isChild, NR_Reason, and WinBack are combo boxes where the options are from other separate sharepoint lists. ChildName, Other, and Details are text inputs.

When I run Monitor, I get a "Bad Request" error on the CreateRow operation. The following Patch and Unhandled error operations return "Network error when using Patch function: The requested operation is invalid."

How can I fix my Patch function to make it work? 

[SebS]

@byr10112 

ComboBoxes, same as Dropdowns, need to finish with Selected and then for Dropdown will be Value, but for ComBobox it's Selected.ColumnName

Example assuming Area and SalesUnit  is a ComboBoxName:

Area: Area.Selected.Area,
SalesUnit: SalesUnit.Selected.SalesUnit,
isChild: isChild,

Same for other Controls for TextInput You need to finish with TextInput.Text

[byr10112]

Thanks for your reply. I'm a little confused. I updated the formula to:

Patch('LostRenewalsTest', Defaults('LostRenewalsTest'),
{
ID: ID.Selected.ID, 
Name: Name.Selected.Name ,
Area: Area.Selected.Area,
SalesUnit: SalesUnit.Selected.SalesUnit,
isChild: IsChild.Selected.IsChild,
ChildName: ChildName.TextInput.ChildName,
NR_Reason: Reasons.Selected.Reasons,
NR_Other: Other.TextInput.Other,
WinBack:WB.Selected.WB,
WinBack_Details: Details.TextInput.Details})

However, I'm still getting the same error. Not sure I completely understand how to proceed. 

[byr10112]

I keep getting these types of errors: The type of this argument 'Area' does not match the expected type Text. Found type Record

[SebS]

@byr10112 

So describe what control is assigned to each of the data :

ID - Combobox

Name- Combobox

isChild - ?

And so go one. that will make it easier to find the issue as not all controls refer to the same properties.

[byr10112]

ID: Dropdown (dependent on Name),
Name: Combo Box ,
Area: Dropdown (dependent on Name),
SalesUnit: Dropdown (dependent on Name),
isChild: Combo box,
ChildName: Text Input,
Reasons: Combo box,
Other: Text Input,
WB: Combo box,
Details: Text Input

[SebS]

@byr10112 

here it is and it should work but there can be an issue with Area and SalesUnit if You used some sort of distinct function in them or some thing what will generate Result Rather Value try to use .Selected.Result

Also keep in mind ID must be name of the control same for Name so the right syntax is

NameOfTheControl.Selected.Value for DropDown in some cases it's Selected.Result

NameOfTheControl.Selected.NameOfTheColumn for ComboBox

NameOfTheControl.Text for Textinputs

Example I called in app a dropdown containing Name = txt_Name in Patch I will refer to it like this 

Name: txt_Name.Text

same concept is for rest of the controls

Patch('LostRenewalsTest', Defaults('LostRenewalsTest'),
{
ID: ID.Selected.Value, 
Name: Name.Selected.Name ,
Area: Area.Selected.Value,
SalesUnit: SalesUnit.Selected.Valuet,
isChild: IsChild.Selected.IsChild,
ChildName: ChildName.Text,
NR_Reason: Reasons.Selected.Reasons,
NR_Other: Other.Text,
WinBack:WB.Selected.WB,
WinBack_Details: Details.Text})

Do not forget about Monitor as well you can put Monitor on 

when you put it on and You press button to patch it will Monitor activity on the background of the patch and you can check what causing still an issue but hope that sort things for You.