Power Platform Community Forum Thread Details

Dear,

I am new to power automate and currently trying to automatically append data from an e-mail attachment into a pre-existing table. To do so, I use the list rows in table function for Excel and try to use the Filter Query to only retrieve the rows that have value "NN Leven" and "NN Schade" from variable "Security_Description" as I do not need the additional data. If I use the "or" operator it does not seem to work (see picture for original input & flow).

I use the following parameters:

{
"source": "groups/9a7bef92-f86b-4192-9e72-e4d29fb5c585",
"drive": "b!WwDhqPimKUGMEBp73bm9XmBj1dOnK-1JnJ4cbUp-Ytr5-p_vQNTUT5OxPSwxGxBC",
"file": "%252fShared%2bDocuments%252fGeneral%252fPower%2bAutomate%252fE-mail%2bMark-to-market%2bValue%252fNNIF%2bCollateral%2breport-20240830.xlsx",
"table": "{05FF3C92-CE95-4315-AC3E-ED60CCADC26C}",
"$filter": "Security_Description eq 'NN Leven' or (Security_Description eq 'NN Schade')"
}

I get the following error:

{
"status": 400,
"message": "Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported.\r\nclientRequestId: 8fb40e6e-5e1a-411c-b4b2-c3662bba5aee\r\nserviceRequestId: 0ada95a0-9c5b-47a1-9acb-9c69b14faca6;ef0e58cc-b10c-445d-9e38-aba9fc6a9787;5987edd4-6529-4fea-8366-e3a78fe05a9b;87fd271b-239a-483e-a324-1e8ead4b56e0",
"error": {
"message": "Invalid filter clause: unsupported operation. Only single 'eq', 'ne', 'contains', 'startswith' or 'endswith' is currently supported."
},
"source": "excelonline-we.azconn-we-003.p.azurewebsites.net"
}

Does anybody know how to filter for two values of the same variable? Thank you in advance.

KR,

Bram