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.
Hi @WebPortal ,
Use:
ForAll(
TableA As myFirstTable,
ForAll(
TableB,
If(
Value(myFirstTable.columnA) =Value(columnA)
....
Hope it helps !
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
191 | |
66 | |
45 | |
42 | |
20 |
User | Count |
---|---|
244 | |
120 | |
83 | |
74 | |
69 |