Answered

Search function formula to look words that contain portions of a word within multiple columns

(1) Share

Report

Posted on by nb02187

How do I make this formula work to search for a portion of the word across multiple columns?

SortByColumns(
        Search(
         'CSO Shipments - FAA Tags and Flow Data',(TextInput1_1.Text,'Serial_No','Invoice_MemoNo','DMIR.Value','ID.Value'
              ),
          IsBlank(dpStartDate_1.SelectedDate) || Created >= dpStartDate_1.SelectedDate,
          IsBlank(dpEndDate_1.SelectedDate) || Created <= dpEndDate_1.SelectedDate,
          
          ID,SortOrder.Descending)
         
         

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

WarrenBelz 153,529 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @nb02187,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,529 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi @nb02187,

Somthing like this should do it
SortByColumns( Search( AddColumns( Filter( 'CSO Shipments - FAA Tags and Flow Data', IsBlank(dpStartDate_1.SelectedDate) || Created >= dpStartDate_1.SelectedDate, IsBlank(dpEndDate_1.SelectedDate) || Created <= dpEndDate_1.SelectedDate ), IDTxt, Text(ID), DIMTTxt, DMIR.Value ), TextInput1_1.Text, Serial_No, Invoice_MemoNo, DMIRTxt, IDTxt ), "ID", SortOrder.Descending )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No