Power Platform Community Forum Thread Details

Guys - I have seen numerous postings out there concerning this issue, but none that are specific to my issue.

More specifically, I have two collections that I am working with: totalAgentsByMetro and totAgentsByMetroCount, referenced here below. Could it be an issue w/ the length of the collection name? I tried reducing it a few characters, and even that did not work.

Here is my code snipet that is returning the error: Name Isn't Valid...totalAgentsByMetroCount is not valid.

ClearCollect(totAgentsByMetroCount, AddColumns(totalAgentsByMetro,AgentCount, CountRows(Filter('Agents', MetroArea = totalAgentsByMetro[@Result])));

In addition, I created a separate ClearCollect whereas, I was able to create the collection and create a table with rows. But the above never works...more specifically when using AddColumns although no errors appear here.

Categories:

Building Power Apps