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

Share point list Excel to SQL table

I have data in excel (attached image) which will be attached in share point list. When an item is added to that particular share point list I want to run flow and unpivot the data in excel and load it into SQL table (attached image).

Capture.PNGCapture1.PNG

Any help here would be much appreciated!

 

Thank you so much in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

Hi @Anonymous,

 

I afraid that your requirement couldn't be achieved since there is no any way to transfer the date from excel and then insert it to SQL table.

 

You could only consider creating the same table in the excel table and the SQL table, and then you could insert the rows from excel table to  SQL table.

 

Best regards,

Alice

View solution in original post

2 REPLIES 2
v-yuazh-msft
Community Support
Community Support

Hi @Anonymous,

 

I afraid that your requirement couldn't be achieved since there is no any way to transfer the date from excel and then insert it to SQL table.

 

You could only consider creating the same table in the excel table and the SQL table, and then you could insert the rows from excel table to  SQL table.

 

Best regards,

Alice

View solution in original post

Anonymous
Not applicable

Can I create the same table in SQL like in excel using flow?

Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Users online (33,199)