Share
Report
280- The tickets/records are stored, tracked and updated in a SharePoint list called helpdeskTickets.
- The number of tickets is expected to grow to several thousand.
- Title - single line of text column
- Description - Note (multi-line text) column
- ActionsTaken - Note (multi-line text) column
I've seen this done successfully - but only querying single line of text fields via the "Filter Query" attribute of the "Get items" action.
First, I tried using "Filter Query" in the "Get items" action with the following..
substringof('[searchTerm]', Title) or substringof('[searchTerm]', Description) or substringof('[searchTerm]', ActionsTaken
PROBLEM: "substringof" does not work on multi-line text (note) columns, and my flow fails
Next... I've attempted to use a "Filter Array" action on the output of "Get items" to cull and return a filtered table/array of items.
Setting "From" to "value" of "Get items" output, I edited the filter in advanced mode and entered...
( contains(coalesce(item()?['Title'], ''), triggerBody()?['text']), contains(coalesce(item()?['Description'], ''), triggerBody()?['text']), contains(coalesce(item()?['ActionsTaken'], ''), triggerBody()?['text']) )
The flow runs successfully, but the "Filter Array" is only outputting the first record found.
I need the flow to return an array/table of all items where the "searchTerm" is contained in "Title", "Description" or "ActionsTaken". Any and all help is greatly appreciated.
All responses (
Answers (
