Concat Dropdown SelectedItems and TextInput Value

(0) Share

Report

Posted on by itzRobin

Hi,

I am getting error in the below formula: Expected Record Value.

I have a dropdown ( Market ), user can select multiple and if that option is not found in the dropdown, I have added a text field which shall be updated in the Market dropdown field.

It worked fine but additional requirement is if user selected 3-4 options in the dropdown and also wants to enter text in the textinput field. How can I concatenate multiple values from the dropdown and value in text input field and save it.

update property of the dropdown data card:

If(IsBlank(DataCardValue2.Selected), TextInput.Text, Concat(DataCardValue2.SelecteItems, Value, ",") & 

If ( IsBlank(TextInput1.Text),"", TextInput1.Text & "," ) )

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

zeg 96 on at

Like (0)

Report

@itzRobin
Please try
Concat(DataCardValue2.SelectedItems,Value, ",") & If(!IsBlank(DataCardValue2.Selected)*!IsBlank(TextInput1),",") & TextInput1.Text

Hope this helps.

Was this reply helpful? Yes No
WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report
Hi @itzRobin ,

Maybe you are after this

If( IsEmpty(DataCardValue2.SelectedItems), TextInput.Text, Concat( DataCardValue2.SelectedItems, Value, "," ) & If( !IsBlank(TextInput1.Text), "," & TextInput1.Text ) )

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
itzRobin 76 on at

Like (0)

Report

@WarrenBelz getting error

Was this reply helpful? Yes No
itzRobin 76 on at

Like (1)

Report

@zeg i tried your approach but same error

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,075 Most Valuable Professional on at

Like (0)

Report
@itzRobin ,

If that is a Choice field

{ Value: If( IsEmpty(DataCardValue2.SelectedItems), TextInput.Text, Concat( DataCardValue2.SelectedItems, Value, "," ) & If( !IsBlank(TextInput1.Text), "," & TextInput1.Text ) ) }

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
itzRobin 76 on at

Like (0)

Report

Thank you @WarrenBelz

Was this reply helpful? Yes No