Filtering Combobox in form

(0) Share

Report

Posted on by CU22100725-0

129

Hello,

I need to make a filter between several entries, but I can't get the right form content with the filter.

In my sharepoint list I use columns in lookup and I specify that a content is not unique. In other words, if I put an apple in one of my contents, I can also have apple in another.

Here's a screenshot of the current page:

So I need to make a filter on the line "ligneCommande" in relation to the dropdown list "Commande"

"Commande" is the column with no unique content.

Thanks for your help,

Tom Victor

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @TomVictor ,

Do you want to show different options in drop down list of "ligneCommande" according to selected option of "Commande"? If so, have you tried use Filter function in Items of "ligneCommande"?

What are formulas on Items of "ligneCommande" and "Commande"?

Best regards,

Rimmon

Was this reply helpful? Yes No
CU22100725-0 129 on at

Like (0)

Report
Copy link

Link copied!
Hi @v-mengmli-msft ,

I use this formula on "Commande" :
Filter('IX-Commande'; Client.Value = ComboBoxClient.Selected.Value).nom

And this formula for "ligneCommande
Filter(Choices([@'IX-Prestation'].ligneCommande); Id = Value(LabelIDCommande.Text))

I use a hidden Label with this formula to retrieve the ID of "Commande" :
Value(LookUp('IX-Commande'; Client.Value = ComboBox2_1.Selected.Value && nom = ComboBox2.Selected.nom; ID))

Regards,
Tom Victor

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @TomVictor ,

The ID you get in label is Item's ID not Id of choices of Choice column.

Assuming that you want to get this.

Then options in drop down list of "ligneCommande" should be choices of "ligneCommande" column which "nom" column equals option in "Commande".

If above is what you want, please try this.

Items of "ligneCommande" combo box.

Distinct(Filter('IX-Commande'; Client.Value = ComboBox2_1.Selected.Value && nom = ComboBox2.Selected.nom);ligneCommande)

Best regards,

Rimmon

Was this reply helpful? Yes No
CU22100725-0 129 on at

Like (0)

Report
Copy link

Link copied!

Hi, @v-mengmli-msft ,

I tried your formula but it doesn't seems to work... I can't find "ligneCommande"

Regards,
Tom Victor

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @TomVictor ,

It is the drop down for "ligneCommande" field. I don't know the name of the drop down in your app.

Best regards,

Rimmon

Was this reply helpful? Yes No
CU22100725-0 129 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-mengmli-msft ,

I tried on this field and I don't have "ligneCommande" in the table. "ligneCommande" is on a table named 'IX-LigneTache' (Text column) and in 'IX-Prestation' (lookup column)

Regards,
Tom Victor

Was this reply helpful? Yes No
v-mengmli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @TomVictor ,

What is the column in "IX-Commande" that is used to store choices of ligneCommande called? Please try to replace the "ligneCommande" with it.

Best regards,

Rimmon

Was this reply helpful? Yes No