Final day of the internship 🍾

Broad summary of everything achieved during the past 6 months:

• Worked on a CRM project in Dynamics CRM with a team, within a hybrid Agile-Waterfall methodology
• Gleaned a rough idea of how complex a customized CRM system can get with the variety of features requested by a "realistic client"
• Learned lots of technical stuff in Javascript and C# + .NET for implementing advanced functionality
• Got exposed to coding + debugging in Visual Studio
• Wrangled with various flows in Power Automate to assist in scheduled batch processing jobs, when usual workflows in Dynamics CRM don't cut it
• Used Azure DevOps for task management with Kanban + version control of code through remote repositories
• Got used to communicating with MS Teams to coordinate work efforts (especially critical in WFH arrangements)

Can't deny it's been illuminating coming from near-zero background in anything CRM, but it's certainly been challenging having to pick up a lot of stuff (especially coding) on the job💡

Built an a workflow to help Paystack users automate deliveries for their storefront.

https://www.loom.com/share/380a7eb890df4dc983d22010541c6f65

Progress at end of 4th (mock) Sprint:

• More wrangling of C# plugins: implementing a sort of "history log" feature that is useful for auditing
• Wrestling with recurring cloud flows in Power Automate to allow periodic updates of records in the CRM system
• Hammering together logic to calculate working minutes between given times
• Fought as a team tackling the mammoth task of migrating instances + establishing separate development and staging environments

Post Pull Requests from Azure DevOps into Teams!

PowerAutomate has come to the rescue for the second time this week.  We were getting a little bored of creating a PR, copying the link into our chat along with "could someone pleeease.." and trying to find another funny gif.

With PowerAutomate we now have an automated message from the Bot posting into the chat when a PR is created to the main branch, including some nice dynamic content!

Nice win :) 

Just finished working on Google Apps Scripts to automate a very tedious process in Google Sheets. This spreadsheet can now:

• Create folders in Google Drive using the information on the selected row.
• Automatically send emails to a list of email addresses, attaching documents stored in Drive.
• Automatically fills cells with dates and other information.

Now with just a couple of clicks users can send information and fill the spreadsheet easily.

Dabbled a bit with Power Automate Desktop, and quickly whipped up a basic but working flow that simplifies some of the stuff I do outside of work (in this case, extract some info off a webpage with OCR)

Seems nifty being able to automate tasks with low code and without the hoops of installing various libraries + compiling scripts to get some browser automation running