I have two sharepoint lists that I am connected to in my project. I want a Data table that only shows entries where the ID in my current table, is equal to the Last('Sharepoint List1').ID. I'll give an example of the formula I'm trying to get to work.
This doesn't work, and tells me that the "=" is an "invalid argument type"
I'm placing this formula in the OnVisible for the page where the Data table is located.
Also I think it's worth mentioning that the ID value in "Sharepoint List1" is the automatically generated hidden ID value that sharepoint lists make, while the ID1 value in "Sharepoint List2" is one that I've made to reference the hidden ID from the other list.