Filter One Million Records using Collection in power apps (Canvas Application)

[Rutu1455]

Hello Team,

Is it Possible to filter One million records in 

power apps using collection function or

there is any alternative way to do it.

[Drrickryp]

@Rutu1455 

It is possible but how depends on the data source.

[Rutu1455]

Hello @Drrickryp I am using Snowflake as a data source with SQL ,

Can you please explain that how exactly I should do that because using collection it will take time to load 1 million record at a time. Is there any alternate way which we have?

[Drrickryp]

@Rutu1455 

You can Filter() large data sources like sql directly. A collection is held on the local device memory and is limited to 2k max at a time. The key to working with large data sources is to use delegatable functions that are executed at the server side.