Remove Selected items from Dropdown selection

[laurent_rio]

Hi,

I try to make interview reservation apps. I want after i set the schedule (date and time) for specific candidate (example A), the items (candidate) will not appear again in Candidate selection dropdown. How to achieve this ?

[eka24]

Can you show the Items in the dropdown  to proceed. You can use filter.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[laurent_rio]

i use the items in dropdown 

items : ["A","B","C","D","E"]

what i want to achieve After A selected/patched to sharepoint list which specific Interview Date and Time selected 

the dropdpown will not shown the "A" anymore , how to use filter ?

[eka24]

If your Datasource is List1, create a collection OnVisible of the screen:

ClearCollect (MyList1Col,List1)

Then filter the Dropdown Items as:

Filter (List1,Not(ColumnWithABC, in MyList1Col.ColumnWithABC))

Please change ColumnWithABC and the Datasource List1 to reflect the actual names.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[v-yutliu-msft · Accepted solution]

Hi @laurent_rio ,

Do you want the drop down only shows the candidates that have not reserved time?

Could you tell me what is your data source?

I suggest you not set the drop down's Items to ["A","B","C","D","E"].

I suggest you set the drop down's Items to one field in data source.

Here's my advice:

1)use sharepoint as data source

insert these fields: candidate(text field), time (date time field)

//this list will record all the reservation records

2)in powerapps

insert these controls: a datepicker, 2 drop downs, a button

3)set the screen's OnVisible:

ClearCollect(allcandidates,["A","B","C","D","E"])

//I assume that A,B,C,D is candidates' fullname

set drop down1's Items:

Filter(allcandidates,Value Not in Filter(listname,!IsBlank(time)).candidate
                                   //get the candidates that have reserved time
      )//filter value not in these fullname that have reserved

 set the drop down2's Items:

["12:00","12:05","12:10"]
//the time that you want

set the submit button's OnSelect:

Patch(listname,Defaults(listname),{
                                     candidate:drop down1.Selected.Value,
                                     time:DateTimeValue(Text(DatePicker1.SelectedDate)&" "&Text(Dropdown2.Selected.Value))
})

Best regards,