Share
Report
90Hello,
I have got an Expression that is essentially a lookup function, which references an Excel sheet for the value in cell x.
This value in cell will either be A, B, or C. If it is A, the result should be the A's group ID, as defined by URL. If it is B, it uses B's Group ID. Same with C.
Expression is here.
if(equals(outputs('Get_a_row_2')?['body']?['Teams Channel'],'Multi-Asset'),'7eb9d698-8dd0-4e45-8641-204cc303c384&',if(equals(outputs('Get_a_row_2')?['body']?['Teams Channel'],'Multi-Asset_Active_Fixed'),'ba7d94ce-2d66-41e1-8606-1bbddb6319ba&',if(equals(outputs('Get_a_row_2')?['body']?['Teams Channel'],'Active_Fixed_Income'),'80f21151-6883-4c82-abfa-f2c74b567a6a&','')))
This seemingly works correctly, as determined by my output: '7eb9d698-8dd0-4e45-8641-204cc303c384&'
HOWEVER, I get a BadRequest error. If I download the Outputs, it tells me:
{"statusCode":400,"headers":{"Transfer-Encoding":"chunked","Vary":"Accept-Encoding","Strict-Transport-Security":"max-age=31536000","request-id":"f98204d0-22ea-47ab-bc2e-5c4ae46cff5d","client-request-id":"f98204d0-22ea-47ab-bc2e-5c4ae46cff5d","x-ms-ags-diagnostic":"{\"ServerInfo\":{\"DataCenter\":\"West US 2\",\"Slice\":\"E\",\"Ring\":\"1\",\"ScaleUnit\":\"002\",\"RoleInstance\":\"MWH0EPF0004E171\"}}","Link":"<https://developer.microsoft-tst.com/en-us/graph/changes?$filterby=v1.0,Tasks_And_Plans&from=2022-04-01&to=2022-05-01>;rel=\"deprecation\";type=\"text/html\"","Deprecation":"Mon, 25 Apr 2022 23:59:59 GMT","Sunset":"Thu, 25 Apr 2024 23:59:59 GMT","X-ProxyCluster":"eus-000.tasks.osi.office.net","X-OfficeCluster":"eus-000.tasks.osi.office.net","X-Tasks-CorrelationId":"14da8667-5aeb-4260-a62f-99261f063c21","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","x-ms-apihub-obo":"false","Cache-Control":"no-cache","Date":"Fri, 16 Dec 2022 20:41:32 GMT","Content-Type":"application/json","Content-Length":"289"},"body":{"error":{"code":"","message":"Invalid or malformed filter clause.","innerError":{"date":"2022-12-16T20:41:32","request-id":"f98204d0-22ea-47ab-bc2e-5c4ae46cff5d","client-request-id":"f98204d0-22ea-47ab-bc2e-5c4ae46cff5d"}}}}
I believe it has something to do with the "Invalid or malformed filter clause," as I have seen some other users with the same issue.
Well, the filter takes the Value from the List Rows result and says:
@not(contains(variables('Plan Card IDs'), item()?['Task ID']))
'Plan Card IDs' uses a custom array, using Append to Array. To me, this says "[If the task ID is not in the Plan Card IDs array, filter it out so we can work with it.]"
I just can't figure out what the issue is. It seems like my Expression works correctly it seems like my Filter is set up correctly. I tried converting the result from the Table into a String (using substring, start at position 0) to see if the output from the Table was messing it up.
But I am pretty sure it has something to do with my Filter.
Please advise?
Thank you,
-Ryan
All responses (
Answers (
