Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

The specified column '_' does not exist.

(0) ShareShare
ReportReport
Posted on by

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:
  • Verified answer
    grim_mushroom Profile Picture
    on at
    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 Profile Picture
    on at
    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

    vqiaqimsft_0-1688541545391.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,605 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,946 Most Valuable Professional

Leaderboard