Unanswered

Boolean logic "And", "&&&&" functions incorrect work

(0) Share

Report

Posted on by ledarchenko

Hello everyone!

I have IF function and in this condition I have incorrect operation of the "AND" operator. As you see all condition return true

If select arguments separately we saw that one argument gives false and other true:

Why all condition gives true?

If change JS syntax to Function same issue:

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@bezdelnik

Please consider changing your Formula to the following:

If((Weekday(startTime, StartOfWeek.Monday) < 6) && !(LookUp('Days Off', 'Day Off' = startTime, true)), ......

See if that make a difference for you.

I hope this is helpful for you.

Was this reply helpful? Yes No
ledarchenko 6 on at

Like
a
(0)

Report
Copy link

Link copied!

The same
And Weekday argument still false separately

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@bezdelnik

I've seen that odd behavior before and it always seems to end up being something wrong in the overall formula.

You can try to pull this into a separate scoped action.

ex.

Body: With({_weekDay: Weekday(startTime, StartOfWeek.Monday), _item: LookUp('Days Off', 'Day Off' = startTime) }, If((_weekDay < 6) && IsBlank(_item.ID), ...... ) ), ....

See if that sheds any light on it.

Was this reply helpful? Yes No
ledarchenko 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Selecting condition not show result bellow now. Also I get errors with my "ThisRecord" variable:

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@bezdelnik

Yes, I would avoid the ThisRecord in most cases anyway as it will usually refer to a record other than what you expect.

Yes, you will not be able to see the result of a highlighted section like you have in the editor as _weekDay is out of context for it as it is defined in the scoped With variable. But you can highlight the formula in the With definition.

Can you share the entire formula so that I can get a sense of the whole thing in context?

Was this reply helpful? Yes No
ledarchenko 6 on at

Like
a
(0)

Report
Copy link

Link copied!

It just notification when you book workplace in office. I have two templates, for weekend and holidays and for work days

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@bezdelnik

Actually, it is still out of context as it is only that part of the formula. If you can copy the entire formula and present that.

If you don't want to post it directly in a public forum, you can send a private message to me (through the forum email icon at the top) with it in so I can see the whole context and help from there.

Was this reply helpful? Yes No