Select using ID of a reference column

[adambc]

Hello,

I am trying to do a select that uses the ID of reference column, but cannot get it work.

ANY(
SELECT(
Result[ID],
[Parent_ID] =
TEXT([Prev Parent Record].[ID])
)
)

[Prev Parent Record].[ID] is the key value of the table. I believe this has something to do with the issue.

Any help would be appreciated.

[adambc]

Dug in further. The way this is working is not making sense.

Created a virtual column to get the ID value = “f438dfb8”

Manually put the ID value into the column and the function works as expected.

ANY(
SELECT(
Result[ID],
[Parent_ID] =
“f438dfb8”
)
)

Yet, when I replace the value with a virtual column of type Text that is returning the same “f438dfb8” it returns nothing.

ANY(
SELECT(
Result[ID],
[Parent_ID] =
[Prev Parent Record ID]
)
)

[Aleksi]

Try…

ANY(
SELECT(
Result[ID],
[Parent_ID] =
[_THISROW].[Prev Parent Record ID]
)
)

[MultiTech]

Or

Lookup([_THISROW].[Prev Parent Record ID], Result, Parent_ID, ID)