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,
