Concat Dropdown SelectedItems and TextInput Value

Like (0) Share

Report

Posted on 24 May 2023 06:44:54 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:

General Questions

I have the same question (0)

All responses (6)

Answers (1)

itzRobin 76 on 24 May 2023 at 10:24:32

Like (0)

Report

Re: Concat Dropdown SelectedItems and TextInput Value

Thank you @WarrenBelz

Was this reply helpful? Yes No
Verified answer

WarrenBelz 149,440 Most Valuable Professional on 24 May 2023 at 10:20:56

Like (0)

Report
Re: Concat Dropdown SelectedItems and TextInput Value

@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 24 May 2023 at 09:39:02

Like (1)

Report

Re: Concat Dropdown SelectedItems and TextInput Value

@zeg i tried your approach but same error

Was this reply helpful? Yes No
itzRobin 76 on 24 May 2023 at 09:36:34

Like (0)

Report

Re: Concat Dropdown SelectedItems and TextInput Value

@WarrenBelz getting error

Was this reply helpful? Yes No
WarrenBelz 149,440 Most Valuable Professional on 24 May 2023 at 08:40:31

Like (0)

Report
Re: Concat Dropdown SelectedItems and TextInput Value

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
zeg 92 on 24 May 2023 at 08:40:24

Like (0)

Report

Re: Concat Dropdown SelectedItems and TextInput Value

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

Hope this helps.

Was this reply helpful? Yes No