Using a column as a variable in Power Query function

[PANDAmonium]

Hi All,

I'm trying to create a function that reutrns a list based on the value of another column, but for the life of me can't figure out something seemingly basic. Hopefully you can help...

So I have a table that's basically this:

Id  | Condition A? | Condition B?

1   |   TRUE          |  FALSE

2   |   TRUE          | TRUE

3   |   FALSE         | TRUE

So my function should return the list of Id's where the condition is true, if I pass "Condition A" it should return {1, 2}. B should return {2, 3}. So this is what I have so far.

= let ListValuesByCondition= (DataTable as table, ReturnColumn as text) =>
Table.ToList(Table.SelectColumns((Table.SelectRows(DataTable, each ([#"Condition A?"] = true))), ReturnColumn))
in ListValuesByCondition

= FN_ListValuesByCondition(#"My Table", "Id")

But I want to pass the condition column ( ex: [#"Condition A?"] ) as a variable. And making it type list return nothing. Sounds like it's something obvious, but I haven't had much luck finding solutions. Thank you in advance!

[PANDAmonium · Accepted solution]

Figured it out shortly after posting, but here's the solution in case anyone runs into the same.

So we're actually referencing a field instead of a column, and we can't use brackets since it will take the literal of the variable name. So instead we need to use Record.Field. It should look like:

= let ListValuesByCondition= (DataTable as table, ReturnColumn as text, ConditionColumn as text) =>
Table.ToList(Table.SelectColumns((Table.SelectRows(DataTable, each (Record.Field(_, ConditionColumn) = true)), ReturnColumn))
in ListValuesByCondition

= FN_ListValuesByCondition(#"My Table", "Id", "Condition A?")