Create drop down with an another option

(0) Share

Report

Posted on by ED-03090921-0

277

Hi,

I've created a drop-down list with different options and I have an "Other" option that, when selected, opens a text input (TextBox15). The problem is that I can't find the right formula in the update function of my Datacard. At the moment I've put this into the update function but it doesn't work.

If(Text(DataCardValue2.Selected.Value) = "Autres"; 
 {
 Value = TextBox15.Value
 }
; DataCardValue2.Value.Selected)

Can you help me please ?

Categories:

Building Power Apps

All responses (8)

Answers (0)

Sort by

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Eliot_DECRION ,

What is type of column of the data card?
If it is text type, please try this:
If( DataCardValue2.Selected.Value = "Autres"; TextBox15.Text; DataCardValue2.Selected.Value)

Best regards,
Rimmon
ED-03090921-0 277 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @v-mengmli-msft
I tested this but it not working. I used TextBox but mine is with value no text, I think it's for that. And I tested this formula and it's just the middle part which is incorrect (TextBox15.Value)
If(Text(DataCardValue2.Selected.Value) = "Autres"; TextBox15.Value; DataCardValue2.Value.Selected)
I have the error "OptionSetValue waited"
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Eliot_DECRION ,

Could you please show me some screenshots?
ED-03090921-0 277 on at

Like
a
(0)

Report
Copy link

Link copied!

Sure @v-mengmli-msft
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Eliot_DECRION ,

Here is what I got from your Image.

Best regards,
Rimmon
ED-03090921-0 277 on at

Like
a
(0)

Report
Copy link

Link copied!

For the error I'm agree with you @v-mengmli-msft , I think it didn't wait a value when I put "TextBox15.Value", it wants a OptionSetValue .
My column is a choice column with 6 differents choices that I defined in my table. (you can see all with photos)
ED-03090921-0 277 on at

Like
a
(0)

Report
Copy link

Link copied!

For the error I'm agree with you, I think it didn't wait a value when I put "TextBox15.Value", it wants a OptionSetValue .
My column is a choice column with 6 differents choices that I defined in my table. (you can see all with photos)
v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Eliot_DECRION ,

This is because the Choice column in the dataverse is a special type of column and the value returned by the text input does not match the column's expectations. Additionally, even if we change the value of the text input to the appropriate data type, we need to update the value into the choice table as the new option, but new options can only be added manually. Another alternative is to change the options column to a lookup column and then update the new options as new records in the lookup table.

Best regards,
Rimmon