Code used in research, published by the Depression Center, our partners, and members of MeTRIC.
See our GitHub Repos at:
https://github.com/DepressionCenter
Flatten It uses iteration (no recursion) to flatten iterables into a dictionary where each key is a reference path and each value is the value at the respective path. This simple flattening algorithm has been used for diffing deeply nested JSON structures and for transforming hierarchical data into a tabular data model.
How to capture GitHub repository usage for analysis and visualizations, using PowerShell.
This article is deep dive into MCommunity data and different ways to access it. MCommunity is the University of Michigan's public directory, providing information about people and groups. The directory information is often necessary for day-to-day research study management, day-to-day business operations at centers & institutes, and for automation.
This article explains how to check if an array of objects - in this case from a SharePoint multi-valued lookup column - contains a specific value, and what the data looks like inside Power Automate.
This document presents three different sync approaches between MCommunity and SharePoint Lists that work within the security restrictions of Office 365 and Power Automate, including Microsoft's default Data Loss Prevention (DLP) policy which restricts calling 3rd-party APIs directly.
This article explains the Get Items action in detail, and provides several tips and tricks for filtering data from SharePoint to make Power Automate flows faster by reducing the amount of data being retrieved and leveraging SharePoint's index.
Memoiz provides a function decorator that adds memoization to a function or method. It makes reasonable assumptions about how and if to cache the return value of a function or method based on the arguments passed to the callable.
The RegEx Service allows executing regular expressions in Power Automate or other cloud-based automation tools that do not have support for regular expressions.
Overview of the Sleep Data Automation code, a project developed by the Mobile Technologies Core and the Sleep & Circadian Rhythm Laboratory to automate the process of cleaning sleep data from Fitbit fitness trackers and comparing or joining it to self-reported sleep diary data.