
I have a custom connector that grabs data from MS Graph Explorer to an Excel spreadsheet for my app. But I get an error every time the app loads using the data with :
The requested operation is invalid. Server Response: Table1 failed: Expression "Email eq null" is not supported. clientRequestId:xxxxx-xxx-xxxx-xxxx-xxxxxxxxx serviceRequestId: xxxxx-xxx-xxxx-xxxx-xxxxxxxxx;xxxxx-xxx-xxxx-xxxx-xxxxxxxxx;xxxxx-xxx-xxxx-xxxx-xxxxxxxxx
The custom connector is not even connected to the app, it's only connected to a flow that starts when the app is accessed. Is there anyway to make this go away?
I found the fix for this from this post: https://powerusers.microsoft.com/t5/Building-Power-Apps/Error-in-App-but-works-in-test/td-p/1215674