Power Platform Community Forum Thread Details

Reference the image below

If I don't have anything in the ID filter, the gallery should be showing 2 records. The

Filter('Action Items',DueDateOffset<>0)

should return two records and it does until I start building the sort and filter options. I have done this before without issue but now I am stumped and need other eyes that may be able to see where I am failing.

Also, if I select an ID in the filter, it does filter to that ID. However, if I clear the filter it should show all the records (2 records in this case). but it not showing anything.

Occasionally I get an error, but I cannot figure out where it is coming from.

Error when trying to retrieve data from the network: The query is not valid. clientRequestId:

Categories:

Error handling

Building Power Apps

Hi @FW-07051511-0,

Firstly what is you data source type here - assuming SharePoint, then ID should never be blank. Also the Not filter (you have <>) is not Delegable. Assuming DueDateOffset is a Number column, then you can make the filter Delegable by doing this

Filter(
   'Action Items',
   DueDateOffset > 0 || DueDateOffset < 0
)

allowing for possible negative values - you only need the first part if only positive values possible.

If DueDateOffset is a Date column you can do a bit of a hack with this

Filter(
   'Action Items',
   DueDateOffset > Date(2000,1,1)
)

or whatever date is after anything you have.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn