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 Gallery
Customer 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.
Solved! Go to Solution.
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.
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.
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!
User | Count |
---|---|
125 | |
87 | |
87 | |
75 | |
69 |
User | Count |
---|---|
216 | |
181 | |
140 | |
97 | |
83 |