Forum Discussion
Filter Query Error
Hello I am a newbie at Power Automate and am looking for some help on an error I am getting. I am using GetItems to pull data from a Sharepoint List. This is a list of client contacts which incl...
Hi Daniel Bonner,
Confirm the column name by going into List settings > column > check the URL path for the internal column name ("Field=").
Set the "Get items" action OData filter query to:
<your column name> ge 'addDays(utcNow(), 30, 'yyyy-MM-dd')'
There are single quotes around the expression!
I hope this helps.
Norm
Thank you. I am still getting an error message saying the column name doesn't exist. Here is the url for the column:
I am using '_x0067_rv7' as my field name. Wondering if it's having trouble with the "_" as the first character in the field name perhaps?
Here is the flow:
Daniel Bonner in your filter query you don't type in the addDays expression, you go to the Expression tab of the dynamic content and add it there and click OK and it will add it to the filter query as a pink expression like the one below:
Rob
Los Gallardos
Microsoft Power Automate Community Super UserGetting closer I think but still getting this error:
Here is how I currently have things laid out:
Maybe something with the date formatting? Or maybe due to some blank entries in my list?
