Cascading Combo Boxes from SharePoint List

[Anonymous]

Hello,

Here is my scenario:

Sharepoint list source: 'bu_campaign_mapping2'

Sharepoint list destination: 'activity_data'

Both lists contain three text fields (single line of text):

BU Campaign

Product Segment

Product Collection

My goal is to make a cascading combo box form that allows the users to provide multiple selections at each step of the three combo boxes, but in a cascading manner so only relevant selections pop up.

Lastly, I want these multi-selections for each field to be written to the destination list (activity_data) as a list of selections containing 1 or more selections.

I have been struggling to set up the combo boxes to do what I am looking to do above.

I have both the source and destination list loaded into the app.

My current steps:

First: works

Second box isn't working. I am being told 'BU Campaign' isn't recognized. This is odd considering I used it the step above..

Any/all help is much appreciated!

[Rusk]

I think you will need to use 'BU Campaign' = ComboBox1.Selected.Result for your 2nd box.  

This video is awesome and should help!  https://www.youtube.com/watch?v=Qzpjq008cBY 

[CNT]

@Anonymous Distinct returns a single column table with a column named Result.

So, the Filter condition would be, Combobox1.Selected.Value in Result

Please remember to give a 👍 and accept my solution as it will help others in the future.

[Anonymous]

That fixed the second box!

The third box is having issues still though:

it is telling me "the name 'valid' is not recognized.

Any ideas here?

Thanks,

-Joel

[CNT]

@Anonymous The syntax for Filter is, Filter(Table*, Formula1 [, *Formula2*, ... ] )

In your case it looks like 2 Tables (Data sources). Is that right?

[Anonymous]

Yes, based on the first two selections from the combo boxes (each of which could have multiple values) I want the third to only provide selections relevant to the first two multi-selections.

[CNT · Accepted solution]

@Anonymous BUT, you can't have 2 datasources in the Filter statement. You got to combine them into one. You could use the With statement to do that,

With({varCombined: here combine the 2 into one},

   Filter(varCombined, condition)

)