Combo box is populated from another table

(0) Share

Report

Posted on by MooseBot88

168

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Hi @moosebot88

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

Was this reply helpful? Yes No
MooseBot88 168 on at

Like (0)

Report

I get an error "There is an error in this formula. Try revising the formula and running it again.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report

Hi @moosebot88

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

Was this reply helpful? Yes No
MooseBot88 168 on at

Like (0)

Report

I have an excel spreadsheet on my OneDrive as the source.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (1)

Report
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

Was this reply helpful? Yes No
MooseBot88 168 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
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

Was this reply helpful? Yes No
MooseBot88 168 on at

Like (0)

Report

This has sorted it.

Was this reply helpful? Yes No