How to create Cascading Dropdowns with Multiple List in Power Apps

(0) Share

Report

Posted on by infinitepp

189

I'm creating an app where I want to cascade two dropdown lists, where different SharePoint lists.

The First Dropdown list: dd_roomNo connect with tbl_roomNo

The Second Dropdown list: dd_period

in dd_period I already managed with the following code

Filter(
 tbl_period,
 Not(
 period in tbl_register.Time_Reserve && Text(
 Now(),
 "dd/mm/yyyy"
 ) in tbl_register.convertDate
 ) And TimeValue(
 Concatenate(
 Left(
 Substitute(
 period,
 ".",
 ":"
 ),
 5
 ),
 Right(
 period,
 1
 )
 )
 ) > TimeValue(Now())
)

I would like to add a new condition,

If the user selects room No.1 in dd_roomNo, the Expected result should be dd_period will show just the period that is not reserved in Room No.1.

How could I filter the second dropdown?

Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

infinitepp 189 on at

Like (0)

Report
Copy link

Link copied!
I found the solution already.
The solution is add a new condition in Not ( dd_roomNo.Selected.Value in tbl_register.room && .....) and It's Work!
Filter( tbl_period, Not( dd_roomNo.Selected.Value in tbl_register.room && period in tbl_register.Time_Reserve && Text( Now(), "dd/mm/yyyy" ) in tbl_register.convertDate ) And TimeValue( Concatenate( Left( Substitute( period, ".", ":" ), 5 ), Right( period, 1 ) ) ) > TimeValue(Now()) )

Was this reply helpful? Yes No