Thursday, September 3, 2020

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

Credits: Creative Minds - Bensound - Royalty free music at https://www.bensound.com

To check out my YouTube channel visit: https://youtube.com/user/mgomezb1

LIKE AND SUBSCRIBE!!!

Until next post!

MG.-
Mariano Gomez, MVP

No comments: