- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 06, 2024 01:17 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 08, 2024 01:55 AM - edited ‎Jun 08, 2024 01:56 AM
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+%23
Try using Airtable's API encoder to help: https://codepen.io/airtable/full/MeXqOg
