Unanswered

Gallery2 loads fine but Gallery1 takes forever to load?

(0) Share

Report

Posted on by Patrick-Stamper

So I am using a "Concurrent(ClearCollect" Formula in the App.OnStart and Gallery2 loads within a sec, Gallery1 takes almost 10 minutes to load? Please see code for the Gallery1.Items. Am I doing something wrong here? It's the same code in Gallery2...

With(
 {
 galData1: Filter(
 colFuelLogEquipList,
 IsBlank(ComboBox2.SelectedItems) || IsEmpty(ComboBox2.SelectedItems) || EquipCatChoices.Value in ComboBox2.SelectedItems.Value
 )
 },
 If(
 Not(IsBlank(Owned_SearchTxtBox.Text)),
 Search(
 galData1,
 Owned_SearchTxtBox.Text,
 "Title",
 "SerialNoVIN"
 ),
 galData1
 )
)

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (0)

Sort by

WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Patrick-Stamper ,

As you are filtering a collection, you do not need to "split" the functions here as Delegation is not an issue (all processing is local). I do not think that is your issue, but try this

Filter( colFuelLogEquipList, ( Len(ComboBox2.Selected.Value) = 0 || EquipCatChoices.Value in ComboBox2.SelectedItems.Value ) && ( IsBlank(Owned_SearchTxtBox.Text) || ( Owned_SearchTxtBox.Text in Title || Owned_SearchTxtBox.Text in SerialNoVIN ) ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Patrick-Stamper 51 on at

Like (0)

Report
Copy link

Link copied!

I got nothing but errors with that formula?

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Patrick-Stamper ,

Just missing a bracket (I thought you might have spotted it) - try now.

Was this reply helpful? Yes No
Patrick-Stamper 51 on at

Like (0)

Report
Copy link

Link copied!

Sorry, didn't catch that. Added the bracket, but gallery still does not load?

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Patrick-Stamper ,

Do you mean no errors, but no data ? Please have a look at the logic as I based it on what you posted.

Was this reply helpful? Yes No
Patrick-Stamper 51 on at

Like (0)

Report
Copy link

Link copied!

Yes, that is correct. I have no errors and it is not showing any data. I am backtracking everything right now to see where there might be a flaw. What would you like to see to narrow down some things?

Was this reply helpful? Yes No
Patrick-Stamper 51 on at

Like (0)

Report
Copy link

Link copied!

Would it be easier to get on a Teams Meeting?

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Patrick-Stamper ,

This logic

Filter( colFuelLogEquipList, ( Len(ComboBox2.Selected.Value) = 0 || EquipCatChoices.Value in ComboBox2.SelectedItems.Value ) && ( IsBlank(Owned_SearchTxtBox.Text) || ( Owned_SearchTxtBox.Text in Title || Owned_SearchTxtBox.Text in SerialNoVIN ) ) )

looks for two things

Either ComboBox2 is blank (all items will be shown) or it will filter on all items selected being in EquipCatChoices AND

Either SearchText is blank (all items will be shown) or the test entered is in Title or SerialNoVIN
If they are both blank, it should show all items, so you need to make sure something is in your collection

NOTE - I will be offline now for some time.

Was this reply helpful? Yes No
Patrick-Stamper 51 on at

Like (0)

Report
Copy link

Link copied!

That is what happened. Some how my entire collection disappeared. Guess I am starting over....😕 Thanks for your help. What would you say is the fastest way to create a collection based off of either submitting a new form to a sharepoint list or collecting the entire sharepoint list into a collection?

Was this reply helpful? Yes No
Patrick-Stamper 51 on at

Like (0)

Report
Copy link

Link copied!

So I have my collection back and it will not work with my formula nor yours in the Items field to create a filter? A little stumped on that one..🤔

Was this reply helpful? Yes No