lookup function in PowerApp has an error even when the datatypes are same

[NarendarYadav]

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 ?

[NarendarYadav]

Thank you.

[Seanan · Accepted solution]

Hi @NarendarYadav 

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