I have a simple sharepoint list, which has the Contact Column (for a name) and a multiselect choice column for Hobbies. So you can enter a name and one or multiple given hobbies for this name. I now want to build an App, where I can enter a hobbie and find all the names, that have this hobbie.
With a combobox I can select one or more hobbies with "Choices('contacts'.'hobbies')" and in a dropdown I can filter for the sorted result with "Sort(ComboHobbies.SelectedItems.Value;Value)", but I always fail when trying to show the name based on that selection anywhere. Can you help me out? I am pretty new to PowerApps and watched 10h of videos, but somehow does not help. 😞
In your app you could have a dropdown that displays all the hobbies and the have a gallery that displays all the users that have the selected hobby.
Dropdown > Items > Choices('contacts'.'hobbies')
Gallery > Items > Filter(Contacts, Dropdown.Selected.Value in Hobbies.Value)
You will get a delegation warning because "in" isn't a delegable operator in SharePoint. By default the non-delegation query limit is 500 but you can increase that 2000 by going into advance settings of the app. If the contact list has less items than the non-delegation query limit then you should be fine.
formulars works including the delegation error, but there is no content in the gallery 😞
Let's assume, the list name is People, so I would put "Choices(People.hobbies)" in the dropdown (works fine) and "Filter(People;Dropdown.Selected.Value in People.Hobbies)" in the gallery, the text box should have a "thisitem.contact"?
Whatever I chose here, below the function it will state, I am using an area, which is not supported, the expected datatype would be text.
Btw. I tried adding a new screen and a gallery. I connected the gallery with my sharepoint list, when I try to add a description box and connect it to the hobbies, this column is not shown (I guess, because it is a table and no text). So how do I make it visible anywhere at all?
I am getting more and more lost 😢
If contact is a person field then the label in your gallery item would look like this:
Yes, I still have that problem, but I gave up and started learning the fundamentals, to understand what I am doing. So no help needed anymore.
I guess it is just, that I can not show multiselect sharepoint columns in a PowerApp dropdown field in an easy way.