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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (3,679)