cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Thrasymaque
Frequent Visitor

searching on a gallery.select on a second Datasource

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Suchitra1996
Resolver II
Resolver II

@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.

View solution in original post

3 REPLIES 3
gabibalaban
Dual Super User
Dual Super User

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
Resolver II
Resolver II

@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
Frequent Visitor

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

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (2,549)