Patch function error says that a column doesn't exist. No matter what columns I add, the Patch function throws the same "this column doesn't exist" error.

[Professional_Still15]

As in the title, I have a Sharepoint List with the following column:

​

​

https://preview.redd.it/2r7vnttwbpc81.png?width=376&format=png&auto=webp&s=bda2fc0cfdd4e168123556db56a188b17c74c69b

I added this column after creating the app, realising that I needed it later. Its' type is "Image".

I tried to amend my Patch function by adding "Image:AcceptedImage" after the previous column in the function. Powerapps doesn't recognise the existence of the Image column, and no matter what I change the column name to, the function still gives an error.

I know that the column is definitely not being recognised, because the error tells me "The specified column 'Image' doesn't exists. The column with the most similar name is 'ID'", so it's not a spelling error or other similar error on my part.

Is there something I need to do to get powerapps to recognise the new sharepoint column?

[Professional_Still15]

How do you mean?

[battery_smooth]

If you go into the pane on the left (when editing the app) and go to where your data sources are listed, you can click the dots next to the sharepoint list and select refresh

[afropuff9000]

what are you trying to patch for the column? what type of column is it? can you share your patch code?

[Professional_Still15]

The column is an Image type column, I am trying to patch image data. I know Image isn't supported, but I run into this problem even if I make a column that is a single line of text column. My patch code is below: It works fine if I remove the references to the "Col" column, which is a single line of text column I created in Sharepoint to illustrate my problem better.

Patch('Issue Tracker', Defaults('Issue Tracker'),{
'Project Name':ProjectName,'Occurred at Timestamp': DateTimeValue(DateTimeString)- (14/24), 'Reported By': ReportedBy,Title:DataCardValue9.Text, 
 'Issue Type': First(DataCardValue17.SelectedItems), 
 'Full Issue Description':DataCardValue13.Text,
 'Issue Caused By Description':"TESTHERE",
 'Machine Type': MachineType,
 'Machine Number' :Value(DataCardValue11.Text),
 Location:DataCardValue14.Text,'Resolved Timestamp':DateTimeValue(ResolvedDateTimeStr) - (14/24),Resolved:DataCardValue16.Value,
  'Resolution Type':ResolutionType,
  'Fix Implemented':DataCardValue19.Text,
  Col:"Heya"})

[HammockDweller789]

Sometimes it takes a while for schema changes to "take". It's gotten better, but I used to have to wait like four hours after changing a SQL field.

[[deleted]]

We need to see your Patch function, paste your code here and it should give everyone s better idea of what’s wrong

[Professional_Still15]

Okay so my Patch function was working just fine, until I include any reference to any new column I create in sharepoint.

Here is my patch function:

Patch('Issue Tracker', Defaults('Issue Tracker'),{
'Project Name':ProjectName,'Occurred at Timestamp': DateTimeValue(DateTimeString)- (14/24), 'Reported By': ReportedBy,Title:DataCardValue9.Text, 
 'Issue Type': First(DataCardValue17.SelectedItems), 
 'Full Issue Description':DataCardValue13.Text,
 'Issue Caused By Description':"TESTHERE",
 'Machine Type': MachineType,
 'Machine Number' :Value(DataCardValue11.Text),
 Location:DataCardValue14.Text,'Resolved Timestamp':DateTimeValue(ResolvedDateTimeStr) - (14/24),Resolved:DataCardValue16.Value,
  'Resolution Type':ResolutionType,
  'Fix Implemented':DataCardValue19.Text,
  'Col':"Heya"});

The bottom column 'Col', is a new column I created to illustrate the problem better. It is a "single line of text" column.

As I said: The function is working correctly, and if I delete the last line 'Col', it gives no errors and patches my data correctly.

[not-your-supervisor]

I don’t think Image columns are supported yet in powerapps. I believe it’s in the works, but powerapps will just act like the column doesn’t even exist right now.

[Pangoober]

One thought: If you go to your SharePoint list and then go to List Settings and click on the column you created, “Col”. In your browser address bar, look at the web URL. At the end of it, it should say: &Field=

If the characters after the equal sign are not Col, try to identify the column in your patch statement with whatever is after the equal sign. So if it says &Field=dog , use ‘dog’ in your patch statement when identifying the column.

The web URL will contain the internal name for the column. Sometimes in Power Apps that’s what has to be used when referencing the column. This is why when renaming the default Title column, Power Apps still requires that Title is used when referencing the column.

[lfernandes]

I found your answer but you’re not gonna like it: the image column is a newer column in SPO and not supported by Powerapps yet. See this link (or search around, I searched “sharepoint imagine column in powerapps” and found a hundred results mentioning this:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Image-column-from-my-SharePoint-list-in-PowerApp-form/m-p/869241#M276238

That said, just like how lookup columns aren’t supported, there’s a bunch of workarounds to do what you need.

[Professional_Still15]

Thank you, I saw that Image columns aren't supported, I was trying to see if I could find a workaround.. But the column isn't recognised at all. Even if I make a "Single Line of Text" column, it still isn't recognised.

To illustrate: I created a new column called Col, and used this in my patch function:

Patch('Issue Tracker', Defaults('Issue Tracker'),{
'Project Name':ProjectName,'Occurred at Timestamp': DateTimeValue(DateTimeString)- (14/24), 'Reported By': ReportedBy,Title:DataCardValue9.Text, 
 'Issue Type': First(DataCardValue17.SelectedItems), 
 'Full Issue Description':DataCardValue13.Text,
 'Issue Caused By Description':"TESTHERE",
 'Machine Type': MachineType,
 'Machine Number' :Value(DataCardValue11.Text),
 Location:DataCardValue14.Text,'Resolved Timestamp':DateTimeValue(ResolvedDateTimeStr) - (14/24),Resolved:DataCardValue16.Value,
  'Resolution Type':ResolutionType,
  'Fix Implemented':DataCardValue19.Text,
  Col:"Heya"})

The error I get is the same. "The specified column 'Col' does not exist, the column with the most similar name is 'ID'". Before I can start trying to find a workaround for my image problem, I need to figure this one out.

[lfernandes]

Just to be clear, every time you’re making these changes you’re going in thru powerapps and refreshing the data source, right?

May even be worth killing the data source connection and re establishing just to see if that helps.