Announcements
I have built a simple app with data from a SQL server. Is there a way to extract the data from the app and get it into a SharePoint list?
Hi @Anonymous
If you do not need to shape the data you just set the OnSelect property of a button to this:
Collect(MySPList, MySQLServerTable)
If you need to shape the data then just wrap the shaping expressions (Filter, AddColumns, ShowColumns, etc.) around the MySQLServerTable
Hope this helps
I apologize...I am very new to PowerApps and don't completely understand. Do I add a button to the app? Also, do I specify the name of my list and server table or leave as you have it?
Ok, no problems.
Yes, you add a button to the app.
You need to create the connection to SharePoint, unless you have done so already.
You need to add your sharepoint list as a data source to the app before you can use it.
Then yes, please use the names as they appear in the data source list for the app.
Thank you very much for the response. I got that part to work. I have one more question if I may. What do you mean by "wrap the shaping expressions"? If I wanted to specify just the name in my table, how would the correct formula look for that? This is what I have: Collect('Vendor Names','[dbo].[Vendors]') I have a SQL table of Vendors going to a SharePoint list called Vendor Names. I would want to specify just the name in the table.
Collect('Vendor Names',RenameColumns(ShowColumns('[dbo].[Vendors]', MyVendorNameColumnNameInSQLServer), "MyVendorNameColumnNameInSQLServer", "MyVendorNameColumnNameInSharePoint"))
See here
Where probaly MyVendorNameColumnNameInSharePoint is just Title?
PS I advise against including spaces in any list/table/column names, also do not start names with numbers...
Ok, this is what I have: Collect('Vendor Names',RenameColumns(ShowColumns('[dbo].[Vendors]',"Name"),"Name","Vendor Names")) in which I do not get any exclamation point for errors and I published it. When I click the button, it looks like it's working on something but nothing appears in the list. Does it take awhile for items to appear?
Can you confirm that you have a SharePoint list called Vendor Names (with a space) with a text column called Vendor Names (with a space)?
Yes, that is confirmed.
Then please try this:
1. Create a label
2. Start writing First('Vendor Names'). [including the dot at the end]
3. Have a look at what options appear below
In the options should be the name of your Vendor Names field, but it may have special characters to substitute for the space.
Is that correct? If so, that is the name you need to use in PowerApps
Please let me know how you get on.
OK, then please try this:
Create a label in your app and in its Text property start typing First('Vendor Names'). [with a dot at the end]
After you place the dot, you should see a list of options appear below, and it should include some form of Vendor Names with special characters instead of the space.
Is that so?
If that is the case, then that is the column name that you need to use.
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 358 Most Valuable Professional
11manish 214 Super User 2026 Season 2
Mohsin Ali 185
