Create canvas app buttons on specific screen using excel data dynamically

Like (0) Share

Report

Posted on 17 Feb 2022 09:23:40 by lisha

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?

Categories:

Connectors

Using Apps Using Formulas

All responses (1)

Answers (0)

PowerRanger 3,458 Super User 2024 Season 1 on 17 Feb 2022 at 09:34:05

Like (0)

Report
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.