Unanswered

Define the options for a dropdown box in a Form

(0) Share

Report

Posted on by Styli

Hello,

I'm currently trying to build a form to add items into a list on SharePoint. I successfully created the form but I need to be able to connect some of the form dropdown boxes to an excel table. I know the simplest way to do this is define the choices of the column on the list itself but the choices are way too many for the list.

Is there any way I could achieve this within the PowerApp environment itself?

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Styli

Import the excel table to powerapps and use it as the datasource of the dropdown.
Styli 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

I can do that if I was using a standalone dropdown box, but I'm using the editform option.

My dropdown currently looks like this:
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Styli,

Could you please tell me that what is the field_5 in your Choices() function? What is the relationship between field_5 and 'Machine Code'?

Here is what I get from your description:

1). You have an edit form connected to the SP list, the 'Machine Code' is a Choice type in your list, right?

2). You want to populate the Machine Code combobox with a column from Excel table, right?

If so, you could set the Items property of the ComboBox with:

Distinct(Table1,ColumnName)

Set the Update property of the data card with:

{Value:ComboBox.Selected.Result}

Further, if you don't plan to refer to the options from the Choices column in your list, there is no need to set it as Choice type, a single-line-of-text is better.
Styli 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

I've tried this step and I can see the options on the box. However when I try to submit the form now I keep getting this error:

Is there any chance you please help me out over a call? I'd be extremely grateful