Don't show selected values from choice column once it has recorded into the list.

[ShaikSayyad]

I'm trying restrict the choices from choice column, ex: I have 1, 2,3,4,5,6,7,8 choices in a choice column. Now I have created a app which helps to record th new values here I have selected 1 choice from choice field and submitted then it has saved in list after this I need to add new record from only remaining choices like 2, 3 ,4,5,6,7,8. (Don't show the selected choice from choice list)
Please help me to resolve this

Thanks in advance.

[RandyHayes]

@ShaikSayyad 

You will need to do this through the aide of a collection.

Here is a quick example (assuming a DropDown Control - but would work on a ComboBox as well):

    Create a collection for the DropDown -  ClearCollect(myList, [1,2,3,4,5,6,7])

    Set the Items for the DropDown - myList

    In your submit, or some other action - RemoveIf(myList, Value=Value(DropDown1.Selected.Value))

NOW...all of this assumes a very simple scenario of numbers and their value.  You will need to adjust this to your App and make sure you are converting and comparing the proper values in the RemoveIf.

I hope this is helpful for you.

[v-xida-msft]

Hi @ShaikSayyad ,

Could you please share a bit more about your scenario?

Do you want to exclude the selected value from the available options within the Choice filed (ComboBox) within your Edit form?

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the ComboBox within the AvailableValues Data card to following:

Filter(
        Choices('20190325_case13'.AvailableValues), /* <-- AvailableValues represents the Choice type column in my SP list */
        Not(
            Value in Filter(Distinct('20190325_case13',AvailableValues.Value), Result<>Blank())
        )
)

On your side, you should type:

Filter(
        Choices('YourSPList'.YourChoiceColumn), /* <-- YourChoiceColumn represents the Choice type column in your SP list */
        Not(
            Value in Filter(Distinct('YourSPList', YourChoiceColumn.Value), Result <> Blank())
        )
)

Please take a try with above formula, then check if the issue is solved.

More details about Filter function in PowerApps, please check the following article:

Filter function

Best regards,

[ShaikSayyad]

Thanks for your response, I have updated my formulaas suggested but the dropdown was showing empty. Please have a look into screen below and let me know your inputs.

[v-xida-msft · Accepted solution]

Hi @ShaikSayyad ,

I have made a test on my side, and don't have the issue that you mentioned.

Please consider take a try to set the Items proeprty of the ComboBox control within the Choice Field Data card to following:

Filter(
        Choices('YourSPList'.YourChoiceColumn), /* <-- YourChoiceColumn represents the Choice type column in your SP list */
        Not(
            Value in Distinct('YourSPList', YourChoiceColumn.Value)
        )
)

If the issue still exists, please consider take a try to re-create a new app based on your SP list data source, then take a try with above fomrula I provided, check if the issue is solved.

Best regards,

[ShaikSayyad]

Thank you again for quick response, I came across with the problem here, let me clarify you.

1, I have a list which helps to record user skill levels upon different products (like MSExcel, MS PowerPoint, MS Word)

2, Users had entered their skill levels with correspondig products (like; MS Excel - Basic), user can edit this item as MS Excel - Modarated or master.

3, here we need to filter product choice based on user saved records, suppose we have A, B, C, D called users, A had entered MS Excel then he should be abled to add remaing products only and B, C, D users should have all products when they are about to record their products.

I hope this would helps you.