Forum Discussion
Daniel Bonner
Nov 09, 2020Copper Contributor
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...
Daniel Bonner
Nov 09, 2020Copper Contributor
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:
RobElliott
Nov 09, 2020Silver Contributor
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 User
- Daniel BonnerNov 09, 2020Copper Contributor
Getting 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?
- stormin_30Nov 09, 2020MVP
- Daniel BonnerNov 10, 2020Copper Contributor