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

Comments

Post a Comment

Popular posts from this blog

Power Automate | Passing Collections from Power Automate to Power Apps (Revisited)

Image
I revisit an old video I did couple years ago showing how to pass collections from Power Automate to Power Apps.  This time around, I show how to leverage arrays to accomplish the same. This time around you will learn about: Power Apps trigger in Power Automate   Get Rows SQL action   Variables action Select action and Arrays Response action Power Apps Collections To check out my YouTube channel visit: https://youtube.com/user/mgomezb1 LIKE AND SUBSCRIBE!!! Until next post! MG.- Mariano Gomez, MVP
Read more

Why my transactions don't post through GL even when I have the flag selected?

Image
Are you tired of asking why is it that some transactions do post through GL and why some don't? Tired of changing the posting settings to no avail? This issue outta be one of the most confusing issues for users and consultants, new or seasoned alike. If you ever struggle with one issue in GP, please tell me it's this one, because even today, I cannot claim victory over this subject. So let's walk the walk together. What the theory says? According to Part 3, Chapter 13, page 87 of the Microsoft Dynamics GP's System Setup guide, " If you mark the Post Through General Ledger Files option, batches posted in other modules automatically will update the module in which the transactions originated and the appropriate posting accounts in General Ledger. Your transactions will post to General Ledger and not through General Ledger when posting transaction individually (without a batch). " Now lets break it down... It's important to really pay close attention to the t...
Read more

A .NET Framework error occurred during the execution of user-defined routine or aggregate "GetAssignedUsers"

Image
So, I found myself helping a client to troubleshoot a workflow issue. After configuring workflow a few weeks aback and running a few tests without any issues, we applied Microsoft Dynamics GP 2015 R2 January 2016 Hotfix. Now, when the client went to execute the workflow, he received the corresponding email indicating there was a purchase order to approve. He then proceeded to click the Approve hyperlink and the process continued as expected. After clicking the Approve button, the client receive the following error message: The server encountered an error processing the request. See server logs for more details The following shows the error as displayed on the client's screen. At this point, it is worth stating that the workflow ran to completion and the PO appeared completely approved and fine in Dynamics GP, so whatever was causing this error did not seem to interrupt the approval flow. As good troubleshooters, we went to the Event Viewer to check for addi...
Read more