I want to get specific records from a custom entity using the Common Data Service "get records" component
In my "filter" field, i'm entering :
new_countrycode eq '@{body('SelectAccount_Country')?['new_code']}' AND ( startswith(new_postalcode,'@{body('SelectedAccount')?['address1_postalcode']}') eq true OR new_postalcode eq null)
The idea is to get all the records with the right countrycode, and with either no postalcode, or a postalcode starting with a specific string.
But my filter syntax is wrong, and I don't know how to fix it. Could someone tell me what I'm doing wrong plz?