cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Sharepoint-multiselect Column in PowerApp not shown

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

7 REPLIES 7
Super User
Super User

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.



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Microsoft
Microsoft

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

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.

IngoTSV_0-1598247161913.png

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

yes 😉

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

 

ThisItem.Contact.DisplayName

 

 



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

@IngoTSV - Do you still have this issue ?

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

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (61,146)