Answered

Cant Add Two Filtered Values

(0) Share

Report

Posted on by Applications

Good morning all!

I'm trying to have a formula calculate two selected values from a PowerApp that populates a SharePoint list: Primary Date and Alternate Date.

Here is my current formula:

"Number of Participants Currently Enrolled For Your Selected Date: " & 
With({_items: Filter('North Campus Walking Tour Signup Tracker', 'Primary Date'.Value = DataCardValue4.Selected.Value)}, 
CountRows(_items))

It works well for the Primary Date, but for the alternate date, I can't get it to calculate correctly:

Number of Participants Currently Enrolled For Your Selected Date: " & 
With({_items: Filter('North Campus Walking Tour Signup Tracker', 'Alternate Date'.Value = DataCardValue4.Selected.Value)}, 
CountRows(_items))

I get the following error:

Lastly, I'm building an "admin view" for people that sign up, but since I can't get the Alternate Date to calculate correctly, the formula doesn't show the correct number:

Sum(
With({_items: Filter('North Campus Walking Tour Signup Tracker', 'Primary Date'.Value = "1 September")}, 
CountRows(_items)) 
&&
With({_items: Filter('North Campus Walking Tour Signup Tracker', 'Alternate Date'.Value = "1 September")}, 
CountRows(_items))
)

The error for this formula is:

Any thoughts on how to correct the formulas? Thank you!

Categories:

General Questions

Using Apps Using Formulas

I have the same question (0)

All responses (7)

Answers (1)

RandyHayes 76,291 Super User 2024 Season 1 on at

Like (0)

Report
Re: Cant Add Two Filtered Values

@Applications

In your formula you are specifying a table to compare to...that will not work.

If your 'Alternate Date' column is a date column, then your formula should be:

Number of Participants Currently Enrolled For Your Selected Date: " & With({_items: Filter('North Campus Walking Tour Signup Tracker', 'Alternate Date' = DataCardValue4.Selected.Value)}, CountRows(_items) )

However, the above is true if that column is a date column. I have a feeling that perhaps it is a Choice column in your list...please clarify.

If it is a choice column, then you most likely have that column defined to allow multiple values. Please clarify as well.

Was this reply helpful? Yes No
Applications on at

Like (0)

Report

Re: Cant Add Two Filtered Values

Correct, both the Primary and Alternate Date columns are choice columns, rather than Date columns.

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

Like (0)

Report

Re: Cant Add Two Filtered Values

@Applications

That is fine, but the more important part was the second thing for you to clarify - "then you most likely have that column defined to allow multiple values. Please clarify as well."

Was this reply helpful? Yes No
Applications on at

Like (0)

Report

Re: Cant Add Two Filtered Values

Ahh, apologies. The Alternate Date was a multiple selection column, yes - but I recreated it and it's now a single-selection column

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,291 Super User 2024 Season 1 on at

Like (0)

Report

Re: Cant Add Two Filtered Values

@Applications

If it is single select now, then your formula should work properly.

Is it??

Was this reply helpful? Yes No
Applications on at

Like (1)

Report

Re: Cant Add Two Filtered Values

It is, yes! I just cant mark as "Accept as Solution" because my work computer isn't letting me haha. But thank you so much! I'll mark it complete later 🙂

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

Like (0)

Report

Re: Cant Add Two Filtered Values

@Applications

No worries...just wanted to make sure you were good now.

Was this reply helpful? Yes No