Issue Fetching Filtered OData from Elastic Table

Applies to Product - Power Platform Administration

What’s happening?
Failing to retrieve records using OData Filter when any value is added post "%".
 

Reason:
This has been identified as a bug related to filtering on elastic tables when any value is passed after "%".
 

Resolution:

• Ensure that OData filter expressions are correctly formatted. Use comparison operators (eq, ne, gt, ge, lt, le), logical operators (and, or, not), and grouping operators (()).
• Utilize the advanced options in the List rows action to set parameters such as filter rows, select columns, sort by, and expand query to narrow down the data retrieved.
• If more than 5000 rows need to be retrieved, implement pagination.
• If necessary, convert FetchXML to OData Filter, as FetchXML does not work with elastic tables.
• Follow best practices to optimize performance when retrieving data using OData, including selecting only necessary columns and using efficient filter expressions.