cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SeteGonz
Frequent Visitor

"Dropdown" powered by excel fails to pass its values to a collection.

The following dropdown is "powered" by an excel file. I want that when I select one of the values in the dropdown and press the add button, my selection is reflected in the collection on the right.

If I type the values in the dropdown manually, my idea works. When I connect the dropdown to excel, it stops working. what am I doing wrong?

 

SeteGonz_0-1621973785853.png

 

SeteGonz_1-1621974613392.png

 

Button OnSelect formula:

Collect(Form2ProgramsDUMMY, {MissingProgramTest: ProductName_1.Text, ProgramsTest: ProgramsDropDownForm2_1.Selected.Value})

1 ACCEPTED SOLUTION

Accepted Solutions

@SeteGonz Try changing to, ProgramsDropDownForm2_1.Selected.'Program List'

If u still get an error please let me know what error it is. Thanks.

View solution in original post

8 REPLIES 8
CNT
Super User
Super User

@SeteGonz Can you put ProgramsDropDownForm2_1.Selected.Value in a label and see what you get.

SeteGonz
Frequent Visitor

@CNT 

Same error:

SeteGonz_0-1621989855180.png

 

@SeteGonz How are you loading the Excel data into the DropDown? What it's in the Items property of the DropDown?

SeteGonz
Frequent Visitor

Items property is "programs"

SeteGonz_0-1622028482049.png

 

@SeteGonz Try changing to, ProgramsDropDownForm2_1.Selected.'Program List'

If u still get an error please let me know what error it is. Thanks.

View solution in original post

CNT
Super User
Super User

@SeteGonz Hope you got is working!

 

Please remember to give a 👍 and accept the solution as it will help others in the future.

SeteGonz
Frequent Visitor

@CNTworking like a charm! Thanks!

@SeteGonz Glad to help!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,046)