Forum Discussion

NarendarYadav's avatar
NarendarYadav
New Member
3 years ago
Solved

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 ?