cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Milesjustmiles
Level: Powered On

Linking Two Seperate Excel Galleries

Hi everyone,

 

So, definitely new at this, and the app I'm building requires one excel sheet to work as a home screen, and the other excel sheet to filter based on the selection of the first one.

 

Basically, sheet 1 is just a list of locations and sheet 2 is every property in that location. This has probably been asked 50,000 times, but I can't for the life of me figure it out.

 

Thank you guys in advance!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Linking Two Seperate Excel Galleries

Hi, try this and let me know if it doesn't work: 

 

SortByColumns(Search(Filter(FULL_LIST, DISTRICT = Gallery1.Selected.DISTRICT),TextSearchBox1.Text,"ADDRESS","DESCRIPTION","DISTRICT"),"ADDRESS",If(SortDescending1,Descending, Ascending))

 

You need to combine Sort, Search, and Filter all into one expression and not have them separate. 

View solution in original post

Community Support Team
Community Support Team

Re: Linking Two Seperate Excel Galleries

Hi @Milesjustmiles ,

 

Please try the formula that @PowerAddict provided, this should work.

 

Regards,

Mona

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Linking Two Seperate Excel Galleries

Hi, try this and let me know if it doesn't work: 

 

SortByColumns(Search(Filter(FULL_LIST, DISTRICT = Gallery1.Selected.DISTRICT),TextSearchBox1.Text,"ADDRESS","DESCRIPTION","DISTRICT"),"ADDRESS",If(SortDescending1,Descending, Ascending))

 

You need to combine Sort, Search, and Filter all into one expression and not have them separate. 

View solution in original post

Community Support Team
Community Support Team

Re: Linking Two Seperate Excel Galleries

Hi @Milesjustmiles ,

 

Please try the formula that @PowerAddict provided, this should work.

 

Regards,

Mona

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Milesjustmiles
Level: Powered On

Re: Linking Two Seperate Excel Galleries

You're amazing! Right in front of my face!

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,046)