You’re offline. This is a read only version of the page.
84
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!
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.
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
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
Share
Report
All responses (
Answers (
