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

Try to filter a datatable by using a listbox with multiple choices

Hi there,

i have a listbox "lstAuswahl" (SelectMultiple=True) that is filled by using this expression:

Items: Choices(Auszubildende.AP2_Zeitraum)

 

I want to filter a datatable accordingly to the one or more selected values in the listbox.

Using this for the items-property in the datatable: 

Filter(Auszubildende;AP2_Zeitraum in lstAuswahl.Selected.Value) does not work.

The result is an empty table.

 

What is wrong?

Hoping for help!

Jürgen

 

 

 

 

 

 

12 REPLIES 12

Ah, okay - that's it! With this option it works.

Thank you very much for your help and your time!

May i ask you two more questions regarding this issue?

1) Datatable

In the column AP1_Zeitraum i can see no values. I just see [object Object]. Is there a way to solve this?

 

2) "Reverse" multiple selection

I have a similar situation: The colum in the sp-list is a choice column with "allow multiple selection = no".

The listbox i use allows multiple selection. What woul be the solution then?

 

Hi @JürgenD,

vqiaqimsft_1-1624351287064.png

Set the Text property as below:

Concat(ThisItem.AP2_Zeitraum.Value,Value,",")

For the second question, it is easier than the original one.

Set the DataTable Items property as below:

Filter(SPList,Choice.Value in ListBox1.SelectedItems.Value)

Regards,

Qi

Best Regards,
Qi

Thank you very much again!

Now my (powerapps) problems are solved and i can go on.

Good to know there are helpful persons like you!

 

Regards

Jürgen

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Top Solution Authors
Top Kudoed Authors
Users online (1,617)