Referencing a column inside of an expression without dynamic content

[odOnCeox]

Hi,

I've been trying to reference a column inside an expression, but I can't seem to be able to do so. Is there any for me to actually do this without using dynamic content? I am using the expression as part of an OData filter for a Get Lists Dataverse action, so I cannot use the dynamic content at this stage of the flow, and I would prefer to keep this condition inside of the OData filter for efficiency. In an ideal world, the formula would look like this:

Where createdon references the column with logical name createdon

I need to translate the createdon column into date only, so that it can be compared to another date only value I have, as such:

Thanks!

[abm]

Hi @odOnCeox 

Unfortunately you won't be able to format the column name on left hand side as expression. ODATA query expects the schema name (column name) on the left hand side. Only way to do is add a Filter action step after so that you can format the values on both sides.

Thanks

[abm]

Hi @odOnCeox 

Having another thought may be you could use the contains() ODATA Query. Worth a try and see if that works or not.

Thanks

[odOnCeox]

Instead of trying to use some convoluted workaround, I just used a lt and ge operator to constrain the time instead - checking if the time is over the whole day, bypassing the need to get rid of the time element.

[odOnCeox · Accepted solution]

Instead of trying to use some convoluted workaround, I just used a lt and ge operator to constrain the time instead - checking if the time is over the whole day, bypassing the need to get rid of the time element.