Answered

How to display 1 Cell value based on 2 inputs

(0) Share

Report

Posted on by bbx

Hi there, I am trying to create a power apps using 2 different drop down inputs, to display 1 value, for example, choosing 1 and 1/1/2023 to display 39723. How do I do that? This data is stored as an excel sheet

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbx ,

If you would like to display a field value based on selected column and row values, you'll need below formula:

LookUp(Table, Date = DateDropdown.Selected.Value, Switch(ColumnDropdown.Selected.Value,"1",1,"2",2))

Best regards,

Was this reply helpful? Yes No
bbx 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni ,

So I will have to create 2 different drop downs with the relevant options, then use a text label with the above formula?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bbx ,

The formula is specific to your requirement that you have two dropdowns and one text label.

Best regards,

Was this reply helpful? Yes No
bbx 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni ,

I am unable to create the dropdown for choosing either 1 or 2. Could you maybe show how to create the dropdown for choosing the columns?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbx ,

It should be a static table with only the column names in Text:

["1","2","3",...]

Best regards,

Was this reply helpful? Yes No
bbx 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni

I have tried as you mentioned, but I am unable to display the desired result, for the ColumnDropdown options, I linked it to a separate table

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbx ,

Please show me the Items property of the two dropdowns. If you use a fixed table in column dropdown, there shouldn't be the error in that part:

Items of DateDropdown should be the follow:

TableName.Date

and formula:

LookUp(Table, Date = DateDropdown.Selected.Date, Switch(ColumnDropdown.Selected.Value,"1",1,"2",2))

Best regards,

Was this reply helpful? Yes No
bbx 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni

I have tried using your suggestions, only thing the LookUp function doesn't show the value that I want, it only shows either 1 or 2

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bbx ,

Sorry, it seems the LookUp function doesn't accept Switch function result to determine the display column. Please try below formula:

Switch(ColumnDropdown.Selected.Value,"1",LookUp(Table, Date = DateDropdown.Selected.Date).1,"2",LookUp(Table, Date = DateDropdown.Selected.Date).2)

1 and 2 should be the internal column name from excel table. So you should be able to select from hint dropdown when pressing a dot after LookUp function.

Best regards,

Was this reply helpful? Yes No
bbx 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni

Thank you so much for your help! It works now, I just need to expand this for a much bigger data set. Thanks!

Was this reply helpful? Yes No