What am I missing here?

Austin · 04-05-2021 02:32 PM

What am I missing here? I’m returning 2 lists of text and an empty list of text.

Austin

WillowMobileSys

Uh, you haven’t shown what your return value is assigned to.

If all that looks good, then just save the app to see if it actually goes through. I have had occasions where the assistant showed me errors, I couldn’t find anything wrong, so I saved and then re-inspected and all was good.

Austin

It’s in a valid if. For whatever reason both columns being keys is what is causing it even though that should make -2 difference since its just a text field.

Suvrutt_Gurjar

If I may add, I believe since the expression uses keys of two different tables, the valid_if points to a list of reference values that point to two different tables. This I believe leads to the error in expression.

If one creates two VCs say one each on the respective tables that simply copy the key column and then use them in valid_if, I believe the error will not show.

Two VCs can be [SKIP_REASON V] with an app formula [SKIP_REASON] and [REASON V] with an app formula [REASON]

Please try using these VCs in the IFS() expression in Valid_if

Steve

This.

Austin

Still seems like a bug cause a list of reference values and a list of text work just find for it. I mean what if I had like 4-5 tables that I needed to pull into this valid if? I would need to make 4-5 VCs that would be cluttering up my tables just to get the value of the keys.

Suvrutt_Gurjar

Correct. I think, error detection, also depends on how functions are built. Instead of creating so many VCs , you could alternatively try to use use a nested IF() instead of IFS(), something like

IF([Decision]=“Offer Position”, Table 1[SKIP_REASON], IF([Decision]=“Disposition”, Table 2[Reason], LIST(" ")))
As per my understanding, IF() will not give error even if you use key columns directly.

Steve

IFS(
  cond1,
    (LIST() + table1[column1]),
  cond2,
    (LIST() + table2[column2]),
  cond3,
    default
)

Suvrutt_Gurjar

Hi @Steve ,

Wow. Brilliant use of LIST() to nullify ref flavor from the list.

My testing also showed that IF() also seems to do the job in place of IFS() . Could you guide on any specific reason IF() works but not IFS(), I mean even when directly used with key column list.
Edit: added some more description.

Steve

Probably just a bug, probably with IFS(). I’ve found IFS() has several very obscure bugs.

Suvrutt_Gurjar

Got it. Thank you @Steve

Fabian_Weller

Me, too. I found that if an IFS() expression is not working as you think it should, just use IF() and it will work We should post this in the Tips & Tricks