Answered

Patch Function Error

(0) Share

Report

Posted on by 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.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
ronanf16 60 on at

Like (0)

Report

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)

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
ronanf16 60 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
ronanf16 60 on at

Like (0)

Report

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

snap.PNG

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (1)

Report

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

Was this reply helpful? Yes No
ronanf16 60 on at

Like (0)

Report

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)

snap.PNG

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (1)

Report

@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.

Was this reply helpful? Yes No
ronanf16 60 on at

Like (0)

Report

everything up to }); is underlined in red

Captu44e.PNG

Capture.PNG

Was this reply helpful? Yes No