Automation Error: “Invalid filter value: [‘P454’ ]” when filtering on Lookup / Formula field

Question

Hi everyone,I’m facing an issue with an Airtable automation and would appreciate some help.In my automation, I’m trying to Find records whereProject Number  contain  Project Number fxBoth the values are sameIt give error:-  Invalid filter on Project Number (Invalid filter value: [ "P454" ])Could you please the solution for it.

TheTimeSavingCo · Answer

Could you provide some screenshots of your table and automation setup please?

---

The issue is probably due to the value you’re using being an array and you need it to be a string. As a quick workaround, you could try either of these and I’ve set up an example base here for you to check out

Using a Run a Script action to convert from an array into a string
```
output.set('projectName', input.config().projectName[0])
```
Using a Generate Text step. This’ll cost AI credits tho, so if you’re worried about that you’ll want to use a script instead

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded