cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,671)