The specified column '_' does not exist.

Like (0) Share

Report

Posted on 5 Jul 2023 06:30:06 by grim_mushroom

Hello fellow PowerApps users!

In my application I'm trying to patch a SharePoint list using a button:

OnSelect:

Patch(
 'MyList',
 LookUp(
 'MyList',
 'Customer ID' = CustomerList.Selected.'Customer ID'
 ),
 {'Area/Departments':AreaDept_ComboBox.SelectedItems}
)

However, the app throws an error: The specified column '_' does not exist. The function 'Patch' has some invalid arguments. Well, Area/Departments column does exist in my SharePoint list. It is a Choice column I should mention.

Could you please help me with finding a root cause for this error? I have spent hours digging this forum and others for a solution and found none. Any feedback would be greatly appreciated.

Categories:

General Questions

All responses (2)

Answers (1)

Verified answer

grim_mushroom on 05 Jul 2023 at 10:28:33

Like (0)

Report

Re: The specified column '_' does not exist.

Hi Qi,
thanks for your feedback.

What I discovered during the testing is that Power Apps really badly works with a 'Person' type column. After changing it to the 'Text' type, the issue was gone.
Since I had multiple ComboBoxes, I listed them in the update argument of the Patch function one by one, not all in one.
{'SP_Field0': ComboBoxName.SelectedItems},
{'SP_Field1': ComboBoxName.Selected.DisplayName},
{'SP_Field2':LabelName.Text},
{'SP_Field3':DatePickerName.SelectedDate},
...

Regards,
grim_mushroom
v-qiaqi@microsoft.com on 05 Jul 2023 at 07:20:15

Like (1)

Report

Re: The specified column '_' does not exist.

Hi @grim_mushroom,

Have you tried to refresh the data source?

Further, please check the following tips:

1). Make sure that the Title column is not required

2). Make sure that the Area/Departments column name is the real inner column name of the Choice column

You could check the field name by the following step, go to list settings and select the choice column, within the address bar, you could find the field name at the end of the address