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 :
Thanks for your help.
Hi @RobbyDLZStrings need to be in double quotes:
Many thanks Meneghino but it doesn't work ! There is a red underline under 'channel' ...
When I place the arrow of my mouse above 'channel', there is a textbox appear with "Invalid name" !?!?
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.
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
Many thanks for your support .
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.