The specified column does not exist

(1) Share

Report

Posted on by petewalburn

157

Hi,

I am receiving the error:

"The specified column 'ApproveComments' does not exist. The column with the most similar name is 'ClosureComments'."

The data source is a SharePoint list and it used to have a column named 'ApproveComments', but this has now been deleted as it is not needed. It is not reference anywhere in the app.

I do set a variable to be the current record:

Set(_recMOC,LookUp('SharePoint list',number=galRegister.Selected.number));

This variable '_recMOC' does have the 'ApproveComments' in it even though it is not in the SharePoint list.

The error appears in a Patch Command:

If(_statusToSave<>"Approved",
    Patch('SharePoint list',_recMOC,
        {
            status:_statusToSave
        }
    )
);

For some reason the '_recMOC' variable does not seem to be the same as the SharePoint list.

Pete

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

petewalburn 157 on at

Like (0)

Report

I'm sure I could get around the error by adding the 'ApproveComments' column to the SharePoint list, but it is not referenced anywhere in the app. And I would rather not have unused columns in the SharePoint list if I don't need them.

Pete

Was this reply helpful? Yes No
Verified answer

MS.Ragavendar 5,009 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

This issue happens because the _recMOC variable was created before the ApproveComments column was deleted. Since Power Apps caches data, the variable still holds a reference to the old schema, causing the error during the Patch operation.

Before setting _recMOC, refresh the data source to ensure Power Apps is using the latest schema

Refresh('SharePoint list');
Set(_recMOC, Blank()); // Clear old data
Set(_recMOC, LookUp('SharePoint list', number = galRegister.Selected.number));

If(_statusToSave <> "Approved",
Patch('SharePoint list', _recMOC, {status: _statusToSave})
);

After applying these fixes, save, publish, and reload the app to fully remove cached schema references

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No
petewalburn 157 on at

Like (0)

Report

Thanks MSR@08012015,

I was refreshing the SharePoint list, and setting the _recMOC variable to Blank() and then setting it using LookUp and was still getting the error. However, it has now resolved itself.

So, I guess it was still cached and causing a problem.

Pete

Was this reply helpful? Yes No