web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Create canvas app buttons on specific screen using excel data dynamically

(0) ShareShare
ReportReport
Posted on by 80

Hi Everyone,

 

I have one question that can we create a canvas app in which create buttons automatically by taking data from an excel file(like the data present in the column and rows) which makes the app dynamic. So that when we want to change or add more buttons, labels, or any other action on the screen, we can change/add on the excel and it will automatically be generated on power apps?

 

I have the same question (0)
  • PowerRanger Profile Picture
    3,458 Super User 2024 Season 1 on at
    Re: Create canvas app buttons on specific screen using excel data dynamically

    @lisha Yes and no... 🙂

     

    No, you can't dynamically add a button to the canvas. You can hide or show existing buttons depending on conditions.

     

    Yes, you could add a Gallery to dynamically "create" buttons (actually rows in your Gallery). But in such a scenario you still have to pre-define what a button should do. As each button will follow the same logic you have to add the Logic to the OnSelect property and have a formular something like that

     

    Switch(
     ThisItem.method,
     "Method 1",
     Set(
     varBlaBla,
     "123"
     ),
     "Method 2",
     ClearCollect(
     colWhatEver,
     SampleList
     )
    )

     

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 686 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 433 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 266 Moderator

Last 30 days Overall leaderboard