Patch Function Error

[ronanf16]

Patch(Table1, Defaults(Table1), { DATE: DatePicker2_7. SelectedDate, HU: ComboBox4.SelectedItems, PROPERTY: ComboBox1.SelectedItems, OPERATION: Dropdown8.Selected.Value, SITE_SAFETY_COORDINATOR: TextInput10_7.Text, CONTRACTOR: ComboBox3.SelectedItems, HAZARD_1: TextInput13.Text, CONSEQUENCE_1: TextInput14.Text, SEVERITY_1: Slider1.Value, LIKELYHOOD_1: Slider2.Value, NUMBER_PEOPLE_AFFETED_1: Toggle1.Value, CONTROLS_1: TextInput15.Text, PERSONS_RESPOSIBLE_1: TextInput16.Text, RESULTANT_RISK_1: Slider3.Value, HAZARD_2: TextInput13_6.Text, CONSEQUENCE_2: TextInput14_6.Text, SEVERITY_2: Slider1_6.Value, LIKELYHOOD_2: Slider2_6.Value, NUMBER_PEOPLE_AFFECTED_2: Toggle1_6.Value, CONTROLS_2: TextInput15_6.Text, PERSONS_RESPONSIBLE_2: TextInput16_6.Text, RESULTANT_RISK_2: Slider3_6.Value, HAZARD_3: TextInput13_7.Text, CONSEQUENCE_3: TextInput14_7.Text, SEVERITY_3: Slider1_7.Value, LIKELYHOOD_3: Slider2_7.Value, NUMBER_PEAOPLE_AFFECTED_3: Toggle1_7.Value, CONTROLS_3: TextInput15_7.Text, PERSONS_RESPONSIBLE_3: TextInput16_7.Text, RESULTANT_RISK_3: Slider3_7.Value, HAZARD_4: TextInput13_8.Text, CONSEQUENCE_4: TextInput14_8.Text, SEVERITY_4: Slider1_8.Value, LIKELYHOOH_4: Slider2_8.Value, NUMBER_PEOPLE_AFFECTED_4: Toggle1_8.Value, CONTROLS_4: TextInput15_8.Text, PERSONS_RESPONSIBLE_4: TextInput16_8.Text, RESULTANT_RISK_4: Slider3_8.Value, HAZARD_5: TextInput13_9.Text, CONSEQUENCE_5: TextInput14_9.Text, SEVERITY_5: Slider1_9.Value, LIKELYHOOD_5: Slider2_9.Value, NUMBER_PEOPLE_AFFECTED_5: Toggle1_9.Value, CONTROLS_5: TextInput15_9.Text, PERSONS_RESPONSIBLE: TextInput16_9.Text, RESULTANT_RISK_5: Slider3_9.Value }); Reset(DatePicker2_7); Reset(ComboBox4); Reset(ComboBox1); Reset(Dropdown8); Reset(TextInput10_7); Reset(ComboBox3); Reset(TextInput13); Reset(TextInput14); Reset(Slider1); Reset(Slider2); Reset(Toggle1); Reset(TextInput15); Reset(TextInput16); Reset(Slider3); Reset(TextInput13_6); Reset(TextInput14_6); Reset(Slider1_6); Reset(Slider2_6); Reset(Toggle1_6); Reset(TextInput15_6); Reset(TextInput16_6); Reset(Slider3_6); Reset(TextInput13_7); Reset(TextInput14_7); Reset(Slider1_7); Reset(Slider2_7); Reset(Toggle1_7); Reset(TextInput15_7); Reset(TextInput16_7); Reset(Slider3_7); Reset(TextInput13_8); Reset(TextInput14_8); Reset(Slider1_8); Reset(Slider2_8); Reset(Toggle1_8); Reset(TextInput15_8); Reset(TextInput16_8); Reset(Slider3_8); Reset(TextInput13_9); Reset(TextInput14_9); Reset(Slider1_9); Reset(Slider2_9); Reset(Toggle1_9); Reset(TextInput15_9); Reset(TextInput16_9); Reset(Slider3_9); Navigate(Harvesting_Landing,ScreenTransition.None)

basically i get an error message saying: 

the argument "CONTRACTOR" does not match the expected type Text, found type Table

I've tried writing it a number of different ways but i must be missing something simple here, please help as i'm frustrated and lost here.

[mdevaney · Accepted solution]

@ronanf16
This code tries to patch the entire set of records stored in ComboBox3

CONTRACTOR: ComboBox3.SelectedItems

If your ComboBox is single selection you should do this instead. Replace your_fieldname with the field you want to store

CONTRACTOR: ComboBox3.Selected.your_fieldname

Or if your ComboBox is multiple selection you should do this instead

CONTRACTOR: Concat(ComboBox3.SelectedItems,your_fieldname&”, ”)

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

[ronanf16]

Ok thank you. That method has solved a few errors for me. now it is telling me that:

The specified column NUMBER_PEOPLE_AFFECTED_3" does not exist.

This column definitely exists as column AA on the excel spreadsheet i am using. it is definitely spelled and formatted correctly so i dont understand why it doesn't pick it up.

Patch(Table1, Defaults(Table1), { DATE: DatePicker2_7. SelectedDate, HU: ComboBox4.Selected.HARVEST_UNIT, PROPERTY: ComboBox1.SelectedItems, OPERATION: Dropdown8.Selected.Value, SITE_SAFETY_COORDINATOR: TextInput10_7.Text, CONTRACTOR: ComboBox3.Selected.Contractor, HAZARD_1: TextInput13.Text, CONSEQUENCE_1: TextInput14.Text, SEVERITY_1: Slider1.Value, LIKELYHOOD_1: Slider2.Value, NUMBER_PEOPLE_AFFETED_1: Toggle1.Value, CONTROLS_1: TextInput15.Text, PERSONS_RESPOSIBLE_1: TextInput16.Text, RESULTANT_RISK_1: Slider3.Value, HAZARD_2: TextInput13_6.Text, CONSEQUENCE_2: TextInput14_6.Text, SEVERITY_2: Slider1_6.Value, LIKELYHOOD_2: Slider2_6.Value, NUMBER_PEOPLE_AFFECTED_2: Toggle1_6.Value, CONTROLS_2: TextInput15_6.Text, PERSONS_RESPONSIBLE_2: TextInput16_6.Text, RESULTANT_RISK_2: Slider3_6.Value, HAZARD_3: TextInput13_7.Text, CONSEQUENCE_3: TextInput14_7.Text, SEVERITY_3: Slider1_7.Value, LIKELYHOOD_3: Slider2_7.Value, NUMBER_PEOPLE_AFFECTED_3: Toggle1_7.Value, CONTROLS_3: TextInput15_7.Text, PERSONS_RESPONSIBLE_3: TextInput16_7.Text, RESULTANT_RISK_3: Slider3_7.Value, HAZARD_4: TextInput13_8.Text, CONSEQUENCE_4: TextInput14_8.Text, SEVERITY_4: Slider1_8.Value, LIKELYHOOD_4: Slider2_8.Value, NUMBER_PEOPLE_AFFECTED_4: Toggle1_8.Value, CONTROLS_4: TextInput15_8.Text, PERSONS_RESPONSIBLE_4: TextInput16_8.Text, RESULTANT_RISK_4: Slider3_8.Value, HAZARD_5: TextInput13_9.Text, CONSEQUENCE_5: TextInput14_9.Text, SEVERITY_5: Slider1_9.Value, LIKELYHOOD_5: Slider2_9.Value, NUMBER_PEOPLE_AFFECTED_5: Toggle1_9.Value, CONTROLS_5: TextInput15_9.Text, PERSONS_RESPONSIBLE_5: TextInput16_9.Text, RESULTANT_RISK_5: Slider3_9.Value }); Reset(DatePicker2_7); Reset(ComboBox4); Reset(ComboBox1); Reset(Dropdown8); Reset(TextInput10_7); Reset(ComboBox3); Reset(TextInput13); Reset(TextInput14); Reset(Slider1); Reset(Slider2); Reset(Toggle1); Reset(TextInput15); Reset(TextInput16); Reset(Slider3); Reset(TextInput13_6); Reset(TextInput14_6); Reset(Slider1_6); Reset(Slider2_6); Reset(Toggle1_6); Reset(TextInput15_6); Reset(TextInput16_6); Reset(Slider3_6); Reset(TextInput13_7); Reset(TextInput14_7); Reset(Slider1_7); Reset(Slider2_7); Reset(Toggle1_7); Reset(TextInput15_7); Reset(TextInput16_7); Reset(Slider3_7); Reset(TextInput13_8); Reset(TextInput14_8); Reset(Slider1_8); Reset(Slider2_8); Reset(Toggle1_8); Reset(TextInput15_8); Reset(TextInput16_8); Reset(Slider3_8); Reset(TextInput13_9); Reset(TextInput14_9); Reset(Slider1_9); Reset(Slider2_9); Reset(Toggle1_9); Reset(TextInput15_9); Reset(TextInput16_9); Reset(Slider3_9); Navigate(Harvesting_Landing,ScreenTransition.None)

[mdevaney]

@ronanf16
The column name must match exactly. Check for spelling errors or blank spaces at the start or end of the column name.

I noticed this column name is misspelled. Maybe some other columns are misspelled too.
NUMBER_PEOPLE_AFFETED_1

One more tip: if you changed the column name in Excel after the datasource was already added to your add you must REFRESH the datasource.

——
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

[ronanf16]

I have tried refreshing a number of times and copy and pasting the exact column name and still no success. would it have anything to do with the fact that columns A to Z are working fine but now column AA is not being picked up but powerapps? i cant seem to find any explanation for why this is happening.

[mdevaney]

@ronanf16
The only other idea I have is that the column contains formulas. PowerApps cannot read/write any columns having a formula in Excel.

If this does not work I you might want to mark this thread as solved and make a new post to attract some more attention to the topic.

Here’s hoping my idea works!

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

[ronanf16]

No formulas, here is a screenshot of my table, maybe you can see something i'm missing?

[mdevaney]

NUMBER_PEAOPLE_AFFECTED_3 seems to be misspelled. It should be spelled NUMBER_PEOPLE_AFFECTED_3 instead.

[ronanf16]

I have corrected all spelling errors and still see the same error appearing here, i cant wrap my head around what might be causing the problem.

Patch(Table1, Defaults(Table1), { DATE: DatePicker2_7. SelectedDate, HU: ComboBox4.Selected.HARVEST_UNIT, PROPERTY: ComboBox1.SelectedItems, OPERATION: Dropdown8.Selected.Value, SITE_SAFETY_COORDINATOR: TextInput10_7.Text, CONTRACTOR: ComboBox3.Selected.Contractor, HAZARD_1: TextInput13.Text, CONSEQUENCE_1: TextInput14.Text, SEVERITY_1: Slider1.Value, LIKELYHOOD_1: Slider2.Value, NUMBER_PEOPLE_AFFECTED_1: Toggle1.Value, CONTROLS_1: TextInput15.Text, PERSONS_RESPOSIBLE_1: TextInput16.Text, RESULTANT_RISK_1: Slider3.Value, HAZARD_2: TextInput13_6.Text, CONSEQUENCE_2: TextInput14_6.Text, SEVERITY_2: Slider1_6.Value, LIKELYHOOD_2: Slider2_6.Value, NUMBER_PEOPLE_AFFECTED_2: Toggle1_6.Value, CONTROLS_2: TextInput15_6.Text, PERSONS_RESPONSIBLE_2: TextInput16_6.Text, RESULTANT_RISK_2: Slider3_6.Value, HAZARD_3: TextInput13_7.Text, CONSEQUENCE_3: TextInput14_7.Text, SEVERITY_3: Slider1_7.Value, LIKELYHOOD_3: Slider2_7.Value, NUMBER_PEOPLE_AFFECTED_3: Toggle1_7.Value, CONTROLS_3: TextInput15_7.Text, PERSONS_RESPONSIBLE_3: TextInput16_7.Text, RESULTANT_RISK_3: Slider3_7.Value, HAZARD_4: TextInput13_8.Text, CONSEQUENCE_4: TextInput14_8.Text, SEVERITY_4: Slider1_8.Value, LIKELYHOOD_4: Slider2_8.Value, NUMBER_PEOPLE_AFFECTED_4: Toggle1_8.Value, CONTROLS_4: TextInput15_8.Text, PERSONS_RESPONSIBLE_4: TextInput16_8.Text, RESULTANT_RISK_4: Slider3_8.Value, HAZARD_5: TextInput13_9.Text, CONSEQUENCE_5: TextInput14_9.Text, SEVERITY_5: Slider1_9.Value, LIKELYHOOD_5: Slider2_9.Value, NUMBER_PEOPLE_AFFECTED_5: Toggle1_9.Value, CONTROLS_5: TextInput15_9.Text, PERSONS_RESPONSIBLE_5: TextInput16_9.Text, RESULTANT_RISK_5: Slider3_9.Value }); Reset(DatePicker2_7); Reset(ComboBox4); Reset(ComboBox1); Reset(Dropdown8); Reset(TextInput10_7); Reset(ComboBox3); Reset(TextInput13); Reset(TextInput14); Reset(Slider1); Reset(Slider2); Reset(Toggle1); Reset(TextInput15); Reset(TextInput16); Reset(Slider3); Reset(TextInput13_6); Reset(TextInput14_6); Reset(Slider1_6); Reset(Slider2_6); Reset(Toggle1_6); Reset(TextInput15_6); Reset(TextInput16_6); Reset(Slider3_6); Reset(TextInput13_7); Reset(TextInput14_7); Reset(Slider1_7); Reset(Slider2_7); Reset(Toggle1_7); Reset(TextInput15_7); Reset(TextInput16_7); Reset(Slider3_7); Reset(TextInput13_8); Reset(TextInput14_8); Reset(Slider1_8); Reset(Slider2_8); Reset(Toggle1_8); Reset(TextInput15_8); Reset(TextInput16_8); Reset(Slider3_8); Reset(TextInput13_9); Reset(TextInput14_9); Reset(Slider1_9); Reset(Slider2_9); Reset(Toggle1_9); Reset(TextInput15_9); Reset(TextInput16_9); Reset(Slider3_9); Navigate(Harvesting_Landing,ScreenTransition.None)

[mdevaney]

@ronanf16 

Please send a screenshot of the error message shown in the App Checker and a screenshot of any code highlighted with a red error line.