Hi
I have a column in an SP list that is set to text, but holds date values, and I need to filter that column to get any items from the last week, however it is returning all sorts of items instead. Are there anyways to do this as my current option doesnt seem to work. Below is my current Filters:
I am setting a variable to get the date 1 week ago:
I then filter on the GetItems:
PageStatus eq 'Fully Approved' and FinanceApproverApprovedDate ge@{variables('var_DateFilter')} ' and field_1 eq 'TEST'
Here is the list of differences in the filter query syntax:
1. There was no blank space between ge and variable.
2. The variable was not wrapped inside single quotes.
3. There was extra blank space before the end single quote in the variable expression.
I have highlighted the diffrecensc in red color:
PageStatus eq 'Fully Approved' and FinanceApproverApprovedDate ge@{variables('var_DateFilter')} ' and field_1 eq 'TEST'
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
Works perfectly, thank you! Although it looks identical to mine, whats the difference?
Hi @lalford09
Pls try the below filter query:
PageStatus eq 'Fully Approved' and FinanceApproverApprovedDate ge @'{variables('var_DateFilter')}' and field_1 eq 'TEST'
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.