Search 3 Sharepoint columns in a single input box

(0) Share

Report

Posted on by Misa

248

Hello all.

I am using a SharePoint list as a datasource. I have 3 columns that I would to merge into one search box. From there it will populate the SharePointForm1 on PowerApps.

I tried using a combobox and inputbox with the following formulas and they are not working. I am using these in the Items properties of the SharePointForm1 and I tried using it as the Items property of the 2 input boxes without success.

Filter(CSSD,StartsWith('ILT Course ID', ComboBox1.SearchText) || StartsWith('VILT Course ID', ComboBox1.SearchText) || StartsWith('Self Paced Course ID', ComboBox1.SearchText)

Search(CSSD, ComboBox1.SearchText,"ILT_x0020_Course_x0020_ID","VILT_x0020_Course_x0020_ID","Self_x0020_Paced_x0020_Course_x0")

I feel like I am missing something and but I can't figure it out.

Any thoughts?

Thank you for your time.

Categories:

Connecting to Data

I have the same question (0)

All responses (3)

Answers (1)

yashag2255 24,695 Super User 2024 Season 1 on at

Like (0)

Report
Re: Search 3 Sharepoint columns in a single input box

Hi @Misa

Can you try to update the expression to:

Search(CSSD, ComboBox1.Selected.ColumnName,"ILT_x0020_Course_x0020_ID","VILT_x0020_Course_x0020_ID","Self_x0020_Paced_x0020_Course_x0")

Here, you need to replace ColumnName with the name of column you want to get from the Combobox items. If this is a static array, you need to use "Value" as the column name.

If the input is a Text Input control, then the expression can be modified to:

Search(CSSD, TextInput1.Text,"ILT_x0020_Course_x0020_ID","VILT_x0020_Course_x0020_ID","Self_x0020_Paced_x0020_Course_x0")

Note: Please make sure that the columns you want to search in are text columns.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

v-monli-msft on at

Like (0)

Report
Re: Search 3 Sharepoint columns in a single input box

Hi @Misa ,

First of all, please confirm what are the column types of 'ILT Course ID','VILT Course ID' and 'Self Paced Course ID'?

You mentioned that you want to use 1 single textinput control to search for 3 SharePoint columns and you are showing the result in Form control. Since Form control shows the details of 1 single record, did you mean that the result of searching will be only 1 item?

If so, assume that your textinput control is named "ComboBox1", these 3 columns are all text fields. Then the Item property of the Form control should be:

LookUp(CSSD,StartsWith('ILT Course ID', ComboBox1.Text) || StartsWith('VILT Course ID', ComboBox1.Text) || StartsWith('Self Paced Course ID', ComboBox1.Text)

Or did you mean Gallery control instead of Form?

Regards,

Mona

Was this reply helpful? Yes No
v-monli-msft on at

Like (0)

Report

Re: Search 3 Sharepoint columns in a single input box

Hi @Misa ,

Have you got time to answer the question in my last reply?

Regards,

Mona

Was this reply helpful? Yes No