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.
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
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
WarrenBelz
146,605
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,946
Most Valuable Professional