Forum Discussion
lookup function in PowerApp has an error even when the datatypes are same
Hi,
I am trying to create an app using power apps.
I have connected the desktop application and PowerApp to read the data from google sheets. The datatype are same for column called patient_no.
I tried to combine the data by converting but it didnt work.
1. LookUp(Sheet1, Patient_No = First(PowerBIIntegration.Data), Patient_No)
2. LookUp(Sheet1, Patient_No = First(PowerBIIntegration.Data), Int(Patient_No))
3. LookUp(Sheet1, Int(Patient_No) = First(PowerBIIntegration.Data), Int(Patient_No))
4. LookUp(Sheet1, Int(Patient_No) = First(PowerBIIntegration.Data), Patient_No)
but none seems to be working.
Incompatible types for comparision.
Can anyone help me here ?
As this is a power app related issue you may find more luck getting an answer on the power apps forums found here: Power Apps Forums
2 Replies
- Seanan
Solution Supplier
As this is a power app related issue you may find more luck getting an answer on the power apps forums found here: Power Apps Forums
- NarendarYadavNew Member
Thank you.