search list table textinput

[algepsers]

Hi,

I'm trying to search (using a search bar [text input field]). The source is a list called 'CC project'. The tex tinput field is 'TextInputCicle'. A want to search in a data table in 'CICLE' column. I use a form to complete 'CC project' list.

When I write:

Search('CC project';TextInputCicle.Text;"CICLE")

But none element appear in table when I write a text in 'TextInputCicle'. Text input written exist in 'CC project' list.

Thx.

[WarrenBelz]

Hi @algepsers ,

What is your data source and how many records are in 'CC project' ?

[algepsers]

Hi @WarrenBelz ,

The data source is a list (called CC ' project' ). By the moment 5 records (7 columns).

[WarrenBelz]

@algepsers ,

I meant what data source (Excel/SharePoint/Dataverse) are you using - however assuming SharePoint, you will get a Delegation warning, but this code

Search(
   'CC project';
   TextInputCicle.Text;
   "CICLE"
)

should work assuming CICLE is a Single Line of Text column and you have entered part of one of the record values in TextInputCicle - can you please confirm the column type and data source.

[algepsers]

@WarrenBelz 

I created a microsoft list which is alimented by a customized form. Yes, I get a Delegation warning.

'CICLE' is an option in the customized form. But I'm trying with different columns, for example 'NAME' or 'DESCRIPTION'. In the customized form 'NAME' is line of text and 'DESCRIPTION' is lines of text. But the result is the same, none element appears.

Thx.

[WarrenBelz]

@algepsers ,

By an Option - do you mean a Choice column - if so

Search(
   AddColumns(
      'CC project';
      "CicleText";
      CICLE.Value
   );
   TextInputCicle.Text;
   "CicleText"
)

Please click Accept as solution 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 Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[algepsers]

@WarrenBelz 

None element appears.

As a result I want to appear a complete data table with only the coincidences.

[WarrenBelz]

@algepsers ,

I have absolutely no idea what you meant by the last post - what type of column is CICLE ?

[algepsers]

@WarrenBelz 

The type of columns CICLE is option. For example, there are another columns 'NAME'(line of text), 'DESCRIPTION'(lines of text)...

The main idea I want to achieve in this app is to have different text inputs on a screen for filtering a Microsoft list, and below that, display a data table with the results. I'm mentioning this in case it wasn't clear what I meant earlier.😉

Thx.