Unanswered

How to Disable previously selected value in Dropdown

(0) Share

Report

Posted on by aayaanmayank

248

Hi Everyone Can some please help me in this problem? I am submitting data through form in the share point list. in the new Form there is dropdown field that contains 1,2,3,4,5,6 (e.g.). while submitting the data first time user can select any value (depending upon project phase) and submit.

when next time when user select the project and edit the submitted project details then user can only select the next phase value. e.g. ( if previously already selected 1 then 2,3,4,5,6 should be disable/visible in the dropdown. if previously already selected 2 then 3,4,5,6 should be disable/visible in dropdown)

I am not sure if there any way to do this.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

v-mengmli-msft on at

Like (0)

Report
Hi @aayaanmayank ,

Your requirements are actually taking Items of dropdown as dynamic. But the dropdown's selection needs to be from its Items. There is a logical error in this. I don't recommend that you do this, I would rather recommend that you reset the dropdown and set a reminder when the user selects an option that has already been chosen.

Please try this.

OnVisible of Screen.

ClearCollect(COL,AddColumns([1,2,3],"test",true))

OnChange of DropDown.

If(Self.Selected.Value in Filter(COL,test=false,Value),Reset(Self)&&Notify("Please select another choice"),Patch(COL,LookUp(COL,Value=Self.Selected.Value),{test:false}))

Best regards,

Rimmon

Was this reply helpful? Yes No
aayaanmayank 248 on at

Like (0)

Report

I am getting error on Value

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report

Hi @aayaanmayank ,

I just modified my reply, please refer to the newest.

Best regards,

Rimmon

Was this reply helpful? Yes No
aayaanmayank 248 on at

Like (0)

Report

Thanks @v-mengmli-msft however getting that invalid schema. Just a thought- If i store the last submitted value in separate sharepoint list column and when form is in edit mode then based on the last submitted value it should disable the previous values

Was this reply helpful? Yes No
v-mengmli-msft on at

Like (0)

Report
Hi @aayaanmayank ,

If you save each selection in the SP list, the method is even simpler. For example, if option 1 is saved in an item with ID 1, option 1 can be disabled the next time you edit it.

Items of dropdown.

Filter(["1","2","3","4"], Value<>LookUp(List,ID=1,DropdownSelection))

______________________________________________________________________________________________________________________

If my answer helps you solve the problem, please accept it as a solution.

Best regards,

Rimmon

Was this reply helpful? Yes No