web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filtering Combobox in ...
Power Apps
Unanswered

Filtering Combobox in form

(0) ShareShare
ReportReport
Posted on by 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:

 

TomVictor_0-1717511926955.png

 

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:
I have the same question (0)
  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    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

  • CU22100725-0 Profile Picture
    129 on at

    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

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    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

     

     

  • CU22100725-0 Profile Picture
    129 on at

    Hi, @v-mengmli-msft ,

     

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

     

    Regards,

    Tom Victor

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    Hi @TomVictor ,

     

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

    vmengmlimsft_0-1717753093432.png

     

     

    Best regards,

    Rimmon

  • CU22100725-0 Profile Picture
    129 on at

    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

  • v-mengmli-msft Profile Picture
    Microsoft Employee on at

    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.

    vmengmlimsft_0-1718181084602.png

     

     

     

    Best regards,

    Rimmon

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 531 Most Valuable Professional

#2
Haque Profile Picture

Haque 261

#3
Kalathiya Profile Picture

Kalathiya 221 Super User 2026 Season 1

Last 30 days Overall leaderboard