Answered

Gallery text filter won't bring matches; will not find matches

(0) Share

Report

Posted on by pennyharris

I've connected an Excel workbook as the data source for a power app Gallery and if I use Items: Master (which is the name of the table), it finds and returns all of the records.

I have set the variable on OnStart of the App like this

and a filter on the Gallery like this:

but it will not return any records that match:

Although I can confirm that the data source and varUserEmail have the same data

Anyone have any idea why I am not getting an error and/or records returned? Thanks in advance, this is driving me crazy.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @pennyharris

Try this in your filter:

Filter( Master, Lower('Direct Manager Email') = Lower(varUserEmail) )

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
pennyharris 4 on at

Like
a
(0)

Report
Copy link

Link copied!

It worked!! Well, it returned a record anyway. No sense as to why? Why did that work? Thank you for your response, at least I know it isn't a connection problem.

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

@pennyharris It worked becuase the datasource and Filter function is case sensitive.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No