Unanswered

HELP on LOOKUP Function

(0) Share

Report

Posted on by jeremyncs

Hi,

I have a excel sheet with Table 1 with column name 'Project Code'. In the PowerApp i have a dropdown selection box name as Dropdown1 and I just want to return the email address in the text input box.

On the text input box, I written the formula as LookUp(Table1,'Project Code'=Dropdown1.Selected.'Project Code', 'Project Manager Email').

There is a syntax error as shown below:

Please advice how to resolve the above issue. Is my formula written wrongly? Appreciate someone out

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jeremyncs ,

can you try this formula on Dropdown1 OnChange propert with UpdateContext function like:

UpdateContext({varProjectManagerEmail: LookUp(Table1, 'Project Code' = Dropdown1.Selected.'Project Code', 'Project Manager Email') })

Then in the text box Text property use variable varProjectManagerEmail to display the value.

Please mark my post as a solution to help others.

Cheers!
jeremyncs 47 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for your advice!

I did that. I still received the same syntax error. I placed the variable varProjectManagerEmail on the textbox as shown below.
Did I do it wrongly?
gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you show me the screenshot of this variable from the left menu by clicking the {x} icon and then opening this variable in view mode?
jeremyncs 47 on at

Like
a
(0)

Report
Copy link

Link copied!

This is the syntax error.
gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!
Can you confirm the column type of the Primary Project Manager Email?

More ever can you wrap varProjectManagerEmail in Text function like:

Text(varProjectManagerEmail)
gcmfaizan 1,022 on at

Like
a
(0)

Report
Copy link

Link copied!
Ok I got it,

onChange property of drop-down use the formula like this:

UpdateContext({varDDSelected: Dropdown1.Selected.'Project Code''}); UpdateContext({varProjectManagerEmail: LookUp(Table1, 'Project Code' = Value(varDDSelected), 'Project Manager Email') })

firstly, try the above code if it works that's great. if not try this formula:

UpdateContext({varDDSelected: Dropdown1.Selected.'Project Code''}); UpdateContext({varProjectManagerEmail: LookUp(Table1, 'Project Code' = Text(varDDSelected), 'Project Manager Email') })

Then in the text box Text property use the variable varProjectManagerEmail to display the value.

I'm very hopeful now it works.
And please mark my posts as the solution. to help comunity.
jeremyncs 47 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi, thanks for your advice. Over the weekend, I try to change the variable name on the excel from Project Code to Project_Code and Project Manager Email to Project_Manager_Email.

I used back your original syntax and modified based on the new variable name:
UpdateContext({varProjectManagerEmail: LookUp(Table1, Project_Code = Dropdown1.Selected.Project_ Code, Project_Manager_Email) })
Now is working as it was expected.