Power Platform Community Forum Thread Details

I have a "Helpdesk Tickets" Power App.

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.

Because of the delegation issues, the native Search function in power apps will not work.

OBJECTIVE: Use a PowerAutomate flow to perform a keyword search against every record in helpdeskTickets, returning all items where the keyword/searchTerm is CONTAINED in any of these three columns:

Title - single line of text column
Description - Note (multi-line text) column
ActionsTaken - Note (multi-line text) column

APPROACH IN POWER AUTOMATE:

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.

Categories:

Building flows