Unanswered

Flow Failing on Get items - Column Doesn't Exist

(0) Share

Report

Posted on by dgillespie

We are creating a flow that will look at column data in a SP list and send a reminder email if the date is less than or equal to. The problem is we are getting a "column doesn't exist" error except when it looks up the Modified column. I don't think we are using the correct syntax (like using " or ') when telling it the column. What is the correct syntax we need in the Filter Query field?

Here is the flow:

Here is the column from SP:

Here is the error:

Thanks for the help!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

efialttes 14,756 on at

Like (3)

Report
Copy link

Link copied!

Hi!
I would recommend you to verify your flow "Run history", select any of the flow executions and inspect the outputs from "Get items" action block.
Sometimes the internal name for a SP column does not match with the one you can see in the SP config page
Hope it helps

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @dgillespie,

I have made a test on my side and don’t have the issue that you mentioned. Besides, I think it is not necessary to add a “Compose” action to calculate the current time. Please take a try with the following workaround:

The flow works successfully as below:

Please check if you have selected proper Site Address and List Name in “Get Items” action.

Best regards,

Kris

Was this reply helpful? Yes No
MyendeS 3 on at

Like (0)

Report
Copy link

Link copied!

This recommendation is correct. I had the same issue has the above question. Checking my run history revealed that my column was named differently. I think it was caused by the fact that I had added a space in my column name and it added "filler text" to ensure the actual column name property is a single string.

Was this reply helpful? Yes No