Help populating a ComboBox from outside data sources

(1) Share

Report

Posted on by WorkingRicardo

853

Hey! I'm editing a Sharepoint list form using PowerApps

Can someone do a step-by-step as to how would you go about populating the choices of a ComboBox?

I got one but getting this constant error: On the creation of a new register everything is perfect, I could search the 30k+ elements on all characters (search similar to Contain). I save my new register but when I go to edit that one on Sharepoint, this field is displayed as blank.

I thought that Excel with 30k+ elementos might be the problem but I tried a Sharepoint with 200 items and nope, same result.

So, maybe the wrong thing is how I'm trying to set this up. This is how I have been adding my ComboBoxes: I added the new field tied to the Sharepoint column of Interest, edited the ComboBox to be connected to my Excel table. Also changed DisplayFields and SearchField set to the column of the Excel table.

Now much apart from that... I tried also using a Collection and I can't even get the items to shop in the dropdown of the ComboBox. Also tried using variables using UpdateContext + Default of the ComboBox.

I tried soooooooooooo many things T_T please help.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

MudassarSZ365 591 on at

Like (0)

Report
Copy link

Link copied!
Hi @WorkingRicardo ,
you can try this
// Assuming 'ExcelDataSource' is your Excel table added as a data source ComboBox.Items = ExcelDataSource ComboBox.DisplayFields = ["Name"] ComboBox.SearchFields = ["Name"] DataCard.Update = ComboBox.Selected.Value
If this solution helps you populate your ComboBox correctly, please consider accepting it. 😊

Was this reply helpful? Yes No
WorkingRicardo 853 on at

Like (0)

Report
Copy link

Link copied!

Hi @MudassarSZ365, Yes! all fields are as you said. The problem is not with the items showing up in the ComboBox to search and select and even save, because in the Sharepoint list I can do all that.
The problem comes when I go to edit that Sharepoint item, this field goes back to blank. I tried populating the item with other sources and same error, so its not a problem with the Excel file. I haven't touched much apart from what you told me, so, what else can I try?

Was this reply helpful? Yes No