Unanswered

Evaluate if Row Met condition

(0) Share

Report

Posted on by HM-18111627-0

Hi all,
I am trying to evaluate a true/false for each row in gallery whether some conditions is met.
If met, the return text value would be true else false.

My formula is as follows:

Control: Label
Item: Text

Formula:
If(
 IsEmpty(
 Filter(
 'Booking List',
 DeskText = ThisItem.DeskText && 'Check Out From' >= ThisItem.'Check Out From' && 'Check Out To' >= ThisItem.'Check Out To'
 )
 ),
 true,
 false
)

However the error message indicate, the formula uses scope, which is not presently supported for evaluation.

Is there workaround this?

Regards

Hidayat

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @Yatz,

Could you please tell me that if the Label displays correct string?

I think your formula is correct, if the Label display your expected string, please just ignore this message, which is not an error message.

Or, you could modify as below:

If( CountRows( Filter( 'Booking List', DeskText = ThisItem.DeskText && 'Check Out From' >= ThisItem.'Check Out From' && 'Check Out To' >= ThisItem.'Check Out To' ) )<=0, true, false )
HM-18111627-0 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Qi,

Unfortunately, the output does not display the expected outcome.
The formula returns false for every row in the gallery, even though there are some rows that match the requirement.

Hidayat
Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Yatz ,

You can try the following code:
If( CountRows( Filter( 'Booking List', DeskText = ThisItem.DeskText && 'Check Out From' >= ThisItem.'Check Out From' && 'Check Out To' >= ThisItem.'Check Out To' ) ) = 0, true, false )

Do check out if the conditions and individual values are getting populated

Hope this helps
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Yatz,

I think the logic behind you formula does return the same result using your if statement.

Here is the thing, the formula you provided will compare each row with all the records from your data source, so the result returned by the Filter() fucntion always not empty.

The reason is that there is always at least 1 record meet the condition.

The above is based on your formula.