Answered

Action 'Get_items' failed because of apparent inexistent Column.

(1) Share

Report

Posted on by V_Tiger

Hi there,

I'm trying to update the value in a specific column of a SharePoint list by using values from two other columns. To do this, I've entered the following expression in the "Filter Query" field of the "Get items" action: "Issuer_x0020_ID eq 44113 and TemplateNumber eq Template_1"
The column names and their corresponding values are correct:

Issuer_x0020_ID equals 44113, matching the variable variables('IssuerID').
TemplateNumber equals Template_1, matching the variable variables("TemplateNumber").

However, I'm encountering an error message: "Column 'Template_1' does not exist. It may have been deleted by another user. clientRequestId: 4f44099d-f8a0-4e0a-b1b3-64b59cfedfb9 serviceRequestId: 1354bea1-c035-7000-dcbf-f2d87593e9e1".

It appears as though Power Automate is confusing the column "TemplateNumber" with the value stored in the variable "TemplateNumber" (i.e., "Template_1").

What changes do I need to make to the expression to resolve this issue?

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Ellis Karim 12,024 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Please share your flow, including the exact expressions used in the Get Items filter query. Is TemplateNumber a text or number column?

I suspect that you may need to wrap the value Template_1 in single quotes:

Issuer_x0020_ID eq 44113 and TemplateNumber eq 'Template_1'

Please also check that you are using the correct "internal" names for the SharePoint columns. See the following: How to Find the Internal Name of a SharePoint Column (Step-by-Step Guide) – Ellis Karim's Blog

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
V_Tiger 29 on at

Like (0)

Report
Copy link

Link copied!
@Ellis Karim - Unfortunately, I'm unable to share the flow due to company policy. To address your first question, TemplateNumber is a text column:

SharePoint List Header screenshot:

Column settings:

Regarding your second point, I am not typing 'Template_1' directly in the Filter Query field, thus, I am unable to apply single quotes to it. Instead, the value corresponds to a variable I had previously initialized within the flow:

First, I initialize the variable:

Then, I extract the 'Template_1' value from a file path using Compose, then I assign it to the "Template Number" variable using the Set Variable action.

Lastly, I have confirmed—using the three methods described in your blog—that the column's internal name is "TemplateNumber":

Method 1: Column Settings

Method 2: Hover-over dynamic content in Power Automate

Below is the error message I'm receiving and the point where the flow is failing:

Was this reply helpful? Yes No
Ellis Karim 12,024 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Please try putting the value Template_1 in single quotes, or use another known value for TemplateNumber:

Issuer_x0020_ID eq 44113 and TemplateNumber eq 'Template_1'

Please let us know the result.

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

Was this reply helpful? Yes No
V_Tiger 29 on at

Like (0)

Report
Copy link

Link copied!

@Ellis Karim - How do I put the value Template_1 in single quotes? As explained previously, it comes from a variable (i.e., this time is 'Template_1' but it could also be 'Template_2' or 'Template_4'). I tried the following expression to add single quotes but received an "Invalid expression" message: concat("'", variables('TemplateNumber'), "'"). Perhaps you know a better way.

Additionally, I've tried changing the name of the variable (e.g., "Template", (PBTNumber), etc.) but I keep getting the same error.

Was this reply helpful? Yes No
Verified answer

Ellis Karim 12,024 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
For testing, simply try:

TemplateNumber eq 'Template_1'

Or simply enter the variable into the query as shown

Ellis Karim
elliskarim.com | LinkedIn | Bluesky
If this solved your issue, please mark it as ✅ Accepted Answer. If it helped, feel free to give it a 🩷 Like!

2 people found this reply helpful.

Was this reply helpful? Yes No