Hello Power Apps People! I am working on an app that displays a gallery (Teams Dataverse is the data source, approx 18,000 items) and the user is able to filter the gallery with text inputs. When I am in Power Apps in Teams and when I use it in Preview mode everything functions as it should. However, when I publish the application to a Team the gallery is empty. I thought maybe it was a delegation issue for I filtered for the FirstN 500 items and it still did not resolve the issue. I also removed all of the text input filters and re-published to the Team and the gallery then displays. Does text input filters not work when filtering a Teams Dataverse table? Has anyone encountered this and found a resolution?
Hi,
the problem still exists. For me the FirstN command doesn't work because I want to show all items, not just the first one.
Hope we'll find the solution.
Hi Laxmi, I stopped working on this project about 8 months ago so my memory is not great... but I believe I did resolve the issue. Here is the code on the gallery items property, hope it helps (it may have been the FirstN command that did the trick, but I can't recall for sure):
Sort( Search( FirstN( Filter( [@RCU_Rooms], (IsBlank(cbBuilding.Selected.Value) || Building.Building = cbBuilding.Selected.Value) && (IsBlank(cbStatus.Selected.Value) || RoomStatus = cbStatus.Selected.Value) && (IsBlank(cbFloor.Selected.Value) || Floor = cbFloor.Selected.Value) ), 500 ), RoomSearchBox.Value, cr925_room ), Room, SortOrder.Ascending )
Hi @RachelPalya1
@NicaraguaJones
Did you guys able to resolve this issue, I am facing exactly the same issue the app is working perfectly fine in preview data is getting displayed in gallery after selecting an item from dropdown but after publishing the gallery data is not populating even after selecting an item from dropdown.
I tried the workaround which is mentioned here of inserting some inputs in input field and removing it back the data gets visible. But what is the permanent solution for this issue. User doesn't agree to always provide input and remove it back to start working on application.
If issue is resolved for you could you please share how can we mitigate this.
Thanks & Regards,
Laxmi
Hi Hardit - I am having the same issue as the OP here... Gallery Items property is set to:
Search(
Filter([@RCU_Rooms], IsBlank(cbBuilding.SelectedItems.Value) || IsEmpty(cbBuilding.SelectedItems) ||
Building.Building=cbBuilding.Selected.Value),
RoomSearchBox.Value,"cr925_room")
Where:
So in preview mode, all entries from the RCU_Rooms are displayed in the gallery despite lack of selection on the combobox and no text entered in the search box (as is expected/desired). Once published to Teams, the Gallery is empty opening the app and selecting a value in the combobox does nothing. Inputting text into the search then seems to "activate" the gallery, and search by text box or combobox filtering both begin to work, and if the combobox is cleared and the searchbox is empty, all gallery items are displayed, as in the preview.
Any suggestions appreciated. Thanks!
Hi Rachel, appreciate this has been a while but I thought it would be worth mentioning had a similar problem with Dataverse for Teams on 2 different apps.
The workaround I came up with is to have the reference to the filter in the gallery 'Items' property disabled when the app loads by using an 'If' statement referencing a boolean context variable set to 'false' in 'On Visible'; then when the text filter is selected (using the 'On Select' properpty) it updates the context variable to 'true', meaning the 'Items' property now includes a reference to the text input. Seems to work although there is still a brief moment prior to the user typing when the gallery disappears - as soon as they type the gallery works as intended, however.
@RachelPalya1 can you provide some more info about the gallery? Like what is its Items property? To answer your question about text input controls, they should work the same way in Dataverse for Teams.
---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.
Thanks!
Hardit Bhatia
Microsoft Business Applications MVP
Microsoft Certified Trainer MCT
WarrenBelz
106
Most Valuable Professional
MS.Ragavendar
73
stampcoin
52