web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Dropdaown box and exce...

Power Apps

Unanswered

Dropdaown box and excel sheet in canvas app

(0) Share

Report

Report

Posted on by Roar1

56

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 Img

All responses (2)

Answers Img

Answers (0)

Sort by

AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
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
a
(0)

Report
Copy link

Link copied!
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

Join the conversation