Power Platform Community Forum Thread Details

Hello,

We are working with the SharePoint Send HTTP Request flow action in order to search documents in SharePoint.

We are trying to filter the data by Rank Score (it is one of the Key Value returning from Sharepoint API), since some documents have minus number in the value, but no success. Below are the screenshots of our current Uri and example of output.

Do you have any idea for how to filter?

"Cells": [
{
"Key": "UniqueId",
"Value": "AAAAA",
"ValueType": "Edm.String"
},
{
"Key": "Title",
"Value": "AAAAA.pptx"
"ValueType": "Edm.String"
},
{
"Key": "OriginalPath",
"Value": "https://AAAAA.com",
"ValueType": "Edm.String"
},
{
"Key": "Filename",
"Value": "AAAAA.pptx",
"ValueType": "Edm.String"
},
{
"Key": "LastModifiedTime",
"Value": "YYYY-MM-DD",
"ValueType": "Edm.DateTime"
},
{
"Key": "PictureThumbnailURL",
"Value": null,
"ValueType": "Null"
},
{
"Key": "QueryModification",
"Value": null,
"ValueType": "Null"
},
{
"Key": "HitHighlightedSummary",
"Value": "AAAAA AAAAA",
"ValueType": "Edm.String"
},
{
"Key": "FileExtension",
"Value": "pptx",
"ValueType": "Edm.String"
},
{
"Key": "Rank",
"Value": "995.9088411",
"ValueType": "Edm.Double"
},
{
"Key": "ResultTypeIdList",
"Value": "0",
"ValueType": "Edm.String"
},
{
"Key": "ResultTypeId",
"Value": "0",
"ValueType": "Edm.String"
},
{
"Key": "RenderTemplateId",
"Value": "AAAAA",
"ValueType": "Edm.String"
},
{
"Key": "piSearchResultId",
"Value": "AAAAA",
"ValueType": "Edm.String"
},
{
"Key": "DocId",
"Value": "12345",
"ValueType": "Edm.Int64"
},
{
"Key": "GeoLocationSource",
"Value": "NAM",
"ValueType": "Edm.String"
},
{
"Key": "SiteId",
"Value": "AAAAA",
"ValueType": "Edm.String"
},
{
"Key": "WebId",
"Value": "AAAAA",
"ValueType": "Edm.String"
},
{
"Key": "contentclass",
"Value": "AAAAA",
"ValueType": "Edm.String"
},
{
"Key": "IsExternalContent",
"Value": "false",
"ValueType": "Edm.Boolean"
},
{
"Key": "ListId",
"Value": "AAAAA",
"ValueType": "Edm.String"
},
{
"Key": "PartitionId",
"Value": null,
"ValueType": "Null"
},
{
"Key": "UrlZone",
"Value": "0",
"ValueType": "Edm.Int64"
},
{
"Key": "Culture",
"Value": null,
"ValueType": "Null"
},
{
"Key": "DocumentSignature",
"Value": "AAAAA",
"ValueType": "Edm.String"
},
{
"Key": "fcocount",
"Value": null,
"ValueType": "Null"
},
{
"Key": "CollapsingStatus",
"Value": "0",
"ValueType": "Edm.Int32"
}
]
},