Unanswered

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

(0) Share

Report

Posted on 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:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (2)

LaurensM 12,516 Moderator on at

Like (0)

Report
@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!

Was this reply helpful? Yes No
Verified answer

cha_cha 4,932 Moderator on at

Like (1)

Report
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

Was this reply helpful? Yes No
NarendarYadav 19 on at

Like (0)

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

Was this reply helpful? Yes No
cha_cha 4,932 Moderator on at

Like (0)

Report

Can you please share what are the fields selected in the PowerBI?

Was this reply helpful? Yes No
Verified answer

NarendarYadav 19 on at

Like (0)

Report
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

Was this reply helpful? Yes No
NarendarYadav 19 on at

Like (0)

Report

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

Was this reply helpful? Yes No
NarendarYadav 19 on at

Like (0)

Report

Thank you all. It worked.

Was this reply helpful? Yes No
NarendarYadav 19 on at

Like (0)

Report

It worked but the app is really slow. Can we do anything to make it little faster ?

Was this reply helpful? Yes No
Dziubek 2 on at

Like (0)

Report

@NarendarYadav Which formula worked for you?

Was this reply helpful? Yes No