cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RobbyDLZ
Level: Powered On

CountRows with a filtered column

Dear all,

 

I created in Sharepoint a database "Audit" with several columns, one of them call "Channel", where we enter the name of the audited channel.

In Powerapps, I would like to count the number of each audit by channel.

You will find below the formula I use, but it doesn't work :

 

CountRows(Filter(Audit2, Channel=Ch5))

 

Thanks for your help.

4 REPLIES 4
Meneghino
Level 10

Re: CountRows with a filtered column

Hi @RobbyDLZ
Strings need to be in double quotes:

CountRows(Filter(Audit2, Channel="Ch5"))
RobbyDLZ
Level: Powered On

Re: CountRows with a filtered column

Many thanks Meneghino but it doesn't work !  There is a red underline under 'channel' ...  Man Sad

 

When I place the arrow of my mouse above 'channel', there is a textbox appear with "Invalid name" !?!?

Meneghino
Level 10

Re: CountRows with a filtered column

What is the column type of Channel? (i.e. text, lookup etc.)

Also, did you initially name the column something else and then changed to Channel?

You can check in SP what the internal name of the column is by navigating to the column properties and then looking at the web address.

PowerApps uses the internal name, so in my example below the field would be x0031 etc.

__.JPG

RobbyDLZ
Level: Powered On

Re: CountRows with a filtered column

Hi guys,

 

All my apologies to write you in late...

My issue has been fixed, the error went from an unknow name of column so I redo my table in Sharepoint and now it works Man Happy

 

Many thanks for your support .

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 104 members 4,230 guests
Please welcome our newest community members: