Answered

Comparing comboBox selected Item with choice column values

(0) Share

Report

Posted on by wagnerortizz

Hi!
I need to avoid a user to patch values in a choice column if such values already exist.

In other words, I need to get the selectedItems in a combobox and check if they already exist in a choice colum (in SharePoint list).

It seems easy...but I have been trying this for over 4 days! loool
Any tips?

Thanks a lot in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

alaabitar 1,503 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hello,

You can activate the enforce unique values at the column level in sharepoint.

Best regards,
Alaa

Was this reply helpful? Yes No
wagnerortizz 45 on at

Like (0)

Report
Copy link

Link copied!

Yeh..Thanks a lot..
I believe it desnt work to me because indeed I cant have the same value, but only coming from the same person...
Person A can only choose "Orange" once. If he/she tries to choose "Orange" again, I block.
But person B can still choose his/her "Orange". Thats why I am gonna have repeated value in the colum, but not coming from the same person....gotcha?

Was this reply helpful? Yes No
wagnerortizz 45 on at

Like (0)

Report
Copy link

Link copied!

The problem I am facing is because Choice Column return registers. So each option/each choice is a register. But in ComboBox, each choice is a Table. And that is driving me crazy...cuz I need to compare them, but can't

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @wagnerortizz ,

Does your choice column allow multiple selection?

I did a simple test with a choice column that doesn't allow multiple selections for your reference.

I put all the existing options into a collection before submitting the data, and then determine whether the current option is in the collection.

1. Here is my List.

2. Here is my App.

ClearCollect(collectionname,Distinct(AddColumns(datasource,"newcolumnname",ChoiceColumn.Value),newcolumnname)); If(Form1.Mode=FormMode.New,If(DataCardValue9.Selected.Value in collectionname,Notify("Please choose another option"),SubmitForm(Form1)),SubmitForm(Form1))

Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No