web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps export data from share...

Power Apps

Answered

export data from sharepoint to sql server in powerapps

(0) Share

Report

Report

Posted on by Community Power Pla...

Is it possible:

to

export data from sharepoint to sql server in PowerApps.

Without using Flow/Automate ?

Just guessing:

SharePoint to a Collection to sql server ?

Thanks

David

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Community Power Pla... on at

Like (0)

Report

Yes, you would use Collect() to pull data from SharePoint, then Collect() again to post it to SQL.
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

example links maybe please ?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (3)

Report
Here is some sample code that loops through a SharePoint list and inserts into a SQL table:
ForAll(MySharePointList,Collect('[dbo].[MySqlTable]',{SqlColumn1:SharePointColumn1,SqlColumn2:SharePointColumn2,SqlColumn3:SharePointColumn3}))
Here is the documentation on the Collect function
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect
If you only want to insert select SharePoint list values, you can use the Filter() function. Here is the docs for that
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
That code would look like this
ForAll(Filter(MySharePointList,MyFilteredColumn=MyFilterCondition),Collect('[dbo].[MySqlTable]',{SqlColumn1:SharePointColumn1,SqlColumn2:SharePointColumn2,SqlColumn3:SharePointColumn3}))
---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Was this reply helpful? Yes No

Join the conversation