Filter not working on a simple selection

(2) Share

Report

Posted on by bdherh

I have a table (Oracle) that I'm trying to filter with a simple date range. It will not work when I do a DateValue() on a text field nor will it do it when I hard code. I tried directly from the table and through a collection. The error is a "network" error which is useless. This is a very simple thing that should be more straightforward. Any suggestions?

There is no network issue, I can change this to select based on a text field and it works fine

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

@bdherh

You can try something like this

Filter('SCHEDULE MASTER', BSC_START >= "2026-01-01" && BSC_START <= "2026-01-05")

or

Create a collection and filter the collection

ClearCollect(
scheduleCollection,
'SCHEDULE MASTER' // or filter by a working text column to limit rows
);

// Then filter from the above collection
ClearCollect(
filteredSchedule,
Filter(scheduleCollection, BSC_START >= Date(2026,1,1) && BSC_START <= Date(2026,1,5))
);

Vishnu WR

LinkedIn - My Tech Space

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 ♥

Was this reply helpful? Yes No
bdherh 96 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you. On the collection, isnt a collection restricted to 500 rows? If the date range is for a month for this table, it will exceed 500.

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(1)

Report
Copy link

Link copied!

@bdherh

Yes. But you can increase it to 2000 in the Power Apps app setting.

The 500–2000 row limit exists because Power Apps can only bring a limited amount of data locally when a query is not fully delegable, to prevent performance issues and avoid overloading the app and data source.

Vishnu WR

LinkedIn - My Tech Space

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 ♥

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

@bdherh,

The power-apps product the issue which you are referring is common everywhere when ever you are dealing with large datasets.

Microsoft till date the haven't upgraded the limit beyond 2000, but from the Power-apps you can set the range from 1 to 2000.

Formula

(Recommendable Approach)

Set(varFrom, Date(2026,1,1)); // You can provide your date or DatePicker Control Value

Set(varTo,   Date(2026,1,5)); //You can provide your date or DatePicker Control Value

With(

    { f: varFrom, t: varTo },

    ClearCollect(

        scheduleCollection,

        Filter(

            'SCHEDULE MASTER',

            BSC_START >= f &&

            BSC_START <= t

        )

    )

);

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
bdherh 96 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you. Just ran this query in Toad for the same date range and there are 239 rows. But getting this on the selection

Was this reply helpful? Yes No
Vish WR 3,748 on at

Like
a
(0)

Report
Copy link

Link copied!

@bdherh

Can you create the collection first and filter it it works, then it's not related to the network. If you have issues creating the collection, then it must be a network issue. Also, do an inspect element and see the network and console for any errors

Was this reply helpful? Yes No
Suggested answer

Haque 3,653 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bdherh

When filtering an Oracle table by a date range in Power Apps, we need to troubleshoot following stuff:

Confirm the Oracle column type is a date/time type, not text.

If it’s text, consider creating a view or query in Oracle that converts the text to a date type.

Use Power Apps filter expressions with date variables of type Date or DateTime.

Use DateValue() only on text fields that are guaranteed to be in a parseable date format.

Test the filter logic directly in Oracle (e.g., via SQL tools) to confirm the date range query works.

Just my doubts: Can you please make sure:

'SCHEDULE MASTER' is the exact name of your data source.

BSC_START is a date/time column in that data source.

The error message "Error when trying to retrieve data from the network" in your PowerApps query suggests a connectivity or data source access issue rather than a pure syntax or logic error in your code.

This kind of error can be caused by: apart from the suggestion by other members, can you please check

Permissions or authentication issues preventing PowerApps from accessing the data.

Timeout or throttling limits on the data source.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
bdherh 96 on at

Like
a
(3)

Report
Copy link

Link copied!

I really dont think it is a network error. I changed it to below and it works fine. It seems to be having issues with the date. It is defined as DATE in an Oracle table.

With(

{ f: varFrom, t: varTo },

ClearCollect(

scheduleCollection,

Filter(

'PRODSHD_PA.SCHEDULE_MASTER',

WORK_CNTR = "C4_BELC"

)

)

);

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

The issue is not a network problem but a delegation and data type mismatch.

Power Apps cannot delegate DateValue() to Oracle when the column is stored as text, which causes the query to fail and return a generic network error.

The best solution is to use a proper DATE/TIMESTAMP column in Oracle or create a database view that converts the text to a date.

As a workaround, you can compare strings only if the date format is consistent (e.g., YYYY-MM-DD).

Was this reply helpful? Yes No
bdherh 96 on at

Like
a
(2)

Report
Copy link

Link copied!

Here is the table definition. I simply want to query based on a begin/end time prompt on my form. Should be simple

Was this reply helpful? Yes No