The Search List command will show a list of items based on a search of a List. This Search allows the user to enter search text in the Bot. This is done by putting the placeholder '{SearchText}' in the Filter Text. What the user types into the Bot will replace the {SearchText} placeholder in the Filter Text when running the Search.
For the top six entries, which are common to all Commands, see the Bot Command Overview. The last six entries are described in the List view section of this manual. For the other entries, which are specific to this Command, see below.
Site: Select the Site where the List that will be searched is located.
List: Select the List that will be searched.
Filter Text: Enter text (query) to search the List. The Search allows the user to enter text in the Bot and that text is used in the Search. This is done by putting the placeholder '{SearchText}' in the Filter Text search. What the user types into the Bot will be used in the Search. For details on the exact syntax to use, contact Crow Canyon Support. The syntax uses the Graph API Query Parameters. See this web site for guidance: https://docs.microsoft.com/en-us/graph/query-parameters
Examples:
Search a field (where Title is the column name):
fields/Title eq '{SearchText}'
Contains Query:
substringof('{SearchText}', fields/Title)
Multiple conditions::
substringof('{SearchText}', fields/Title) and (fields/Priority1 eq 'Normal' or fields/Priority1 eq 'high')
Note that multiline lines of text columns are not supported by Graph. SP search can be used in that case.
Prompt Text: The text that the user will see when running this Command.
