Combo box is populated from another table

(0) Share

Report

Posted on by MooseBot88

167

I am new to powerapps and I am looking to populate the choices from one table

my combobox updates tbMain table field status

the data I want it to come from tbStatus field status

Hope you can help.

All responses (8)

Answers (1)

MooseBot88 167 on at

Like (0)

Report

Re: Combo box is populated from another table

This has sorted it.
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Combo box is populated from another table

Hi @moosebot88,

Have you solved your problem?

Do you want to populate the combo Box with the status from the tbStatus?

Could you please share a bit more about your form, do you remove the original Text input and replace it with a Combo Box?

If you have replaced the text box with a Combo Box, please try as below.

Set the Items property of the Combo Box as below:

tbStatus.Status

Set the Update property of the data card as below:

DataCardValue16.Selected.Status
MooseBot88 167 on at

Like (0)

Report

Re: Combo box is populated from another table

Hi

This seems to populate the text box but gives an error on the update property "DataCardValue16.Selected.Value"?

I have built the form via the wizard and removed the card and inserted again changing the type to accepted value to build the combobox?
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
Re: Combo box is populated from another table

Hi @moosebot88

1. Make sure your excel is formatted as Table
2. Specify the table name (default is Table1)

Example

Make sure to Add excel file as connector and Set the Items property to

StatusTable.Column1
MooseBot88 167 on at

Like (0)

Report

Re: Combo box is populated from another table

I have an excel spreadsheet on my OneDrive as the source.
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Re: Combo box is populated from another table

Hi @moosebot88

Please share the information about your data source to troubleshoot further. Dataverse or Sharepoint or SQL?
MooseBot88 167 on at

Like (0)

Report

Re: Combo box is populated from another table

I get an error "There is an error in this formula. Try revising the formula and running it again.
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Re: Combo box is populated from another table

Hi @moosebot88

To fill the combo box. Set the items property of other tables like
Choices('tbStatus'.status)