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

Combine multiple texinputs to one

Hello ,

 

I combined multiply textInput into one ( So I can right only that one into my SharePoint list)  but what I want is to have every text input to be on a separate line . Is there any way I can do that ?  

 

This is what I have done.

Thanasis_1-1610550753514.png

 

I would really appreciate any help. 

 

Thank you 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User III
Super User III

@Thanasis 

Please consider changing your Formula to the following:

Concat([TextInput1, TextInput1_2, TextInput1_3, TextInput1_4], Text & Char(13))

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Super User III
Super User III

@Thanasis 

Sorry, I had a typo in the formula I provided.  Here is the correct formula:

Concat([TextInput1, TextInput1_2, TextInput1_3, TextInput1_4], Value.Text & Char(13))

 

The part in Red is what I forgot to add...

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

4 REPLIES 4
Super User III
Super User III

@Thanasis 

Please consider changing your Formula to the following:

Concat([TextInput1, TextInput1_2, TextInput1_3, TextInput1_4], Text & Char(13))

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Helper I
Helper I

Hello @RandyHayes , That worked .

 

Thank you so much 

Super User III
Super User III

@Thanasis 

Sorry, I had a typo in the formula I provided.  Here is the correct formula:

Concat([TextInput1, TextInput1_2, TextInput1_3, TextInput1_4], Value.Text & Char(13))

 

The part in Red is what I forgot to add...

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Helper II
Helper II

1. Create a multilined enhanced field in SharePoint list
2. In the PowerApps: TextInput field with all the multiple texts seperated by "~"
3. Use Splilt function Set(colSplit,Split(TextInput field,"~"))
4. Insert a htmltext and enter as below:

"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" &
"<tr style='background-color:#efefef'>
</tr>
<tr>" &
Concat(colSplit,
"<td>" & Result & "</td>","</tr><tr>") &
"</Table>"

5. Patch to update the item with the htmltext into the multilined enhanced field in SP

Helpful resources

Announcements
News & Announcements

Community Blog

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

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (8,423)