Answered

Combo box not returning full text input

(0) Share

Report

Posted on by Xabrina123

Hello!

I did create a Combo box recently which didn't return any value at all into Sharepoint list after submit. I have both dropdown choices there and users can type own answers too. After discussion here we did create this formula which finally did work:

Update:

{Value: Coalesce(DataCardValue39.SearchText, DataCardValue39.Selected.Value)}

But whenever users submit answers both (dropdown selection or type in own answers) it returns only the first value of the text, for example they did type Apple iphone 14 it only returned Apple. Is there any way how can i update the formula so after they submit the data to Sharepoint i will have the full name of the product? (whole answer they selected/typed in?)

Thanks,

-X.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

The Coalesce function evaluates its arguments in order and returns the first value that isn't blank or an empty string. I would assume that this is what is happening as a value of "Apple" is obviously not blank. Are you trying to just combine the 2 values in DataCardValue39.SearchText and DataCardValue39.Selected.Value? If so maybe just use an & operator that will work as a concatenation. If not explain what you are trying to do and we can help a little better.

Was this reply helpful? Yes No
Verified answer

NandiniBhagya20 4,667 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Xabrina123 ,
Try using below formula -
{Value: If(IsBlank(DataCardValue39.Selected.Value), DataCardValue39.SearchText, DataCardValue39.Selected.Value)}

Was this reply helpful? Yes No