web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Manual entries with ch...

Power Apps

Unanswered

Manual entries with choice column selected values

(0) Share

Report

Report

Posted on by Eeyore2005

119

Dear community,

I have a form connected to SharePoint list.

Several columns are "Choice" types with both- "manual entry" and "multiple selection"- enabled.

What I need is to collect selected choices together with manually written entries into my source data column.

For example, if the user selects options from provided drop-down list and then additionally wants to add an option that is not listed in drop-down, it only saves the options from drop-down. It does not save the manually entered option.

Could you please advise?

Thank you very much in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

WarrenBelz 155,184 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Eeyore2005 ,

To do what you want, the user needs to delete any existing values from the box before typing in the new one and the code should add the item typed in to the ones stored in the data source. This is the Update of the data card - I have tested it and it works.

If( Len(YourComboBox.SearchText) > 0, ForAll( Ungroup( Table( {Data: Table({Value: YourComboBox.SearchText})}, {Data: ThisItem.YourChoiceField} ), "Data" ) As aAdd, {Value: aAdd.Value} ), YourComboBox.SelectedItems )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No

Join the conversation