Answered

Column name doesn't exist. It may be deleted by another user

(0) Share

Report

Posted on by SCMSAC

Hi, I have a SharePoint list that has a few date columns. They are Actions that are assigned to certain people. I am building a workflow to send a reminder to the assigned person 3 days before the action columns are due. I built some parallel Get Items actions each filtering the Query for the action column I am focusing on. All the queries (get items action 2, 3, and 4 work fine), however the get items action1 doesn't. It gives me an error message saying that the 'Column name doesn't exist. It may be deleted by another user'. All queries were built the same. and I checked the name and it seems to be the correct one... Anyone has any ideas why this one is failing? I am thinking it is because it starts with an underscore?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @SCMSAC,

Yes, that is correct. The leading underscore will be the cause.

That name will probably start with Odata_ instead of the leading underscore.

Try and replace that leading underscore by Odata_ like suggested by @ekarim2020 in his blog post about internal names:

https://elliskarim.com/2021/12/20/finding-the-internal-name-of-a-sharepoint-column/#Error-when-using-the-Internal-Name-:-Column-Name-Does-not-Exist!

In your case try:

OData_x002a_Action_x0020_1_x002d__x00

Was this reply helpful? Yes No
SCMSAC 32 on at

Like (0)

Report

@Expiscornovus
Brilliant! Thank you! Learning everyday!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @Expiscornovus,

I have the same issue but adding 0Data_ did not work. Is there any other ways to fix? Thanks!

Was this reply helpful? Yes No
drvrogo12345 9 on at

Like (0)

Report

If the internal name starts with an underscore character (e.g. _MyColumn), then it should be shown as "OData__MyColumn" (with the letter O, not zero, and two underscores next to each other).

Was this reply helpful? Yes No