You’re offline. This is a read only version of the page.
Announcements
Hi there,
I have a Sharepoint List called "Locations" which contains number column called "Node ID". This is an ID for the row. It is not using SP default ID column.
I have another table that Appointment that has a lookup field to the Node ID of the Locations table.
I'm building the datasource for a gallery as below;
Share
ReportAddColumns(
'Locations',
"AppointmentStatus",
Filter(
'Appointments',
'Node ID'.Value = 'Locations'[@'Node ID']
)
)
It gives me a Warning of "Incompatible types for comparison. These types can't be compared: Text, Number.
How do I compare number to number here?
Thanks!
Hi @swmk_stephen ,
Firstly, you need to ask yourself why you are using a lookup column at all (I have not for years and this would be simple and Delegable - which this is not - with a number column), however you also need to add the field name from Appointments that is relevant here. The other problem when you use a lookup in SharePoint on a number column is that is presents as Text, so
All responses (
Answers (
153,084
AddColumns(
'Locations',
"AppointmentStatus",
LookUp(
Appointments As aApp,
Value(aApp.'Node ID'.Value) = 'Node ID'
).YourFieldName
)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Visit my blog Practical Power Apps
