web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to save data to sh...
Power Apps
Answered

How to save data to sharepoint?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

How to save data to sharepoint?

 

I have data 4 type (Departname , Team , Name , Date)

I want to save data excel in sharepoint.

 

Please guide me about it.

 

 

 

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    69,383 Most Valuable Professional on at

    Here's a good walkthrough on how to use Power Apps with SharePoint.  PowerApps submit form to SharePoint Online list - SPGuides

     

    But if you are trying to take a set of data that is in Excel and move it to SharePoint then Power Automate is the appropriate application for that.

  • Verified answer
    PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    Hi @Anonymous ,

     

    You can use the below formula format and update the control name and datasource name as per your requirement. I tried to guess the control based on your screenshot but feel free to change it. 

     

    Patch(DataSourceName, Defaults(DataSourceName),{ColumnNameinDataSource: DropDown_name.Selected.ColumnName,ColumnName2inDataSource: DropDown_Team.Selected.ColumnName, ColumnName3inDataSource: DropDown_Department.Selected.ColumnName, ColumnName4inDataSource: DatePicker1.SelectedData	})

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @PriyankaGeethik   If after save save I want popup message text "save completed"

    Please guide me more about it.

  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    Hi @Anonymous ,

     

    You can use Notify function for displaying any message. 

    Notify("Data save completed",Notification.Success)

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @PriyankaGeethik  Set in button save right?

  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    Yes

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

     

    @PriyankaGeethik  Set it on select after patch right ?

     

    Noona_0-1629550793001.png

     

  • PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    @Anonymous  Yes

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

     

    @PriyankaGeethik It error as below.

    Noona_0-1629551418713.png

     

  • Verified answer
    PriyankaGeethik Profile Picture
    3,320 Super User 2024 Season 1 on at

    Hi @Anonymous ,

     

    After Patch() please add separator ';' or ',' which ever depends on your environment. 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 633

#2
11manish Profile Picture

11manish 588

#3
Valantis Profile Picture

Valantis 457

Last 30 days Overall leaderboard