Gallery filter only works when not delegated

(0) Share

Report

Posted on by josefschwurbel

Hi,

I'm currently running into an issue regarding showing records in a gallery that are filtered from a Dataverse table.

What I'm trying to do is show all records from that table where a property equals the current users email address:

Filter(Enrolments, User().Email = session.trainer1.email)

I found that when I prevent PowerApps from delegating this Filter() by using a function such as Lower() on both sides of the comparison, the query is performed and the correct results are returned as expected.

This works for now, but since I expect the table to grow in the future, I would like to find a way of making this query work with delegation. Is there some way for me to achieve this?

Thank you in advance.

Categories:

Building Power Apps

I have the same question (0)