I have a function where I lookup an email and compare it to the same email address in an Excel Table (to return other information from the table) Gallery4 in my app returns the email address from Office365Users and Gallery1 returns records from a Table in Excel. Although the Gallery1 returns the names from the Excel table, I get a "The requested operation is invalid. Server Response: Table1 failed: Expression is not supported." error in my Powerapp. See screenshot attached.
Your kind assistance with this error would be appreciated.