Need help on improve the formula syntax

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a working formula. The formula is to compare two collection "Booking" and "colResult":

If(CountRows(colResult) >0,
Filter(
Booking,
(ResourceName in colResult.ResourceName) &&
(StartTime <= bookStartTime && EndTime >= bookEndTime)
),
Filter(Booking,1=0))

When colResult have 0 row, ResourceName in colResult.ResourceName is always true. Hence entire Booking is returned.

To avoid this situation I add the first line and last line. It looks ugly but I cannot find a better way. Could you please advise?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous

Yes, try to avoid using If statements in your Items formulas!

Include your logic in the criteria logic statement.

Filter(Booking, CountRows(colResult) = 0 || ((ResourceName in colResult.ResourceName) && (StartTime <= bookStartTime && EndTime >= bookEndTime) ) )

I hope this is helpful for you.

Was this reply helpful? Yes No