cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Dropdown and Combo Box concatenate

Hai, I am using a screen where it patch the User Input values to the Sharepoint list named "Projects" .

Here I am using

* Dropdown with Static values ["A","B","C","D","E","Other Explain"]. So i added a ""TextInputBox"" to mention for "Others".

2.png

* ComboBox to list Static multiple Values["A","B","C","D","Other Explain"]. So I added a ""TextInputBox"" To mention for "Others".

1.png

Here i need to concatenate the values to the string and


--->if the Values of Dropdown is "Other" have to patch both the drop down values and TextInput Values into the "Project Category"" column in Sharepoint list . If The TextInput box is Blank just patch the Dropdown Selected values alone.

*The Same way If the Combobox related TextInput Box is blank Just To patch the ComboBox.SelectedItems otherwise concat the ComboBox values and TextInput Values and need to patch in the "Project Tools Needed" Sharepoint list Column.

 

Please help .All suggestions are greatly appreciated.

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted

Hi,

 

Sorry there is the 'Value' parameter missing at the end of the concat:

Concat(ForAll(ComboBox1.SelectedItems, Value & If(Value="Other Explain" && Not(IsBlank(TextInput1.Text)), ": "&TextInput1.Text, "")),Value, ", ")

 

Hope this helps,

Alex

View solution in original post

Highlighted

For the dropdown, the code should like similar to this:

Dropdown.SelectedText.Value & If(Dropdown.SelectedText.Value="Other Explain" && Not(IsBlank(TextInput.Text)), ": "&TextInput.Text, "")

 

Hope this helps,

Alex

View solution in original post

5 REPLIES 5
Highlighted
Resolver I
Resolver I

Hi,

 

I believe the following should be along the line of what you are looking:

Patch(
SharepointSource,
item,
{
FieldName: Concat(ForAll(ComboBox.SelectedItems, Value & if(Value="Other Explain" && Not(IsBlank(TextInputBox.Text)), ": "&TextInputBox.Text, "")), ", ")
}
)

 

Hope this helps,

Alex

Highlighted

Thanks for the help. 

 

I have hardcode like this:

3.png

But the output i got is simply Comma "," in sharepoint Column

 

4.png

 

thanks in advance

Highlighted

Hi,

 

Sorry there is the 'Value' parameter missing at the end of the concat:

Concat(ForAll(ComboBox1.SelectedItems, Value & If(Value="Other Explain" && Not(IsBlank(TextInput1.Text)), ": "&TextInput1.Text, "")),Value, ", ")

 

Hope this helps,

Alex

View solution in original post

Highlighted

Thanks that works great. !!🙂

 

 

 

 

 

Highlighted

For the dropdown, the code should like similar to this:

Dropdown.SelectedText.Value & If(Dropdown.SelectedText.Value="Other Explain" && Not(IsBlank(TextInput.Text)), ": "&TextInput.Text, "")

 

Hope this helps,

Alex

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,544)