Forum Discussion

AqilAL270's avatar
AqilAL270
Copper Contributor
Dec 07, 2023

Filter Query Didn't filterting

Hey i have a problem, i have a flow that need to be trigger manually, to trigger the flow i need to input an ID,  the ID that already exists in Excel because this flow is the flow to create an invoice report. Next step I want to filter this Excel file by list rows in present table, to display only values that have the same ID at first input. 

i wrote this in filter query   ID eq 'ID'
'ID' is a dynamic content when i input the id in the first step

but it didn't filtering, the output shows this

{
"statusCode": 200,
"headers": {
"Cache-Control": "no-store, no-cache",
"Pragma": "no-cache",
"Transfer-Encoding": "chunked",
"Vary": "Accept-Encoding",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"x-ms-request-id": "c23cdaec-5885-4ada-847b-e67efc651220;0bf317f2-e0de-4143-aee4-be61bf25af1f;5a92955c-c824-4b6c-989c-4099f3d81545;439a3da3-8e2c-45d5-8eee-20a202221f98;e0066abb-4133-4399-ae2a-3a186dac710d;bb02b5b9-fa50-4192-8630-93f0802f0fc6",
"OData-Version": "4.0",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "false",
"Date": "Thu, 07 Dec 2023 07:37:46 GMT",
"Content-Type": "application/json; odata.metadata=minimal; odata.streaming=true",
"Expires": "-1"
},
"body": {
"@odata.context": "https://excelonline-sea.azconn-sea-001.p.azurewebsites.net/$metadata#drives('b%21349tk68XCUmmcXJZBs3IKs4nlEoNH-lColgLZuCLQjCxHUpBxNk0T4kmYdHOQBxe')/Files('01D4YPE64QDUZVHDBAKNHIZJXG67AT6HHT')/Tables('%7BAAA0FB54-0F90-4053-8D1F-8A48FD060E1F%7D')/items",
"value": []
}
}

 

i dont know what to do, please help

 

 

Resources