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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,504)