Unanswered

Issue With PowerApp Fuction

(0) Share

Report

Posted on by jasperxx

Data Source is a Excel Table. When the user select the required information from the combo box and if they click Evaluate, it intended to show the require information from excel. However, its not working. Below is the code that I used.

If(
GHSDropDown.Selected.Value = "Yes",
Set(
ResultPanel.Text,
LookUp(GHSLabel, CountryGHSLabel = CountryDropDown.Selected.Value).ResultGHSLabel
),""
)

but it showed

Categories:

Building Power Apps

All responses (10)

Answers (0)

Sort by

EddieE 4,650 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@jasperxx

I think you have your structure incorrect. I think you maybe trying to do this:

Set( vResultPanel, If( GHSDropDown.Selected.Value = "Yes", LookUp( GHSLabel, CountryGHSLabel = CountryDropDown.Selected.Value).ResultGHSLabel, "" ) )

The, set you ResultPanel.Text to

vResultPanel
jasperxx on at

Like
a
(0)

Report
Copy link

Link copied!

Still not working
EddieE 4,650 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@jasperxx

Sorry, I cannot read your images, they are too blurry
jasperxx on at

Like
a
(0)

Report
Copy link

Link copied!
EddieE 4,650 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@jasperxx

What column type is CountryGHSLabel? IF it's a Choice column then try

Set( vResultPanel, If( GHSDropDown.Selected.Value = "Yes", LookUp( GHSLabel, CountryGHSLabel.Value = CountryDropDown.Selected.Value).ResultGHSLabel, "" ) )

If this doesn't work can you share your Items for GHSDropDown
jasperxx on at

Like
a
(0)

Report
Copy link

Link copied!

It is some simple string in the excel table.

As for Dropdown it links to another table.
EddieE 4,650 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@jasperxx

Can you please provide the Default & Items code for the GHSDropDown
jasperxx on at

Like
a
(0)

Report
Copy link

Link copied!
jasperxx on at

Like
a
(0)

Report
Copy link

Link copied!
EddieE 4,650 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@jasperxx

Whilst posting images can be helpful what is more helpful is actual code. Using the insert/edit code sample option (</>) is the best way to convey your message.

I'd suggest re-posting your question so that someone else with use in Excel can help you. I simply don't have the time to click through many images, most without the content I need, to try and help you further, sorry.

All the best.