I want to search within the files on my SP document library. My flow runs successfully however, it was not returning any value.
For reference, I exactly followed a video tutorial on YouTube and just change the ListID.
PowerApp to Search SharePoint Document Library Content Part #1
https://www.youtube.com/watch?v=Im1tpGFMqX0
Any idea how to resolve this? Thank you
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" ] } }
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
mmbr1606
275
Super User 2025 Season 1