How to exclude a value that already exists in another ComboBox from a ComboBox

(0) Share

Report

Posted on by floxfloat

100

Hi,

I wonder how to exclude a value that already exists in a ComboBox in another ComboBox. I fetch and return the value from a SharePoint List

SharePoint List Structure

Combo Box A already have e.g 'FFMC-Ops'

formula:

If(!IsBlank(TextInput1.Text), Distinct('Folders',Title))

Combo Box B should only have FFMC-Test since the ~~FFMC-OPS~~ is already selected in Combo Box A

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

v-yueyun-msft on at

Like (0)

Report

Hi , @vicsaisan

This is my test sharepoint list:

You can try to use this code in your second Combo box 2 - items peroperty:

Filter( Distinct(TableName.Title ,Title) , !(Value in ComboBox1.SelectedItems) )

This is the result when first combo box is selected:

And in your first Combo box 1- OnChange:

Reset(ComboBox2)

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
floxfloat 100 on at

Like (0)

Report

Hi @v-yueyun-msft ,
I tried the above code unfortunately it's not returning any values.

Apologies, I missed to post this.

in ComboBox2, I'm filtering the values based in another combo box e.g ComboBox3 selected item and will return Title/Folder same values in Combobox1

Combobox2 ---> ( (this returns values however if a value is already selected in combobox1, the value should not appear in this ComboBox)
Formula:
Filter('SharePoint Folders', Approver = ComboBox3.Selected.Approver)

ComboBox3 returns the approvers from SharePoint Approver Column based on Selected Folder
Formula:  Filter('SharePoint Folders', Approver = ComboBox3.Selected.Approver)

Was this reply helpful? Yes No
Verified answer

v-yueyun-msft on at

Like (1)

Report

Hi , @vicsaisan

Thanks for your response!

According to your description , you use this code in Combo box 2 -items , right?

Filter('SharePoint Folders', Approver = ComboBox3.Selected.Approver)

And in my understand , the 'SharePoint Folders' is your SharePoint list:

Your Combo box 1 -items use this code:

If(!IsBlank(TextInput1.Text), Distinct('Folders',Title)) This code return a single column table which columnName is [Value].

So now you want to filter the Combo box 1 items based on the Combo box 1 selected item.

Can you try to use this code in Combo box2 -items in your side:

Filter( Distinct(Filter('SharePoint Folders', Approver = ComboBox3.Selected.Approver).Title , Title) As items , !(items.Value in ComboBox1.SelectedItems) )

If this can not show data , can you check if this code can return data when it put on the Button-OnSelect(You can select all the code to see the data):

Distinct(Filter('SharePoint Folders', Approver = ComboBox3.Selected.Approver).Title

And what's the code return in your side:

ComboBox1.SelectedItems

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
floxfloat 100 on at

Like (0)

Report

Hi @v-yueyun-msft , Thank you for the prompt response. code below you provided are now returning a value. this is exactly I'm trying to achieve in this ComboBox. Thank you so much for your help! It really helps and learned a lot from this 😀🙏

Was this reply helpful? Yes No