@Vgandi
You are right, it might be useful to specify this part. The link you placed to the YouTube video is also, I would agree, useful, at approx 16:08 in it goes into the key point. Just in case for the quick reference, I will place the key point directly in this post for the quick reference:
Yes, an OData query (specifically, OData Filter Query) would be the best way to do this. The OData Filter Query would be something like this:
getPastTime(3,'day','yyyy-MM-dd')
Basically what above does, is it gets a timestamp 3 days prior to the current time. Then it can be used to compare this date with the current column.
Here is a reference to the getPastTime function (docs.microsoft.com)
Please note that 'yyy-MM-dd' might need to be replaced with whatever format is suited for the specific scenario. Here is reference to the Custom date and time format strings (docs.microsoft.com)
The Odata query then becomes
SomeColumn lt '<<insert expression here>>'
For <<insert expression here>> this part must be done inside the expression (whereas the rest of the query is not an expression).
getPastTime(3,'day','yyyy-MM-dd')
This above part goes inside where it says <<insert expression here>>
Below is a graphic to illustrate this point:
'lt' means less than in this case. I find the following chart here where it says 'filter' very useful (from docs.microsoft.com) - I will also place a part of the chart inline below in case:
lt means less than, le means less than or equal to, gt means greater than, ge means greater than or equal to, eq means equal to, ne means not equal to.
In Power Automate, the 'value' part on the right side should always be surrounded by single quotes. The value does not have to be an expression - but if it is, the expression must be surrounded by single quotes, where these single quotes are actually outside of that expression. If the value is not an expression, the value on right side should still be surrounded by single quotes anyway even if it is not an expression.
Yes, the expression must be surrounded in single quotes - these particular single quotes being placed outside the expression and surrounding it.
The left side (i.e. the Column name in SharePoint for example), on the other hand, should actually not be surrounded by single quotes. Please note that sometimes the column name is not the same as what is seen, sometimes it contains strange things like __x0020__ especially if the original column name had any characters such as space characters, etc. and the true column name may need to be found out by inspecting test SharePoint OData API responses (sometimes they should be issued outside of Power Automate to determine the real column names to filter by) - keep that in mind too.
Check if the above helps as well as a reference of the key point without necessarily having to check the video directly. I did leave this part out before as I was replying quickly and wondered if it might have been enough as a starting point. However now that you mention it, this information may be helpful to have directly spelled out if someone comes across this post, so I include it here now in case.
