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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (2,974)