Share
Report
84I am building a flow that will take a list of user entered keywords and search for instances of them within a specific field (Description) in a SharePoint list. I have tried a few approaches to try to find the most efficient/speedy way of producing the results. The best approach so far seems to be to:
1) Loop through each keyword to be searched using an Apply to Each
2) In the Apply to Each, Filter the Array (from the SharePoint List) using instances where the Description contains the keyword
3) Write the "hits" to an output table
For #3 - I have tried to find the fastest way to have this part executed as it takes the longest processing time in the flow. I tried writing to an HTML table and tried writing to another SharePoint list. The list approach was twice as fast, but I am wondering if there is another option that's better. Once the # of keywords being searched increases and the # of records being scanned increases, the time required will grow quite a bit. So it's important that I optimize this process.
Appreciate ideas here! Also, if there is a better general approach to searching than please do let me know. Thanks!
All responses (
Answers (
