Trying to filter "List Rows Present in a Table" to only list rows where a column labeled "Date Opened" on the table contains the "Date Triggered" by the manual flow. I keep getting different errors based on how I approach this, if I try without variables (formula: @contains(item()?['Date Opened'], triggerBody()['key-button-date'])) I get this error: One or more fields provided is of type 'Null', a different type is expected. If I try with variables the error states the function is unsupported.
If I try this formula:
contains('Date Opened','10-03-2023')
I get this error: Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported.
clientRequestId: 15b3c0f3-acb9-45aa-bb21-65ea18c8a3e7
Can anyone help me figure out how to filter for "Date Opened" contains "Date" (triggered)?
