CountRows datatable based on column value - bound to Sharepoint list / choice column

(1) Share

Report

Posted on by ctedesco3307

910

Need to count rows in datatable where Rank is a specific value. This is a SharePoint list and Rank is a choice column in SharePoint -- can't get right syntax

dtresponses is the datatable 'xxxDashboard Responses' is the SharePoint List

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (0)

Sort by

Suggested answer

MS.Ragavendar 7,222 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@ctedesco3307,

I am sharing the approach considering the delegation limit.

Instead of Rank Column -> I created one combo box with values of Offline and Online.

If user selected the value in the combo box and press the button i am calling power automate flow and passing the value of the selection (such as what he has selected i.e. offline or online)

Button On Select -

Set(vardata,

getcount.Run(ComboBox1_1.Selected.Value).count)

Power Automate Flow (getcount)

Compose - length(outputs('Get_items')?['body/value'])

Total Item Count

Backend data

Based on this you can extend this for your logic as well it will works.

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Suggested answer

Valantis 5,971 on at

Like (1)

Report
Copy link

Link copied!

Hi @ctedesco3307,

For a SharePoint choice column, the value is a record with a Value property, not a plain text string. So you need to compare against the .Value property:
CountRows(Filter(dtresponses, Rank.Value = "YourChoiceValue"))

Replace YourChoiceValue with the exact choice label text as it appears in SharePoint (case sensitive).

If you're filtering directly against the SharePoint list instead of the datatable:
CountRows(Filter('xxxDashboard Responses', Rank.Value = "YourChoiceValue"))

Note this is not delegable to SharePoint for choice columns so if your list has more than 500 rows it will only count from the first 500 records. For accurate counts on large lists, use a CountRows with a ClearCollect to load all records first.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
ctedesco3307 910 on at

Like (0)

Report
Copy link

Link copied!

@Valantis Thanks for this -- I'm using the datatable ... it does not like Value though ...

Was this reply helpful? Yes No
Suggested answer

Kalathiya 2,316 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @ctedesco3307,

Please try below code:

With({ _data:'dtresponses' }, CountRows(Filter(_data, Rank.Value = "Good")) ) //dtresponses - Replace with you list name if it's wrong //Rank - Replace with your column name from SharePoint list if it's wrong

With({ _data:'xxxDashboard Responses' }, CountRows(Filter(_data, Rank.Value = "Good")) ) //xxxDashboard Responses - Replace with you SharePoint list name //Rank - Replace with your column name from SharePoint list if it's wrong

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No
Suggested answer

Valantis 5,971 on at

Like (1)

Report
Copy link

Link copied!

Hi @ctedesco3307,

That error confirms the datatable is flattening the choice column to plain text. When a SharePoint choice column goes through a datatable, it loses the record structure and becomes a simple text value.

So the correct syntax is without .Value:
CountRows(Filter(dtresponses, Rank_Column1 = "YourChoiceLabel"))
Replace YourChoiceLabel with the exact text that appears in the datatable cell for that choice.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No
ctedesco3307 910 on at

Like (1)

Report
Copy link

Link copied!
@Valantis This works but it's not what I want

With({ _data:'xxxDashboard Responses' }, CountRows(Filter(_data, Rank.Value = "Good")) )

The user can filter the data table on three combo boxes and I want the count rows to be based on that filter result in the datatable

I can't get Value to work with Rank - it's not an option I have "Text" not Value

Was this reply helpful? Yes No
Kalathiya 2,316 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @ctedesco3307,

Simple Approach:

With({ _data:'xxxDashboard Responses' //Copy your Gallery items property code and Replace with "xxxDashboard Responses". }, CountRows(_data) )

Once you replace it will show count based on filter that you have applied. Or could you please share your Gallery Items Property code we will guide you..

If this helped resolve your issue, please click “Does this answer your question?” so the solution is marked and easier for others to find.

Was this reply helpful? Yes No
ctedesco3307 910 on at

Like (0)

Report
Copy link

Link copied!

Just to re-confirm - this is a data table - not a Gallery

Was this reply helpful? Yes No
Kalathiya 2,316 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @ctedesco3307,

Thanks, Then please copy the data table items property code and past into above formula. As I'm assuming you have already implemented the filter code in Data table.

With({ _data:'xxxDashboard Responses' //Copy your Gallery items property code and Replace with "xxxDashboard Responses". }, CountRows(_data) )

Was this reply helpful? Yes No
ctedesco3307 910 on at

Like (1)

Report
Copy link

Link copied!

@Kalathiya its a datatable not a gallery - I tried this already and does not work - see above -- thank you!!!

Was this reply helpful? Yes No