Remove already added values and disable drop-down menu in edit from
I need kind of guidance to implement following scenario. Please help me to solved this.
My back end date table is SharePoint and primary column name is project*. After implement the powerapp, Project code should not be duplicate. E.g. only 1 11MAP can be add. User cannot add it as a 2nd project , they can only update existing details of the same project (11MAP).
My implementation idea is, when user click + in powerapp display screen, project codes displaying in drop-down menu should not be ones which already add previously.
In details screen, when I click edit icon and if it open edit screen with project drop down menu as disable, so then I can achieved that.
So please help me to implement this two cases in my power app.