I have tried to URL encode my URL. In Power Automate Desktop The URL value is presently evaluated as:
https://api.airtable.com/v0/appKJvw9LuKiqGcRt/tbl7MUhoqb9r5hk6V?filterByFormula={Root}=Can't Process: Missing Acct #
where Root is the name of a field.
In Power Automate Desktop, I am am getting an invalid filter by formula error.
Am I missing quotation marks?
I think the formula might need to look like this:
%7BRoot%7D%3DCan't+Process%3A+Missing+Acct+%23
And so the full URL would be:
https://api.airtable.com/v0/appKJvw9LuKiqGcRt/tbl7MUhoqb9r5hk6V?filterByFormula=%7BRoot%7D%3DCan't+Process%3A+Missing+Acct+%23Try using Airtable's API encoder to help: https://codepen.io/airtable/full/MeXqOg
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.