Fuction Search with more than two databases from excel How can i DO?

[gedas07]

I want to create the search function but I would search more than two databases in excel,
And I don't know how to do it
I have tried
Sortbycolumns (Search ([@ profiles]; [@items]; textsearchbox1.text; "car"; "Department"); "car"; If (sortdescending1; Descending; Ascending))

[eka24]

Under what condition do you want to search both , any if condition. Do the table  have the same columns.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[gedas07]

the two tables have 2 equal columns, the rest of the columns are different. and my searches will be in those two equal columns car and departament and I want search in this columns 

thanks for the help

[eka24]

Searching two datasources at same time may not be feasible. But a workaround based on the two columns as yous stated is:

OnVisible of your screen or OnSelect of a button, create a collection:

ClearCollect(MyTable1,ShowColumns(YourDatasource1,"Cars","Department"));

ClearCollect(MyTable2,ShowColumns(YourDatasource2,"Cars","Department"));

ClearCollect(CombinedTable,MyTable1,MyTable2)

Then Search as:

Filter( CombinedTable, StartsWith( Cars, SearchInput.Text ) ||

StartsWith( Department, SearchInput.Text ))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[gedas07]

Thanks ,

i try this afternoon, but I’m very rookie
In the browse gallery do I have to create the button?

and I have to click it before each search?

[eka24]

If you want to Use a button, then yes. You have to click the button before search.

However you can put it Onvisible of the screen. In that case you don't need any button

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[gedas07]

and as it becomes invisible and self-executing there is a tutorial that I can visualize?

thanks a lot

[eka24]

That is different. Check the OnVisible documentation:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-screen

Implement it an give the feedback

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[gedas07]

hello i am very new to powerapps
I have tried to write the code and I don't even know how to write in two rows, how can I do it?
and my other question, one of my database is called house, where I have to put it in the code, in mytable1 or in yourdatasource1

and in the other what i do to write?

ClearCollect(MyTable1,ShowColumns(YourDatasource1,"Cars","Department"));

[gedas07]

well I understood 

but one question 

when I put this 

ClearCollect(MyTable1,ShowColumns(YourDatasource1,"Cars","Department"))

works perfect 

but when I added this 

ClearCollect(MyTable1,ShowColumns(YourDatasource1,"Cars","Department"));

ClearCollect(MyTable2,ShowColumns(YourDatasource2,"Cars","Department"));

give me an error and

don’t works 
I’m from Spain, in Spain   This ,  is this ; 

maybe this ; is ..........I don’t