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

Like (0) Share

Report

Posted on 13 Dec 2022 10:31:13 by 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.

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 comparison.

Can anyone help me here?

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.

Categories:

Using Apps Using Formulas

All responses (9)

Answers (2)

Dziubek 2 on 01 Mar 2023 at 01:09:10

Like (0)

Report

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

@NarendarYadav Which formula worked for you?
NarendarYadav 19 on 16 Dec 2022 at 05:33:42

Like (0)

Report

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

It worked but the app is really slow. Can we do anything to make it little faster ?
NarendarYadav 19 on 16 Dec 2022 at 05:32:00

Like (0)

Report

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

Thank you all. It worked.
NarendarYadav 19 on 16 Dec 2022 at 05:23:01

Like (0)

Report

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

Hi @cha_cha
I have the selected following fields in PowerBi
1. Patient_No
2. Patient_Name
3. Action_Button
Verified answer

NarendarYadav 19 on 15 Dec 2022 at 12:04:10

Like (0)

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

Hi @LaurensM,
I tried this
LookUp(Sheet1, Patient_No = First(PowerBIIntegration.Data).Patient_No)
Error Message : Name isn't valid. 'Patient_No' isn't recognised.

LookUp(Sheet1, Patient_No = First(PowerBIIntegration.Data).Patient_No).FieldNameToDisplay
Error Message: Name isn't valid. 'Patient_No' isn't recognised. Name isn't valid. 'FieldNameToDisplay' isn't recognised
cha_cha 4,909 Super User 2025 Season 1 on 15 Dec 2022 at 12:01:18

Like (0)

Report

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

Can you please share what are the fields selected in the PowerBI?
NarendarYadav 19 on 15 Dec 2022 at 11:59:01

Like (0)

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

Hi @cha_cha ,
I tried both the suggestions and both showed errors.
LookUp(Sheet1, Patient_No = First(PowerBIIntegration.Data).Patient_No)
Error Message : Name isn't valid. 'Patient_No' isn't recognised.

LookUp(Sheet1, Patient_No = Value(First(PowerBIIntegration.Data).Patient_No))
Function 'Value' has invalid arguments.
Verified answer

cha_cha 4,909 Super User 2025 Season 1 on 13 Dec 2022 at 10:40:22

Like (1)

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

Hello @NarendarYadav

LookUp(Sheet1, Patient_No = First(PowerBIIntegration.Data).Patient_No)
LookUp(Sheet1, Patient_No = Value(First(PowerBIIntegration.Data).Patient_No))
Please try the two above.

✔️
Just in case my response helped you solve your problem, please mark/accept this as a SOLUTION. This helps community members if they experience a similar issue in the future.

🔗
🕸bistek.space 🐦 @cha_bistek 📺 @BisTekSpace
LaurensM 12,510 Super User 2025 Season 1 on 13 Dec 2022 at 10:40:02

Like (0)

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

@NarendarYadav could you try the following adjustment:

//With the function below you will be comparing the Patient_No fields LookUp(Sheet1, Patient_No = First(PowerBIIntegration.Data).Patient_No).FieldNameToDisplay
The last .FieldNameToDisplay is optional. Remove this if you want to display it as a record in a gallery. If you want to display it in a Text Control, you will need to specify the field.

If I answered your question, would you be so kind as to accept it as a solution.
Thanks!