OR statement within IF statement

(0) Share

Report

Posted on by Kbostwick

I have a reservation system that has spaces available based on the day of week; this currently works for one single location and I am trying to add in another location that uses the same days. My code isnt working, I looked around the community here and made some adjustments that I thought would work but I still am overlooking something. Can someone take a look and guide me towards the correct adjustments?

Filter(Choices([@HybridReservations].Workspace),If(!(Weekday(hybriddate1.SelectedDate) in [2,6]),Text(Value)<>"Front desk, room 430, PC (no docking station)",Text(Value)<>"430 #1",true))

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Kbostwick ,

Please try:

Filter( Choices([@HybridReservations].Workspace), If( !(Weekday(hybriddate1.SelectedDate) in [2,6]), Text(Value)<>"Front desk, room 430, PC (no docking station)" && Text(Value)<>"430 #1", true ) )

Best Regards,
Bof

Was this reply helpful? Yes No
Kbostwick 41 on at

Like (0)

Report
Copy link

Link copied!

That did it! Thank you.

Was this reply helpful? Yes No