Share
ReportIm bringing in a table from sharepoint and I can display a table of the information I need. Id like to apply a filter to refine the results, but I cannot get the syntax correct.
I can see the parameter is the build table section. In the Get Items filter not only can it not be found, but I cant seem to input an argument that works properly no matter what I try.
Im looking to Filter the "Status" Column to ignore "Closed" items for example. 0 being New, 1 Being In Process, 2 Being Closed. I've tried a bunch of things XYZ eq 1 etc. There are available items for all cases, 1 2 or 3 in the raw data.
The expression "Status#Id/Value eq '2'" is not valid. Creating query failed.
clientRequestId: bacd8514-ee53-4856-8030-7094df86350c
serviceRequestId: e4bb73a1-5005-7000-764f-442f863f8ce9
clientRequestId: bacd8514-ee53-4856-8030-7094df86350c
serviceRequestId: e4bb73a1-5005-7000-764f-442f863f8ce9
This is the information from the unfiltered Get Items"
"Status":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":2,"Value":"Closed"},"Status#Id":2
I can see it in the format table:
It displays properly when unfiltered:
Thanks!
Categories:
I have the same question (0)
All responses (
Answers (
18,138
