AddColumns Filtering, can't reference filtered ID

(0) Share

Report

Posted on by JamesSnaps

187

I've got a relatively simple formula I'm getting stuck on.

ClearCollect(progressCheck,AddColumns(Filter(progressQuestions,topicID=3),"totalAnswers",CountRows(Filter(progressAnswers,questionID=xxxx))))

It's in the second part, where I'm trying to filter the questionID. It should filter based on the ID of the current 'progressQuestions' row. If I remove the first filter and just reference progressQuestions as is, I can run this successfully. But when I am filtering the initial source, I am unable to reference the ID to filter a second time as it just throws up an error when I try.

Have tried a few combinations, but maybe I'm missing something, if anyone has any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

JamesSnaps 187 on at

Like (0)

Report

Typical, solved it immediately after posting. Had to reverse the formula a bit.

ClearCollect(progressCheck,Filter(AddColumns(progressQuestions,"totalAnswers",CountRows(Filter(progressAnswers,questionID=progressQuestions[@ID]))),topicID=3))

Was this reply helpful? Yes No