Unanswered

I have a question about using a dropdown list.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

have options in my sharepoint list. I have already selected what I want in the list and I don't want to be able to select the same item again. How should I write the terms?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @warayut ,

You can filter this dropdown‘s data source (Items property) based on records that already exist in SP list.

For example:

Filter(DropDownItms,!(DropDownItmsColumnName in SPList.ColumnName))

If I don't understand your request correctly, please consider providing more details and screenshots.

Best Regards,

Bof

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

From the pictures I have shared I have saved the data by selecting the KRSNB001 device so I want this list to be disabled or not selectable to save new data.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @warayut ,

You could try to set the submit button's OnSelect property to:

If( DropDownControl.Selected.ColumnName in SPList.ColumnName, Notify("Duplicate values");Reset(DropDownControl), SubmitForm(FormName) )

Best Regards,

Bof

Was this reply helpful? Yes No