Hello,
I have a Power Automate flow calling a REST API for searching for word(s) in documents in a SharePoint document library.
/_api/search/query?querytext=%27@{triggerBody()['text']}%20path:"https://org.sharepoint.com/sites/SiteName/DocLib*"%27&RowLimit=@{triggerBody()['text_1']}&STARTROW=@{triggerBody()['text_2']}
This works and provides me with the document which contains the word.
I've tired for a long time to be able to count the number of times the word appears in each document, or provide a link to the paragraph where the word appears, but the output I get back from the Send an HTTP request to SharePoint action, only has metadata, I cannot tap into the content of the file.
I've tried using the Get file content action, but the file identifier does not find the content, finds the file, but not the content, so I cannot do a count on number of times a word appeared in the document it provides... do I use another HTTP request, or how do i progress my mind is exhausted
