I would like to know if I'm dealing with a bug, or if I am not implementing things correctly.
First off, this App is connected to an Azure SQL database. And all tables have a Primary Key.
In the attached images, I have a Navigation Gallery along the top in green (not the issue). I have a Search Gallery on the left with a text input search box above it. And then, I have an Edit Form to the right of the Search Gallery. The DataSource for both the Search Gallery and Edit Form is the same Member table. The Item property of the Edit Form is set to the Search Gallery's Selected property.
The Search Gallery has its Items property set to Filter('[dbo].[Member]', StartsWith(Pnum, SearchMembers.Text) || StartsWith(LastName, SearchMembers.Text)). So, one can search based on LastName or Pnum. The searching/filtering of a Member in this Search Gallery (approx 5,000 entries) works consistently fine.
The problem is that some of the time, the item in the top of the list gets selected (Good- See image Gallery Select Problem 3.jpg) , and sometime nothing in the list gets selected (Bad- See image Gallery Select Problem 2.jpg).
Can someone please enlighten me?
This is my point though.
In many cases, I don't need to physically select an item in the filtered list. Just by searching, it automatically selects the first in the list and therefore displays the details in the edit form. But, sometimes it does not select anything and therefore displays a blank edit form.
This behaviour seems far too random to me!
I don't think the issue is a lag in time, because the search results are returned immediately, and are the correct results. The only issue is that sometimes no item in the list is selected. For example; I may perform 2 searches and the top item is automatically selected and displyed in the edit form details. Then, my 3rd search produces the correct filtered list of results, but nothing is selected. Then, I perform a 4th and 5th search and an item is again automtically selected in the list. Then on the 6th and 7th searches nothing is selected. And so forth...
I can not observe any sort of definite pattern. It seems quite random as to when it selects, and when it does not.
Hi @Steven_Ross_Lee ,
Could you show me your settings of the edit form?
I've made a similar test but not met the problem as your description.
Here's my test:
I set my edit form's Items: Gallery1.Selected.
After typing words in the textinput, the edit form will display the first item of the filtered items.
If you choose one in the gallery, the edit form will display that one.
But I also notice, if the filtered data is empty(gallery show no items), the edit form will show "No item to display"
Community Support Team _ Phoebe Liu
My Edit form settings for the "General" form are, Items = SelectGallery.Selected, and DataSource = the same SQL table that is the source for the Select Gallery.
I did some further testing with a smaller set of data. Instead of 5,000 records in my Member table, I reduced it to 500.
Not sure if I mentioned it, but I have no delegation warnings to begin with (whether my source table is 5,000 or 500). And as far as I can see, SQL does provide delegation for a Filter function using "StartsWith", which is what I'm using in my filter.
In my testing with only 500 records, it seems that I can perform more searches in succession before it fails to select the top item in my Gallery. But, at some point it fails. And, as before, if I keep searching it will succeed again, and fail again.
So, I am still stumped as to whether this is a "bug" of some kind.
Any further help/knowledge wuld be greatly appreciated.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.