You’re offline. This is a read only version of the page.
216
Hi! I am having trouble getting a LookUp function with two conditions to work.
What I'm trying to do:
Return the status (from a SharePoint list called 'Request Suppliers') in a dropdown (DefaultSelectedItems property). The status should be a LookUp of the Supplier's name (from 'Request Suppliers') & the RequestID (from 'Request Suppliers').
The RequestID is fixed, the user cannot select it, but the Supplier is a dropdown and can be selected by the user.
The problem:
I'm getting an error message saying: "Incompatible types for comparison. These types can't be compared: Table, Table".
Can anyone help? Why isn't a table compatible with a table?
Thanks!
rk that has 2 conditions.
I got it to work by using the formula:
Share
Report
All responses (
Answers (
[LookUp('Request Suppliers', RequestID = editRecord.RequestID && First(Supplier).DisplayName = DataCardValue13.Selected.DisplayName, Status)]​
However, while this is working as expected, it is giving me a delegation warning that it may not work on large data sets, so I'm sure this formula can be improved on. Since it works though, I'm marking it as the solution.
