Dynamically Change ComboBox DataSource to Another Column After Publishing

(0) Share

Report

Posted on by KA-21110514-0

Hello Power Apps Community,

I am working on a Power Apps canvas application. In my form (screenshot attached), I have a ComboBox bound to a specific column in my data source. However, after publishing the app, It will automatically change to another column like compliance ID ComboBox to dynamically display data from a different column based on user input or other conditions.

For example, in the "District" field in the screenshot, I want it to initially display data from "Column A." After publishing, it automatically fetch another data from "Column B" instead.

Could you guide me on how to achieve this? Should I modify the Items property of the ComboBox, or is there another best practice for this scenario?

Any examples or steps would be greatly appreciated!

Thanks in advance!

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Suggested answer

SaiRT14 1,992 Super User 2025 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

pls try below steps:

Use a variable to track which column or data source the ComboBox should display. Update this variable based on user actions or app logic. UpdateContext({ SelectedColumn: "ColumnA" })

Use an If statement in the Items property to dynamically determine the data source or column based on the variable. If(
SelectedColumn = "ColumnA",
Filter(DataSource, ColumnA <> Blank()), // Display data from ColumnA
Filter(DataSource, ColumnB <> Blank()) // Display data from ColumnB
)

Use a control like a Dropdown or Button to change the SelectedColumn variable dynamically. OnChange = UpdateContext({ SelectedColumn: Dropdown1.Selected.Value })

Initialize the SelectedColumn variable in the app’s OnStart property to set the default column. Set(SelectedColumn, "ColumnA")
Suggested answer

ronaldwalcott 3,914 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Is this really what you want to do? Sounds like a recipe for data integrity issues.

Are you saying that you have a column bound to a combobox and you want to conditionally set the items that can be selected but there isn't a relationship between the items.

This seems implied here

I have a ComboBox bound to a specific column in my data source. However, after publishing the app, It will automatically change to another column like compliance ID ComboBox to dynamically display data from a different column based on user input or other conditions.

Or do you want to display comboboxes in the same location on the screen bound to different columns. You would set the visibility based off some condition or user input?