Answered

Combining formulas

(1) Share

Report

Posted on by Jamep2

Hi. Can someone help me with combining formulas please? I have two formulas that filter a gallery and both work individually however I can't seem to combine them. I need the gallery to show only items where the "open for votes" column = "yes" AND the "added to backlog date" column equals the current month. Here are the individual formulas that work.

Formula 1:

Filter('PORT Enhancements Backlog','Open for Votes'.Value = "yes")
 
Formula 2:
Filter('PORT Enhancements Backlog',Month('Add to Backlog Date')=Month(Now()))
 
My attempt to combine them which doesn't work:
Filter('PORT Enhancements Backlog', 'Open for Votes'.Value = "yes" And Month('Add to Backlog Date')=Month(Now())))
 
I get an error that says "incompatible types for comparison. These types can't be compared: text, Number.

Categories:

Using Apps Using Formulas

All responses (5)

Answers (1)

Jamep2 21 on at

Like (0)

Report

Combining formulas

That did it! @Micheal E. Gernaey Thanks so much for taking the time to provide a solution AND explain it. I'm only about a month into this application and still so much to learn so I appreciate you greatly!
Verified answer

Michael E. Gernaey 38,427 Super User 2025 Season 1 on at

Like (0)

Report
Combining formulas

@Jamep2

Thanks for the picture.

wait that is not an error, That is a Warning for Delegation

Totally different issue. It will only show because you are using And

We would have to build an entirely different Filter like this.

So let me explain. We are using With to do the first Filter and assigning the results to a temporary in memory table of records

Then we do the second filter on that so we avoid the Delegation Warning, which WOULD mess up your results by the way

With ( { FirstLevelFilter: Filter('PORT Enhancements Backlog','Open for Votes'.Value = "yes") }, Filter(FirstLevelFilter, Month('Add to Backlog Date')=Month(Now())) )

please mark as the answer and if you would like a Like also :-)
ronaldwalcott 1,988 on at

Like (0)

Report

Combining formulas

One possibility is Power Apps may be applying a short-circuiting evaluation for this condition

Filter('PORT Enhancements Backlog',Month('Add to Backlog Date')=Month(Now()))

and not for the combination.

Is 'Add to backlog Date' ever blank, if so consider adding a !IsBlank('Add to Backlog Date') into the evaluation,

You would decide how you manage blank dates.
Jamep2 21 on at

Like (0)

Report
Combining formulas

Hi, @Michael E. Gernaey, thanks for the response. I see the typo you pointed out however when I remove it, I still get the same error: "incompatible types for comparison. These types can't be compared: text, Number. Not sure why they won't work together when they work individually. The Add to backlog date is a text string.

Filter('PORT Enhancements Backlog', 'Open for Votes'.Value = "yes" And Month('Add to Backlog Date')=Month(Now())
Suggested answer

Michael E. Gernaey 38,427 Super User 2025 Season 1 on at

Like (1)

Report
Combining formulas

Hi @Jamep2

You have a typo in the long version. Unless you took that out of a large expression.

But:

1) please always show a picture of the code an error, so we can see which part is highlighted.

2) I see no issues other than the typo

3) is Add to Backlog Date a string or a date?

Aside from the typo, I see no reason this wouldn't work as is, so once I see a picture where the squiggles are, I can help more.

Filter('PORT Enhancements Backlog', 'Open for Votes'.Value = "yes" And Month('Add to Backlog Date')=Month(Now())) should be Filter('PORT Enhancements Backlog', 'Open for Votes'.Value = "yes" And Month('Add to Backlog Date')=Month(Now())

If this solved your problem Please Mark as resolved and maybe a like :-)