Unanswered

Search Function not working

(0) Share

Report

Posted on by JasonLowery93

Hello,

I am new to using power apps and having some issues with getting the Search Function to work. I can see the data from the table I imported, but as soon as I enter the formula, everything goes away and I get errors.

This is for some new hire orders I am trying to search through by their name. I am using the formula Search(Orders, TextBox1.Text, "Name"). This should pull the data from the Orders table, using the text from the textbox I am using, and should search in the column Name.

This is the error I am getting with the Search Function:

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Ash13 576 on at

Like (1)

Report

Hi @JasonLowery93

Try using TextBox1.Value

The Teams version of some controls are slightly different to standard Power Apps controls, just to be confusing 😂

Was this reply helpful? Yes No
JasonLowery93 8 on at

Like (0)

Report

Thanks for the input, but looks like it still doesn't work.

Was this reply helpful? Yes No
Verified answer

Ash13 576 on at

Like (0)

Report

Ah yes, when working with dataverse, sometimes you will need to use the column's 'Logical name'. If you go to the data table and edit the column, you can see this name, like in this example:

Was this reply helpful? Yes No
JasonLowery93 8 on at

Like (1)

Report

You are a great human being! That worked. Thank you soooooo much!!!!!!!
Search(Orders, TextBox1.Value, logical name)

Was this reply helpful? Yes No