Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 32

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});
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)

JSJS_5-1667547058889.png

 

Expected result in SharePoint List upon clicking Submit button

JSJS_3-1667546808937.png

 

  • sarojjha Profile Picture
    sarojjha 7 on at
    Re: Powerapps - Save data table records into SharePoint List (column type - multiple line)

    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 
    }
    ));

  • JS-JS Profile Picture
    JS-JS 32 on at
    Re: Powerapps - Save data table records into SharePoint List (column type - multiple line)

    Hi @v-xiaochen-msft ,

     

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

    JSJS_0-1674638047490.png

     

    Thank you

  • JS-JS Profile Picture
    JS-JS 32 on at
    Re: Powerapps - Save data table records into SharePoint List (column type - multiple line)

    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!!

  • JS-JS Profile Picture
    JS-JS 32 on at
    Re: Powerapps - Save data table records into SharePoint List (column type - multiple line)

    Hi, @v-xiaochen-msft 

     

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

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

    Hi  @JS-JS ,

    I made a sample for you.

    1\ My 6 combo boxes items are the same.

    vxiaochenmsft_5-1667553245176.png

     

    My collection:

     

    vxiaochenmsft_6-1667553260805.png

    vxiaochenmsft_7-1667553272426.png

     

    Submit button:

    vxiaochenmsft_8-1667553289535.png

    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:

    vxiaochenmsft_9-1667553306807.png

     

    Best Regards,

    Wearsky

     

  • JS-JS Profile Picture
    JS-JS 32 on at
    Re: Powerapps - Save data table records into SharePoint List (column type - multiple line)

    @BCBuizer 

     

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

    JSJS_0-1667553190846.png

     

    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? 

  • BCBuizer Profile Picture
    BCBuizer 21,809 on at
    Re: Powerapps - Save data table records into SharePoint List (column type - multiple line)

    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
    	}
    )

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard