Answered

Filter Form with Combobox

(0) Share

Report

Posted on by R Bakker

725

It's like I cannot see the elephant in the room, I presume it is simple. I would like my edit form to be filtered by a combobox from the same datasource. I have used combobox frequently, but still getting my head around forms. Im using a sharepoint list that has about thirty records.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
@Corissandageri ,

Filter( YourListName, MatchingField=YourComboBoxName.Selected.xxxx )

where xxxx depends on the Items property of the combo box.

When you type YourComboBoxName.Selected. (note second dot), valid values will come up underneath. For some guidance of what they mean: -

If your Items are Choices(ListName.FieldName) - a Choices or Lookup field), the reference will be YourComboBoxName.Selected.Value

If they are Distinct( . . . .), it will be YourComboBoxName.Selected.Result

The other option is when they are based on a field value in a list (other than Distinct), then it will be YourComboBoxName.Selected.FieldName (actual field name)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

Hi Warren
Firstly, I tell a lie, it's a Excel spreadsheet, from one of my earlier apps before I switched to Sharepoint.
I think I have tried all of the above.
My combobox6 is as follows:
Table2.CN02
This is my form:
Filter(Table2,CN02 =ComboBox6.Selected.CN02)
And the form data source:
Table2
This is an old app which is already connected to the mentioned data source.

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

When I filter using a gallery, it works fine. But I don't really have the real estate for a gallery.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (1)

Report
@Corissandageri ,

Actually I did not notice the form reference - you need in the Items

LookUp( Table2, CN02 =ComboBox6.Selected.CN02 )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report

This works great, I shall get this tattooed somewhere, so that I don't forget. Or make a note to self on which app I have used this function. Thanks again Warren

Was this reply helpful? Yes No
armiv 27 on at

Like (0)

Report

Hi,
I see this is quite an old post but I am currently having the same issue and the solution given here is not working for me. I would really appreciate if someone could help me 🙂

Here is the dropdown, connected to the SharePoint table from which I select the Legal Entity field:

And this is the piece of code in my Form's DataSource:
LookUp('DEI', 'Legal Entity' = leDropDown.Selected.'Legal Entity')

For some reason, when I select something from the dropdown, nothing appears in the Form.
Is there anything I am missing?
Thank you in advance!

Was this reply helpful? Yes No
AdamLa 3 on at

Like (0)

Report

Hi armiv,

Check if you have form Default mode mode as "Edit". When you creating new one it's going automatically to "New".

Was this reply helpful? Yes No