Answered

Filtering excel table using Excel Online connection

(0) Share

Report

Posted on by aarellano

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

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@aarellano

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

Was this reply helpful? Yes No
aarellano 28 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

aarellano 28 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No