cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ronanf16
Helper I
Helper I

Patch Function Error

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.

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

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

View solution in original post

10 REPLIES 10
mdevaney
Super User
Super User

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

View solution in original post

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)

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

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.

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

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

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

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)

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,468)