Hey, I read from previous thread that we should not use [Display Column].ToText() in Filter if possible since it would not work if the Display Column changes.
I tried to use [Display Column].[Display Column Name] notation in Filter (see screenshot) but it could not reference to the correct value of the column successfully. It could work if I change to [Display Column].ToText() though.
Here is my sample test doc:
Hi @aso !
From what I’ve seen, the problem seems to be that you use a text field in your table
[DB People] to either store a row reference or a text value…
Meaning that in the
Filter() of your
ModifyRows() you’re comparing a simple text value (
[People ID]) to a list rows which could come from anywhere (
CurrentRow.People.[People ID]) and there doesn’t seem a way to go further and get the actual
ID needed .
What you could do in your
[DB People] table is to store directly the people’s
ID as a text value instead of a row reference so
[People ID] will be compared to another text value .
That’s a good catch! Thanks so much for your help!
My pleasure @aso !
Glad to know it helped you moving forward !
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.