cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DRocka
Level: Powered On

Passing a multiple choice dropdown values to HTMLText

Hi All,

  I am trying to add a print to email flow and cannot seem to pass the values of multiple choice dropdowns to my HTMLText.  When multiple values are selected, there is an error squiggle under Value.. the error being " Invalid Argument Type. Expecting one of the following: Text, Number, Boolean"

 

I have a dropdown where multiple selections can be made, called "Stations" with 4 choices and am using this "&ThisItem.Station.Value&" to no avail.  Any help would be greatly appreciated.

 

Screen Shot 2018-07-17 at 4.16.54 PM.png

1 ACCEPTED SOLUTION

Accepted Solutions
DRocka
Level: Powered On

Re: Passing a multiple choice dropdown values to HTMLText

Thank you for your suggestions! This is my first PowerApp, and taking care of those spaces is certainly something I will do going forward.

 

"Station.Selected.Value" wasn't working, and ".Value" only worked in the case of a single choice dropdown.  I found a solution using the Concat function that returns all selected values in the output HTML.

 

Screen Shot 2018-07-17 at 10.12.46 PM.png

 

6 REPLIES 6
Super User
Super User

Re: Passing a multiple choice dropdown values to HTMLText

Hi @DRocka. Looks like may be missing the "Selected" term in there. 

 

Try this: 

 

ThisItem.Station.Selected.Value.

Super User
Super User

Re: Passing a multiple choice dropdown values to HTMLText

While I have your ear, a best practice is also to eliminate spaces (" ") from your Sharepoint list column names so you don't have to contend with those pesky "_x0020_" values in your formulas. Smiley Happy

 

Try camelCase or under_scores.

DRocka
Level: Powered On

Re: Passing a multiple choice dropdown values to HTMLText

Thank you for your suggestions! This is my first PowerApp, and taking care of those spaces is certainly something I will do going forward.

 

"Station.Selected.Value" wasn't working, and ".Value" only worked in the case of a single choice dropdown.  I found a solution using the Concat function that returns all selected values in the output HTML.

 

Screen Shot 2018-07-17 at 10.12.46 PM.png

 

Highlighted
Super User
Super User

Re: Passing a multiple choice dropdown values to HTMLText

Wow this is really cool. Can I ask you: Is this a dropdown control or a combobox? It looks like you are selecting multiple items; I've only seen this possible with a combobox. Want to know if i'm missing out on something Smiley Happy

 

Thanks

DRocka
Level: Powered On

Re: Passing a multiple choice dropdown values to HTMLText

It's a combo box! Still familiarizing myself with the various in's and out's of PowerApps, but so far it looks to have alot of potential.

todurant
Level: Powered On

Re: Passing a multiple choice dropdown values to HTMLText

Good job this help me. BTW this also works if you are using a Gallery item with a person lookup. This might help someone else searching for this solution. 

Concat(Gallery_AssignedItems.Selected.'HR Approvers'.DisplayName, DisplayName&", ")

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 432 members 4,619 guests
Please welcome our newest community members: