Drop Down manipulation

(1) Share

Report

Posted on by SM-08061324-0

Hello

I am currently trying to build an app to track people and utilise my rooms.

I have two tables, Rooms and Tracking

Rooms consist of the following columns: RoomName and active.

Tracking has the following columns: Name, Room, and Finished.

I want to be able to select my dropdown to list the rooms. (Currently, this works well)

If I select a room, it writes the room against the person's name (i.e., room5). If I have another person listed and they click to allocate a room, I don't want room5 to be in the dropdown.

I am new to this and would appreciate some help in what to put in drpRoom_v2.Items.

Here are the settings I am using so far:

drpRoom_v2.Items = ForAll(Rooms, RoomName)

drpRoom_v2.Defaults = If(IsBlank(pat.Room),Blank(),LookUp(ForAll(Rooms, RoomName),Value = pat.Room).Value)

drpRoom_v2.OnChange = Patch(PatientTracking,pat,{Room:drpRoom_v2.Selected.Value})

if someone could help me or suggest a way that a room can will only appear if not booked (so untill finished is ticked on patient tracking) i would appreciate it.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Suggested answer

SpongYe 5,903 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @

You can filter the rooms dropdown so it only shows rooms that are active and not currently assigned to an unfinished tracking record. For your dropdown Items property, try this:

Filter( Rooms, active = true && ( RoomName = pat.Room || Not( RoomName in Filter( PatientTracking, Finished <> true ).Room ) ) ).RoomName

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
SpongYe Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my blog [@S pongYe] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Verified answer

WarrenBelz 155,565 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi i@SM-08061324-0,

Firstly @SpongYe's code may do what you need - if so please mark it appropriately. If you find a Delegation issue wiht the nested Filters, you can do this
With( { _Rooms: Filter( PatientTracking, !Finished ) }, Filter( Rooms, active && ( RoomName = pat.Room || !(RoomName in _Rooms.Room) ) ).RoomName )

I am a little unclear as to what Finished indicates - you may need to remove the Not - !() from the last line of the filter depending on whether you want finished or not finished rooms.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No