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.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks