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

I have the same question (0)

All responses (7)

Answers (0)

gcmfaizan 1,022 on at

Like (0)

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

Was this reply helpful? Yes No
jeremyncs 47 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
gcmfaizan 1,022 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
jeremyncs 47 on at

Like (0)

Report

This is the syntax error.

Was this reply helpful? Yes No
gcmfaizan 1,022 on at

Like (0)

Report
Can you confirm the column type of the Primary Project Manager Email?

More ever can you wrap varProjectManagerEmail in Text function like:

Text(varProjectManagerEmail)

Was this reply helpful? Yes No
gcmfaizan 1,022 on at

Like (0)

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

Was this reply helpful? Yes No
jeremyncs 47 on at

Like (0)

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

Was this reply helpful? Yes No