cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Send Meeting Notes to SQL Rather Than SharePoint

I have an app that currently sends all data related to meetings I attend to SharePoint.  We then pull that data from SharePoint into a Power BI report.

 

I now have the ability to connect directly to SQL from PowerApps.  Can I send my information to SQL rather than the "middle-man" of SharePoint?

 

Thanks.

7 REPLIES 7
Drrickryp
Super User
Super User

Hi @Anonymous 

You will need to have a SQL connector to a table in your SQL account that contains the same fields as your SharePoint list.  Just point your app to the new connector and you should be in business. 

Anonymous
Not applicable

I think I'm following.  Since I'm pulling that data from SP to SQL, the names should be the same.  I'm going to check this out.

Thank you

@Anonymous 

I am not conversant with sql but I suspect that you can move all your old data over from SharePoint as well.

Anonymous
Not applicable

Correct. I can see all of the data currently in SQL.  However, when I point the app to SQL, despite the fields being named the same, the majority of the fields have an error.  *Name isn't valid.

Drrickryp
Super User
Super User

There can be a difference between actual SharePoint column names and display names. You may need to play around with your sql field names to make them match.

Anonymous
Not applicable

Understood.  Thanks!

Drrickryp
Super User
Super User

I'm not at a computer to test but try going into SharePoint and copying the names directly from there. 

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,852)