Перейти к содержимому

PowerApp to Search SharePoint Document Library Content - Part #2

Adimulam Natarajan

0:00 / 0:00

PowerApp to Search SharePoint Document Library Content - Part #2

4 699 просмотров · 5 лет назад
Adimulam Natarajan
163 подписчика
4 699 просмотров · 5 лет назад
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 Document Lib...   Part #3    • Power App to Search SharePoint Document Li...