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

Filtering excel table using Excel Online connection

I have an app in which a gallery is connected to an excel table(Table1). When I set the gallery Items to Table 1, it shows all my rows perfectly. The intention is to have a text input that will filter rows by a specific column. This has rendered unsuccessful. I've also tried using a drop down or a combobox, using the search or lookup function, but I cannot get anything to produce something.

 

Table name -Table1

Column name - Project Number

Text input - inpProjNumber

 

For the gallery Items - I tried...

Filter(Table1,'Project Number'=inpProjNumber.Text)

Filter(Table1,'Project Number'=inpProjNumber.Text, 'Project Number')

 

I also tried to force the output ...

Filter(Table1,'Project Number'=158778)

 

The options mentioned above say "We didn't find any data".

aarellano_1-1652277732852.png

 

Thanks in advance.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
aarellano
Frequent Visitor

I figured it out.

In the Gallery for Items, I set 

Filter(Table1,'Project Number'=inpProjNumber.Text,"Project Number")

It looks like I was missing the double quotes at the end.

View solution in original post

3 REPLIES 3
Drrickryp
Super User
Super User

@aarellano 

Two questions, how many rows are in your table and is the 'Project Number' a number or text column in Excel? 

There are 300 rows. The Project Number column was initially set to the General category, but I changed it to Text hoping that would do the trick.

aarellano
Frequent Visitor

I figured it out.

In the Gallery for Items, I set 

Filter(Table1,'Project Number'=inpProjNumber.Text,"Project Number")

It looks like I was missing the double quotes at the end.

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,448)