Unanswered

Load Combo box data - on demand

(0) Share

Report

Posted on by BenWip

Hi ,

I am new to Power Apps , We need to get the data from data source (shouldn't use collections) and load to combo box if user selects the combo box only .

Any idea on this.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @BenWip,

Too few details to understand what happened to you.

Generally, we populate a ComboBox with a Choice column by setting the Items property of the ComboBox with:

Choices(ListName.ChoiceColumnName)

However, if you populate it with a Text column, you should use the formula as below:

Distinct(ListName,TextColumnName)

Was this reply helpful? Yes No
BenWip 55 on at

Like (0)

Report

Hi @v-qiaqi-msft ,

Thank-you for your response. We tried the same. but by default , We shouldn't load the Combo box. If user select the combo box that time only we need to populate the data.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (1)

Report
Hi @BenWip,

Hope you could share a bit more about your scenario, what do you mean by "but by default , We shouldn't load the Combo box. If user select the combo box that time only we need to populate the data."?

Do you mean that only when users select ComboBox, it will load data?

If so, I think you could set a variable for the OnSelect property of the ComboBox:

Set(varItems,Choices(ListName.ChoiceColumnName))

Then set the Items property with this variable varItems. Not sure if you have this ComboBox within a form, if so, you could reset the variable on successfult submission.

Was this reply helpful? Yes No