Answered

Drop down list saves as inputted value instead of selected value

(0) Share

Report

Posted on by angelac

Hello,

I have a "Company Name" drop down menu users are able to manually input to create new options. When I start typing part of the company name then see it drop down (as the option already exists from being added on before) and select the option; after I save and exit it shows the value I had typed in instead of the one selected from the drop down.

Eg.

1. I wish to record "AMCR" as the company name. I type "AM" and see "AMCR" has already been added in before and select it from the drop down.

2. After clicking from the drop down it displays "AMCR" as the selected option

3. After hitting save, it displays in the list as "AM", the original value I had typed in. Despite it appearing to have been selected from the drop down option in the form.

How can I have it display correctly as the option that was selected in the form but still retain the ability for values to be able to be manually added it?

Hope I've explained this well- thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @angelac

Please share the code you have used.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @angelac ,

I would suggest you handle your submitted formula like this: if the user hasn't selected any value from the Combo box, submit the user's search text; if the Combobox.Selected is not empty, then submit Combobox.Selected.

Best Regards,

Bof

Was this reply helpful? Yes No
angelac 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof,
Thanks for your prompt response. May I possibly trouble for a formula example? I'm somewhat semi-beginner with this all 🙂

Was this reply helpful? Yes No
angelac 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Aaron,
Thanks for your quick response. For which section? Apologies still a bit of a beginner at these 🙂

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @angelac ,

Could you please show me the update property of the datacard in your form.

Best Regards,

Bof

Was this reply helpful? Yes No
angelac 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof,
Here it is:
{Value:Coalesce(DataCardValue2.SearchText,DataCardValue2.Selected.Value)}
Thanks

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @angelac ,

Please try this formula:

If( IsBlank(DataCardValue2.Selected), {Value:DataCardValue2.SearchText}, {Value:DataCardValue2.Selected.Value} )

Best Regards,

Bof

Was this reply helpful? Yes No
angelac 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof,

This worked like a charm, you are a legend.

Thank you

Was this reply helpful? Yes No