cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WeAllStardust
Helper I
Helper I

Removing Null error for gallery

Hi,

 

I have a 6 galleries with 1 item each looking at an excel database. There is a textbox that is used as a filter for the gallery. However when the text box is blank (No value), I get this error "The requested operation is invalid. Server Response: MasterTable failed: Expression "TorqueValue eq null" is not supported. clientRequestId: 93051f5c-52ea-46df-ab31". The galleries have this formula on the Items property "Filter(MasterTable, TorqueValue = Value(txtNameFilter.Text))"

 

Any idea on how to ignore this error or disabling it? 

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

Hi @WeAllStardust 

Something along the lines of this might remove the error:

Filter(MasterTable, 
       TorqueValue = Coalesce(Value(txtNameFilter.Text), TorqueValue)
)

 

View solution in original post

2 REPLIES 2
timl
Super User
Super User

Hi @WeAllStardust 

Something along the lines of this might remove the error:

Filter(MasterTable, 
       TorqueValue = Coalesce(Value(txtNameFilter.Text), TorqueValue)
)

 

That worked when I removed the ", TorqueValue" part of it. Thanks. I didn't know about the Coalesce function. 

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (2,041)