searching on a gallery.select on a second Datasource

[Thrasymaque]

Hi

I am beginner to powerapps

I am strugging since day with a problem : 

Screen 1 : Text search Box + Gallery1:

Search(Datasource1;TextSearchBox1.Text;"Title";) 

OnSelect Navigate(Screen2)

Screen2 : 2 forms

Form1 : connected to datasource1 Item=Gallery1.Selected 

Form2 : connected to datasource2 Item=Gallery1.Selected 

My problem: Form2 doen't work (it seems it doesn't want to use the Item=BrowseGallery1.Selected)

The 2 Datasources are using the same 1st column name & ID "Title"

Any Idea how to use the Title selected in gallery1 to show info coming from a second datasource ?

Many thanks

BR

Frederic 

[gabibalaban]

Hi @Thrasymaque ,

For the second form use:

item: LookUp(datasource2, foreignkeycolumn=Gallery1.Selected.foreignkeycolumn) 

This will bring you the related record of the selected Gallery1 record from datasource2 as item.

Hope it helps !

[Suchitra1996 · Accepted solution]

@Thrasymaque 

Form1: you can use datasource1 Item=Gallery1.Selected 

Form2: You can use datasource2 Item=Lookup(datasource2 ,Title=Gallery1.Selected.Title)

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

[Thrasymaque]

@gabibalaban @Suchitra1996  guys You rock ! it work : I spent so much time on it 🙂 a big thanks !