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

All responses (8)

Answers (1)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @moosebot88

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

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

Hi @moosebot88

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

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(1)

Report
Copy link

Link copied!
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 168 on at

Like
a
(0)

Report
Copy link

Link copied!

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?
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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 168 on at

Like
a
(0)

Report
Copy link

Link copied!

This has sorted it.