Pretty much the title; I already have a relation column linking from current table to “desired” table. The problem is that while I can set column values on the “desired” table as an action, I cannot use the values in the “desired” table for an “if” condition. Is there a workaround to this?
A relation is a link to an entire row or series of rows. Not any one specific column. Do you have any Lookup columns to retrieve any of the values from the relation, that you want to use in your IF condition?
I found it weird because I was able to set values in specific columns on the “desired” table using the relation column. I think using Lookup columns on the current table might be the answer, I’ll let you know if it works.
It’s kind of a different situation with a Set Column action though. You set the relation as a data source, and then it presents only the columns in that related table. It doesn’t present columns from the related table and current table at the same time. You need to choose one or the other.
On the other hand, the conditions are only based on data in the current table, so you need to use a Lookup columns to bring that value into the current table from the related table.
You are absolutely right, using Lookup columns was the answer, tysm. I tried looking through the documentation for exactly this comment you just wrote, i hope its added in the future.