PowerApp to Search SharePoint Document Library Content - Part #2

Steps in Miscrosoft Flow:

1) Initialize SearchText Variable

2) Send HTTP Request to SharePoint

Accept: application/json; odata=nometadata

ListID: c0d8f420-0176-495a-822d-9163065d0727
_api/search/query?querytext='@{variables('searchText')}+and+ListId:c0d8f420-0176-495a-822d-9163065d0727'&selectproperties='ListItemID,Title,Path'&RowLimit=500&clienttype='ContentSearchRegular'


3) Parse JSON
{
"type": "object",
"properties": {
"odata.metadata": {
"type": "string"
},
"ElapsedTime": {
"type": "integer"
},
"PrimaryQueryResult": {
"type": "object",
"properties": {
"CustomResults": {
"type": "array"
},
"QueryId": {
"type": "string"
},
"QueryRuleId": {
"type": "string"
},
"RefinementResults": {},
"RelevantResults": {
"type": "object",
"properties": {
"GroupTemplateId": {},
"ItemTemplateId": {},
"ResultTitle": {},
"ResultTitleUrl": {},
"RowCount": {
"type": "integer"
},
"Table": {
"type": "object",
"properties": {
"Rows": {
"type": "array",
"items": {
"type": "object",
"properties": {
"Cells": {
"type": "array",
"items": {
"type": "object",
"properties": {
"Key": {
"type": [
"string",
"null"
]
},
"Value": {
"type": [
"string",
"null"
]
},
"ValueType": {
"type": [
"string",
"null"
]
}
},
"required": [
"Key",
"Value",
"ValueType"
]
}
}
},
"required": [
"Cells"
]
}
}
}
},
"TotalRows": {
"type": "integer"
},
"TotalRowsIncludingDuplicates": {
"type": "integer"
}
}
},
"SpecialTermResults": {}
}
}
}
}

4) Select

Title : item()?['Cells'][3]['Value']
Path: 4
ID: 2

5) Response
{
"type": "array",
"items": {
"type": "object",
"properties": {
"Title": {
"type": "string"
},
"Path": {
"type": "string"
},
"ID": {
"type": "string"
}
},
"required": [
"Title",
"Path",
"ID"
]
}
}


Related Videos:

Part #1    • PowerApp to Search SharePoint Documen...  
Part #3    • Power App to Search SharePoint Docume...