Sharepoint-multiselect Column in PowerApp not shown

[IngoTSV]

Hi there,

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. 😞

Cheers

Ingo

[Jeff_Thorpe]

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.

example:

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.

[ajdhingr]

@IngoTSV do you still have the issue ? Please let us know 

[IngoTSV]

Hi Jeff,

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 😢

Cheers

Ingo

[IngoTSV]

yes 😉

[Jeff_Thorpe]

If contact is a person field then the label in your gallery item would look like this: 

ThisItem.Contact.DisplayName

[ajdhingr]

@IngoTSV - Do you still have this issue ?

[IngoTSV]

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.

Cheers

Ingo