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:

Using Apps Using Formulas

All responses (7)

Answers (1)

AdamLa 3 on at

Like (0)

Report

Re: Filter Form with Combobox

Hi armiv,

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

Like (0)

Report

Re: Filter Form with Combobox

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!
R Bakker 725 on at

Like (0)

Report

Re: Filter Form with Combobox

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
Verified answer

WarrenBelz 146,658 Most Valuable Professional on at

Like (1)

Report
Re: Filter Form with Combobox

@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.
R Bakker 725 on at

Like (0)

Report

Re: Filter Form with Combobox

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

Like (0)

Report

Re: Filter Form with Combobox

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.
WarrenBelz 146,658 Most Valuable Professional on at

Like (0)

Report
Re: Filter Form with Combobox

@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.