cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
laurent_rio
Helper I
Helper I

Remove Selected items from Dropdown selection

Capture.JPGHi,

 

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 ?

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

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))
})

 

553.PNG

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
eka24
Super User III
Super User III

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.

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 ?

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
Community Support
Community Support

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))
})

 

553.PNG

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (12,580)