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
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Check out the New Ideas Site

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (5,091)