Hello everyone! I have an issue with the piece Tables (Find Records). When searching a particular string, it can’t find any record - except it’s definitely there.
The flow has a trigger from a form submission (webhook). After some other pieces, preparing the request, some data should be created in a pipeline in my CRM. Every other piece works fine.
I created a Table in AP to map form name to an ID.
I added a piece, “Tables (Find Records)”, which at the time of writing is at version 0.1.1. I used a filter to find all the records that matches the form name.
This was the data I tested it with:
{
"limit": "1",
"filters": {
"filters": [
{
"field": {
"id": "CLQkEOfVHHsMBDIVljJAN",
"name": "Form name",
"type": "TEXT"
},
"value": "Richiesta informazioni LE 25/26",
"operator": "eq"
}
]
},
"table_id": "tdUUyZNriOCwmE5MFWZdf"
}
And it worked just fine. This is the output:
[
{
"id": "1pNyLLuWtsIQ976LBdNpV",
"created": "2025-07-28T10:33:17.636Z",
"updated": "2025-07-28T10:33:17.631Z",
"cells": {
"CLQkEOfVHHsMBDIVljJAN": {
"fieldName": "Form name",
"updated": "2025-07-28T10:33:21.502Z",
"created": "2025-07-28T10:33:19.410Z",
"value": "Richiesta informazioni LE 25/26"
},
"mnRj9Wmsro3drpI60lfz8": {
"fieldName": "Pipeline ID",
"updated": "2025-07-28T10:33:21.502Z",
"created": "2025-07-28T10:33:19.410Z",
"value": "25"
}
}
}
]
But when the search value becomes “Scarica qui il catalogo Academy 2025/26”, the piece can’t find any records.
{
"limit": "1",
"filters": {
"filters": [
{
"field": {
"id": "CLQkEOfVHHsMBDIVljJAN",
"name": "Form name",
"type": "TEXT"
},
"value": "Scarica qui il catalogo Academy 2025/26",
"operator": "eq"
}
]
},
"table_id": "tdUUyZNriOCwmE5MFWZdf"
}
Output:
[]
And it’s reproducible: I had some submissions from other forms which worked just fine, finding the right pipeline ID, but when I tested that particular form, the output is always a sad empty array ([]).
Things I thought:
- I checked twice that I wrote the exact string in the table. Maybe three times, copy and pasting from the form application or from the run log.
- I tried a slight variation of the form name, updating everything accordingly.
- The string has some non alphanumeric charactecter (some escaping issues with
/)? No, other records in that table has that slash character. - It’s because I’m using equality? I tried with “contains” - nothing changes.
- It’s because I set a limit with 1 record? Tried without limit, no changes.
- Is there a hidden character limit? The failing record is the longest string of the table (39 chars)
Any help is much appreciated.
Ciao!
,