Gallery and Search Filter - Delegation Solution Works Until ID_Copy Number 4000 Related to Sharepoint List Records

(0) Share

Report

Posted on by WendeReisss

253

Hi guys!

I need help with the problem below:

I had a delegation issue that I've solved partially using the follow formula below with Collection and Filter:

ClearCollect(colInboundListSharepoint, Filter(InboundListSharepoint, ID_Foreign >=1 && ID_Foreign <= 2000), Filter(InboundListSharepoint, ID_Foreign >2000 && ID_Foreign <= 4000))

Up to the formula above, everything works fine.

=========================================================================
My problem is:

I need to get records from Sharepoint list records over 4000, but when I try to add to ID_Foreign Column (number) from 4000 to 6000, the gallery doesn't count this aditional records.

ClearCollect(colInboundListSharepoint, Filter(InboundListSharepoint, ID_Foreign >=1 && ID_Foreign <= 2000), Collect(colInboundListSharepoint, Filter(InboundListSharepoint, ID_Foreign >2000 && ID_Foreign <= 4000); Collect(colInboundListSharepoint, Filter(InboundListSharepoint, ID_Foreign > 4000 && ID_Foreign <= 6000))

============================================================================

My Gallery formula is:
(see number 2 in picture attached)

With(
{
wFilter: Sort(
Filter(
colInboundList,
Status_Fluxo = "1-Recebimento" || Status_Fluxo = "5-Concluído" || Status_Fluxo = "6-Retorno Tubing" || Status_Fluxo = "0-PCR" || Status_Fluxo = "2-Inspeção" || Status_Fluxo = "4-Armazenagem" || Status_Fluxo = "7-Retorno Correção" || Status_Fluxo = "3-MES"
),
Fim_Processo_Armazenagem_,
SortOrder.Descending
)
},
Search(
wFilter,
SearchTextInput_RelGeral.Text,
"PO_Item0",
"PartNumber",
"Status_Fluxo",
"QN_QualityNotification",
"Processo",
"Operador_PCR",
"Operador_Recebimento",
"Operador_Inspecao",
"Operador_Armazenagem",
"ZPP3_Order",
"Status_FIFO_Inspecao"

)
)

// the information in my gallery formula above is my Sharepoint List Column, but doesn't have the column "ID_Foreign" cause this type of column is number type and all others is text type , but the formula above doesn't have issue. It works. The name "SearchTextInput_RelGeral.Text" (see number 1 in picture attached) in my gallery formula above is related to the name of my Search filter (Text Input). This Search Text Input was working when I was searching information in it until ID_Foreing in my collection until 4000 records, but above it, from 4000 to 6000 records neither gallery gets more information neither Search Filter "SearchTextInput_RelGeral.Text" can found more records in my gallery.

My Sharepoint list has columns typ text, number, date time, Single Line Text and Multiple Lines Text.

@LaurensM @WarrenBelz

Categories:

Building Power Apps

1_Search Text Inp...

I have the same question (0)

All responses (16)

Answers (1)

Scott_Parker 1,090 on at

Like (0)

Report

I would recommend doing further testing to see what the precise limit is that you're encountering. It might be a limitation with the Search() function over a very large collection. I'm guessing since you have a multiple lines of text field which could hold a lot of data.

I was able to get a 5000+ collection to filtered using Search() in the same way that you are doing, but I have less data in the collection overall. Tentatively, it isn't a hard row limit.

Was this reply helpful? Yes No
WarrenBelz 153,123 Most Valuable Professional on at

Like (0)

Report

Hi @WendeReisss ,

The output of the With() function is still limited to 2,000 items, so what you are doing is not going to work on the entire data set.

Was this reply helpful? Yes No
WendeReisss 253 on at

Like (0)

Report

Is there another alternative? is it a limit to search field?

Is there a way to get just the last 2000 records?

I've deleted some ID related to somw Sharepoint list items. Is it cause some trouble too?

Was this reply helpful? Yes No
WarrenBelz 153,123 Most Valuable Professional on at

Like (0)

Report

Hi @WendeReisss ,

Is colInboundList a collection or a SharePoint List ? If a collection, you do not need the With() statement, just filter it normally.

Was this reply helpful? Yes No
WendeReisss 253 on at

Like (0)

Report

"Colinbound" is a collection related to Sharepoint List called "InboundList".

I didn't link the Sharepoint list directly to gallery. I've created a collection linked to it.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,123 Most Valuable Professional on at

Like (2)

Report

@WendeReisss ,

In that case you do not need the With() statement as this is actually counter-productive and reduces your data set to 2,000. Just Search the collection directly.

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
WendeReisss 253 on at

Like (0)

Report

I've try to get my computer today and use the app as your instruction. I frenquently see your site and your post here, so I'll accept this answer @WarrenBelz . Have a nice day!

Was this reply helpful? Yes No
Scott_Parker 1,090 on at

Like (0)

Report
@WarrenBelz wrote:
@WendeReisss ,
In that case you do not need the With() statement as this is actually counter-productive and reduces your data set to 2,000. Just Search the collection directly.
@WarrenBelz
This isn't true, With() does not limit you to 2,000 records. For example, here is an image where I have a collection name MoreThan5000 with 5000+ records. It gets the values from a With().

Gallery.Items = With({AddTextIndex: AddColumns(MoreThan5000, "ItemText", Text(_ID))}, Search(AddTextIndex, txtSearch5000Col.Text, "ItemText"))

Example search results:

Input in search field No input in search field

Was this reply helpful? Yes No
WendeReisss 253 on at

Like (0)

Report

@WarrenBelz
I took off the "With", but my formula didn't work. The details in red below is the error that appears in the formula without "With". I've put the picture attached showing the formula.

Sort(
Filter(
colInboundList,
Status_Fluxo = "1-Recebimento" || Status_Fluxo = "5-Concluído" || Status_Fluxo = "6-Retorno Tubing" || Status_Fluxo = "0-PCR" || Status_Fluxo = "2-Inspeção" || Status_Fluxo = "4-Armazenagem" || Status_Fluxo = "7-Retorno Correção" || Status_Fluxo = "3-MES"
),
Fim_Processo_Armazenagem_,
SortOrder.Descending
)),

Search(

SearchTextInput_RelGeral.Text,
"PO_Item0",
"PartNumber",
"Status_Fluxo",
"QN_QualityNotification",
"Processo",
"Operador_PCR",
"Operador_Recebimento",
"Operador_Inspecao",
"Operador_Armazenagem",
"ZPP3_Order",
"Status_FIFO_Inspecao"

)

Formula without W...

Was this reply helpful? Yes No
WendeReisss 253 on at

Like (0)

Report

I've put "Search in the begin of the formula and it work as your solution above @WarrenBelz .
But I had to took of Sort function that sort by ID number. Do you know in what part of the formula can I use Sort to sort ID Sharepoint column by Descending?

The formula below has been worked as @WarrenBelz , but I need this formula sort by ID number column.

Search(
Filter(
colInboundList,
Status_Fluxo = "1-Recebimento" || Status_Fluxo = "5-Concluído" || Status_Fluxo = "6-Retorno Tubing" || Status_Fluxo = "0-PCR" || Status_Fluxo = "2-Inspeção" || Status_Fluxo = "4-Armazenagem" || Status_Fluxo = "7-Retorno Correção" || Status_Fluxo = "3-MES"
),

SearchTextInput_RelGeral.Text,
"PO_Item0",
"PartNumber",
"Status_Fluxo",
"QN_QualityNotification",
"Processo",
"Operador_PCR",
"Operador_Recebimento",
"Operador_Inspecao",
"Operador_Armazenagem",
"ZPP3_Order",
"Status_FIFO_Inspecao"

)

Was this reply helpful? Yes No