cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
EYOST
Level: Powered On

Gallery show result delay, the result show after click other value

Hi All,

 

It's weird that the Gallery Results show the previous value selected.

For example, in my combo box have "A,B,C,D". It is a multiple selection combo box.
At the first time, I select "B", the Gallery shown nothing.

Then, I tried to click "D"(it has "B" and "D" in the combo box now), the Gallery show the result of "B". 

I remove "B"then the Gallery show the result of  "D".

 

Anyone experienced this? Will it because of big data?

 

Thank you.

3 REPLIES 3
v-siky-msft
Level 8

Re: Gallery show result delay, the result show after click other value

Hi @EYOST ,

 

In order to better understand and solve your issue:

1. Could you post more details with your gallery and combo box, such as formulas, logical relationship or more.

2. How much data do you have?

3. What is data source of it?

4. Is there any error information in your formulas?

I have made a test with a few amount of data, and don't have your issue.

Annotation 2019-09-17 121008.png

Could you try to test with a little bit of data to confrim if the issuse is caused by the big data? And Share as more details as possible to help solving your issues.

 

Best regards,

Sik 

EYOST
Level: Powered On

Re: Gallery show result delay, the result show after click other value

@v-siky-msft 

Thanks for your reply!

1. Could you post more details with your gallery and combo box, such as formulas, logical relationship or more.

3 combo boxes, not a must to select all. All datasources are Table1. 

ComboBox1 -> To choose the value in Category Type 1 

ComboBox2 -> To choose the value in Category Type 2

ComboBox3 -> To choose the value in Category Type 3

Table1 contains the value for CategoryType, CategoryCode and CategoryDescription.

 

One of the example for Combo box ComboBox3.Item =

 

Filter( 
     Filter (Table1, CategoryType="C3"),
     IF(isEmpty(ComboBox1.SelectedItems),true, CategoryCode in ComboBox1.SelectedItems.CategoryCode ),
     IF(isEmpty(ComboBox2.SelectedItems),true, CategoryCode in ComboBox2.SelectedItems.CategoryCode )
    )

When I just open the App, the combo box is empty. The combo box only show the correct list after I change the below

Filter( 
     Filter (Table1, CategoryType="C1"),
     IF(isEmpty(ComboBox1.SelectedItems),true, CategoryCode in ComboBox1.SelectedItems.CategoryCode ),
     IF(isEmpty(ComboBox2.SelectedItems),true, CategoryCode in ComboBox2.SelectedItems.CategoryCode )
    )

to 

Filter( 
     Table1, 
     IF(isEmpty(ComboBox1.SelectedItems),true, CategoryCode in ComboBox1.SelectedItems.CategoryCode ),
     IF(isEmpty(ComboBox2.SelectedItems),true, CategoryCode in ComboBox2.SelectedItems.CategoryCode )
    )

 

and change again back to the initial one. It is so weird.

CategoryType is to define the row is "C1" , "C2" or "C3". Therefore, with or without specified CategoryType="C1", it should be fine.

 

Gallery datasource is Table2.

Gallery.Item =

Filter( 
     Table2, 
     IF(isEmpty(ComboBox1.SelectedItems),true, C1 in ComboBox1.SelectedItems.CategoryCode ),
     IF(isEmpty(ComboBox2.SelectedItems),true, C2 in ComboBox2.SelectedItems.CategoryCode ),
     IF(isEmpty(ComboBox3.SelectedItems),true, C3 in ComboBox3.SelectedItems.CategoryCode )
    )

2. How much data do you have?

Table2 have more than 20,000 rows.

3. What is data source of it?

SQL Server

4. Is there any error information in your formulas?

Delegation Warning.

 

When I try with the Excel tables(10rows data), it seems fine.

EYOST
Level: Powered On

Re: Gallery show result delay, the result show after click other value

@v-siky-msft 

I just tested with 3 tables(10 rows of data) inside an Excel today. It has another issue which I didn't mention above.

I tried with 5 combo boxes.

When the app is just opened, 1st combo box shown the correct values, 2nd to 5th combo box shown nothing.

After selecting the value for all 5 combo boxes, I remove all of the selected values, now only the combo boxes shown the list correctly.

Did I miss something?

Appreciate for your advise.

Thank you

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Top Community Contributors for September  2019

Top Community Contributors for September 2019 🎉🎉

Let's thank our top community contributors

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 251 members 5,828 guests
Please welcome our newest community members: