"The 'Value' formula has some invalid arguments'...

[WebPortal]

This formula is OnSelect of a button.

Table A and Table B are extracted from Excel:

ForAll(
TableA,
ForAll(
TableB,
If(
Value(TableA[@ColumnA]) = Value(TableB[@ColumnA])

....

I get the syntax error: "The 'Value' formula has some invalid arguments'.

Sure, but which errors?

So, if I remove the Value to:

Value(TableA[@ColumnA]) = TableB[@ColumnA]

I now get the error on the equal sign.

Any ideas?

I have another app with exactly the same formula and it works, this seems too erratic, but maybe I'm doing something wrong here.

[gabibalaban]

Hi @WebPortal ,

Use:

ForAll(
TableA As myFirstTable,
ForAll(
TableB,
If(
Value(myFirstTable.columnA) =Value(columnA)

....

Hope it helps !