cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
lukebrandt1
Frequent Visitor

Patch a data table to a single multi-line text column in SharePoint

So is there any way to take a data table in PowerApps and patch the whole table into multi-line text field that is sitting in SharePoint?

 

There is always at most 5-6 rows in 2 columns in the data table, so I'm not worried about it being to much data to patch through.

 

Thank you in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
RezaDorrani
Dual Super User II
Dual Super User II

Hi @lukebrandt1 

 

Use the concat function

 

Concat(datasource,Title & Char(13) & Char(13))

 

datasource = same as items property of your data table

 

Lets assume you need column value Title (You can add more columns here if required)

Char(13) is to line break the data 

 

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

 

 

 

View solution in original post

2 REPLIES 2
RezaDorrani
Dual Super User II
Dual Super User II

Hi @lukebrandt1 

 

Use the concat function

 

Concat(datasource,Title & Char(13) & Char(13))

 

datasource = same as items property of your data table

 

Lets assume you need column value Title (You can add more columns here if required)

Char(13) is to line break the data 

 

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

 

 

 

View solution in original post

This worked!  Thank you so much!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,644)