Unanswered

Dropdaown box and excel sheet in canvas app

(0) Share

Report

Posted on by Roar1

I have two sheets in an excel OneDrive. I have created a canvas app in that I have a drop down box. Inside the dropdown box I need these two sheets name. If I select one sheet it should display as a data table. Is there a way to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

AARON_C 2,235 Most Valuable Professional on at

Like (0)

Report
Hi @Roar1,

If you only have the two options that will not change, for the Items property of your drop down you can hard code these values.
["Sheet 1", "Sheet 2"]

For the Visible property of your data table:
Dropdown1.Selected.Value = "Sheet 1"

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C

Was this reply helpful? Yes No
Roar1 56 on at

Like (0)

Report
I have tried this but still not working. Is there any specific function that I need give before this?
["Sheet 1", "Sheet 2"]

Was this reply helpful? Yes No