Now Reading: Power Automate: Transfer records from SharePoint list to Azure SQL database
1
-
01
Power Automate: Transfer records from SharePoint list to Azure SQL database
Majority of times, when we are working with various data sources, we want information to go from one source to another, conditioned to the occurrence of an event. Today, I will show you how to transfer records from a SharePoint list to Azure SQL database tables in response to a timesheet approval event. In the process, you will learn how I leveraged the existing Power Apps Expense template app and converted it into a Timesheet app for the purpose of recording time for various activities
Other topics covered:
- Working with SharePoint lists and Azure SQL databases
- “When an item is created or modified” SharePoint connector trigger
- “Delete Item” SharePoint connector action
- “Get Items” SharePoint connector action
- Conditional actions
- Get Rows and Insert Row SQL connector actions
- Apply to each action
- substring(), formatDateTime()
Please leave your comments below and let me know what you think. Also, please feel free to suggest topics you would like me to cover.
References:
Reza Dorrani – Expense Tracking Sample Power App with Receipt Scanning AI – Click here
Reza Dorrani – Expense Tracking Sample Power App with Receipt Scanning AI – Click here
Credits:
Creative Minds – Bensound – Royalty free music at https://www.bensound.com
Creative Minds – Bensound – Royalty free music at https://www.bensound.com
To check out my YouTube channel visit:
https://youtube.com/user/mgomezb1
https://youtube.com/user/mgomezb1
LIKE AND SUBSCRIBE!!!
Until next post!
MG.-
Mariano Gomez, MVP
Original Post http://dynamicsgpblogster.blogspot.com/2020/09/power-automate-transfer-records-from.html
Top Headlines
Support The Site
