cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Gallery not showing correct item

Hi all, 

 

I have an issue with two galleries working together. One gallery displays a list of quotes which is sourced from one table, and another table called customers which is sourced from another table. 

 

So basically a user selects a quote from a gallery and in the next gallery they confirm the customer that the quote belongs to. This issue only happens ONCE, when the app starts. No matter which quote you select it will always think you selected the first row of the draft orders gallery. But when you go back and select another, it makes the correct selection.

I have tried some different code to get the same result, however the issue where if you select it the first time after app start up, it will select the wrong one. 

 

Quote GalleryQuote GalleryCustomer GalleryCustomer Gallery

 

 

 

 

 

 

 

 

 

 

 

 

 

 

The code for draft orders(quotes)
Filter(OQuote, Status = "Draft" && SubmittedBy=User().Email)

Code for selection arrow on draft gallery

Navigate(ConCust, ScreenTransition.Cover, {QuoteNum:ThisItem.OrderNumber})

 

Code for Customer Gallery

Filter(Customers,DraftGallery.Selected.CustomerCode = CustomerCode)

 

 

Note: The issue doesn't happen when editing the app.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Gallery not showing correct item

Hi @AdrianAtEckoo ,

 

I have made a test on my side, and don't have the issue you mentioned.

Could you try to use 'Filter(Customers, CustomerCode = DraftGallery.Selected.CustomerCode)' and try again?

This issue is probably due to the overload of your app, because in my test, I find that the process of formula 'Filter(Customers,DraftGallery.Selected.CustomerCode = CustomerCode)' is quite slower than 'Filter(Customers, CustomerCode = DraftGallery.Selected.CustomerCode)'.

If it still doesn't work, I suggest you to create two new galleries to test on your side and check if the issue is due to the expression or other factors.

Hope this helps.

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

 

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Gallery not showing correct item

Hi @AdrianAtEckoo ,

 

I have made a test on my side, and don't have the issue you mentioned.

Could you try to use 'Filter(Customers, CustomerCode = DraftGallery.Selected.CustomerCode)' and try again?

This issue is probably due to the overload of your app, because in my test, I find that the process of formula 'Filter(Customers,DraftGallery.Selected.CustomerCode = CustomerCode)' is quite slower than 'Filter(Customers, CustomerCode = DraftGallery.Selected.CustomerCode)'.

If it still doesn't work, I suggest you to create two new galleries to test on your side and check if the issue is due to the expression or other factors.

Hope this helps.

Best regards,

Sik

If my post is helpful for you, please click on “Accept as Solution” to help other members find it more quickly.

 

View solution in original post

Highlighted
Helper I
Helper I

Re: Gallery not showing correct item

Hi @v-siky-msft 

 

I have tried switching the formula around first and that didn't seem to work. I have also deleted both galleries and replaced them with new ones under different names, and that also didn't work. 

 

I had looked at some diagnostics from powerapps and it says that there is inefficient delay loading, and suggested to use variables. That seemed to have worked, so in future I will have to stop being lazy and create variables for most things. 

P.S the diagnostics tool is great as it also showed other things that we're creating delays. 

 

Thanks for the help!

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (6,811)