Unanswered

Powerapps - Save data table records into SharePoint List (column type - multiple line)

(0) Share

Report

Posted on by JS-JS

Hi All,

Is there any way to allow save the data from Data Table into Share Point List (multiple lines)? Or any other suggestion that can save multiple records into SP list (column type - multiple lines)?

PowerApps

Step 1: Select value from Combo Box

Step 2: Click Add icon (to add into Data table)

Spoiler (Highlight to read)

Add icon OnSelect Property: Collect(collectionABC, {col1: ComboBox1.Selected, col2: ComboBox2.Selected, col3:ComboBox3.Selected});

Step 3: Click Submit button (to add records into SP list)

Expected result in SharePoint List upon clicking Submit button

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @JS-JS ,

There is no DataTable.AllItems type of property that can be used, but you can refer the collection you are displaying in the DataTable:

Patch( 'test powerapps', Defaults('test powerapps'), { column1: collectionABC.col1, column2: collectionABC.col2, column3: collectionABC.col3 } )

Was this reply helpful? Yes No
JS-JS 32 on at

Like (0)

Report

@BCBuizer

Thank you for your reply. However there's some error after added the Patch function in OnSelect property

I'm not really sure what's the error.

Besides, if i change the DataTable to Gallery, is this a better solution to let me save the records into SharePoint List whereby the column type = Multiple lines of text?

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report
Hi @JS-JS ,

I made a sample for you.

1\ My 6 combo boxes items are the same.

My collection:

Submit button:

Patch(LIST287,Defaults(LIST287),{Title:"Test",column1:Concat( ForAll(collectionABC,ThisRecord.col1),Value1,Char(10)),column2:Concat( ForAll(collectionABC,ThisRecord.col2),Value1,Char(10)),column3:Concat( ForAll(collectionABC,ThisRecord.col3),Value1,Char(10))})

Result:

Best Regards,

Wearsky

Was this reply helpful? Yes No
JS-JS 32 on at

Like (0)

Report

Hi, @v-xiaochen-msft

Thank you for your reply. And its works!! But may I know is this logic can be apply on EditForm?

Was this reply helpful? Yes No
JS-JS 32 on at

Like (0)

Report

Hi @v-xiaochen-msft

In my EditForm, I need to save the records into SharePoint List with 1 Person column and 4 Multiple lines of text columns upon clicking Submit button.

Appreciate if you can advice based on my scenario above.

Thank youuu!!

Was this reply helpful? Yes No
JS-JS 32 on at

Like (0)

Report

Hi @v-xiaochen-msft ,

If column type = Choice in SharePoint List, how can we update the value?

Thank you

Was this reply helpful? Yes No
sarojjha 7 on at

Like (0)

Report

ForAll(dtTemp, // This is Temp data table of Power App, which each rows to be inserted into SP List
Patch(
'SP Details', // SP List Name
Defaults('SP Details'),
{
Title: " Title1 ", // Some Static values for all entries
NumberColumn: Value(ThisRecord.NumberCol), // NumberColumn of SharePoint List
Quantity:Value(ThisRecord.Quantity:), // Quantity Column of SharePoint List
Amount:Value(ThisRecord.Amount) // Amount Column of SharePoint List
}
));

Was this reply helpful? Yes No